Suoritettu

Google Sheet webhook to send data to S3 bucket as JSON

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.

Taidot: JavaScript, Google Sheets, AWS Lambda

Näytä lisää: send data google calendar rss feed, send data excel sheet asp form, send data json server, send data google maps arduino, send data html google spreadsheet, android json php send data, how to send data from arduino to google docs spreadsheet 2017, send data to google spreadsheet from android, send data to google spreadsheet, how to send data to google cloud, javascript send data to google spreadsheet, send data to google spreadsheet from android studio, get data from firebase and add to a google spreadsheet, google script to send sheet as pdf, google sheets script import data from another sheet, how to send data from android to php using json, how to send data in json format, read data from database and write to a text file in java, vba to append data from multiple excel worksheets into a single sheet by row, how to write on a google doc

Tietoa työnantajasta:
( 7 arvostelua ) Lithia, United States

Projektin tunnus: #31826189

Myönnetty käyttäjälle:

James0176

Hey I can do this. I have my own credentials and will give you fully tested code. Hope to work for you

$25 USD 7 päivässä
(0 Arvostelua)
0.0

4 freelanceria on tarjonnut keskimäärin $26 tähän työhön

ivanlysundev

Hello. Nice to see you. I saw the description of your project. As you know, I am a new freelancer. I am a freelancer with perfect abilities. Talk to me and you will know everything about me. I always guarantee my abili Lisää

$25 USD 1 päivässä
(1 arvostelu)
1.0
sellamabderrahma

Hello, I am individual full stack developer in web/mobile applications i have 4 years of experience in both web and mobile. So I am sure that I am right for this project. i'm waiting for your reply.

$25 USD 7 päivässä
(0 arvostelua)
0.0
minhajarefeen

Hi, My name is Minhaj Arefeen. I see that you need to Google Sheet webhook to send data to S3 bucket as JSON. I am a certified AWS Solution Architect I have working experience of around 5+ years as an AWS Solutions Ar Lisää

$30 USD 3 päivässä
(0 arvostelua)
0.0