Invoke a AWS Lambda function via Google App Script

Question

I need to invoke an AWS Lambda function from within a Google Sheet following any changes to the spreadsheet. I have a Google App Script that executes when any changes are made to the spreadsheet but need an http request to trigger a Lambda function.

The Lambda function will be NodeJS and contain a gsjson package (that converts a Google Sheet to JSON) and then move the newly created JSON file to S3 using either S3Cmd or trigger another S3 Lambda function that can move files to S3 buckets:

Google Sheet->Google App Script->Trigger AWS API Gateway?

Lambda function(NodeJS)->gsjson npm module->Create JSON file->Move JSON file to S3 bucket

What action/trigger can be used to invoke a Lambda function/AWS Gateway API from inside a Google App Script?

Raphael Rafatpanah · Accepted Answer · 2017-08-25 18:46:40Z

4

What action/trigger can be used to invoke a Lambda function/AWS Gateway API from inside a Google App Script?

An HTTP request to an AWS API Gateway endpoint (aka GET/POST/etc. some URL) would work. API Gateway can be configured to trigger a Lambda function whenever that endpoint is invoked.

Take a look at the docs.

Here is a relevant AWS Tutorial series to complement.

answered Aug 25, 2017 at 18:46

Raphael Rafatpanah

20.2k28 gold badges106 silver badges176 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

sigur7 Over a year ago

Thanks Raphael. Any syntax ideas for the HTTP request in the Google App Script? Is it just a case of pointing to the webhook URL within the Google App Script?

Raphael Rafatpanah Over a year ago

This may help: developers.google.com/apps-script/reference/url-fetch/…

Collectives™ on Stack Overflow

Invoke a AWS Lambda function via Google App Script

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related