Google Sheet webhook to send data to S3 bucket as JSON
Budget: $10 – $30 USD
I need someone to write code so that WHEN
A google sheet gets edited
THEN
It will automatically update or create a JSON file on an AWS S3 Bucket.
This might the type of thing where a webhook fires off an AWS Lambda.
I prefer code in TypeScript or JavaScript if possible.
It would be good if the system has a debounce so that it is not updating the JSON for every time a letter gets updated. I should wait and batch the updates somehow.
This should work with any Google Sheet that has column names in first row. It should make column names lowercase as use them as keys in the JSON file. It should also replace in spaces in column name with underscore.
JSON file shall be an array of objects like:
[
{"name": "fred","the_age": 35},
{"name": "Bob","the_age": 55},
]
If the GoogleSheet has 2 columns labeled `Name` and 'The Age'
I can not provide you my credentials so you'll have to have your own access and tokens for AWS S3 and Google Sheets. I will not need your access nor tokens, only the code.
A google sheet gets edited
THEN
It will automatically update or create a JSON file on an AWS S3 Bucket.
This might the type of thing where a webhook fires off an AWS Lambda.
I prefer code in TypeScript or JavaScript if possible.
It would be good if the system has a debounce so that it is not updating the JSON for every time a letter gets updated. I should wait and batch the updates somehow.
This should work with any Google Sheet that has column names in first row. It should make column names lowercase as use them as keys in the JSON file. It should also replace in spaces in column name with underscore.
JSON file shall be an array of objects like:
[
{"name": "fred","the_age": 35},
{"name": "Bob","the_age": 55},
]
If the GoogleSheet has 2 columns labeled `Name` and 'The Age'
I can not provide you my credentials so you'll have to have your own access and tokens for AWS S3 and Google Sheets. I will not need your access nor tokens, only the code.