Log in to your AWS Console and find AWS Lambda. Click Create a function.

Fill in name for your lambda and choose desired role. I chose a completely new role.

When the lambda is created, upload your zipped folder to the lambda. Click Save from the top right corner after selecting the zip file.

To make sure that everything works fine, click Test, configure new test event, and Create the test. Hello World is good template for us, as our lambda doesn’t take any input.

Click Test and verify that that you see contents of your Sheet.

Yay, we have a working lambda! 💪

Amazon API Gateway

API Gateway is needed to make the lambda visible to the world. Navigate your way to Amazon API Gateway and click New API. Select New API, name it, and click Create API.

Create Resource to your brand new API.

Give name and path to your resource. Remember to check Enable API Gateway CORS, as otherwise front end can’t use the API.

Create Method to your resource.

Select GET as method type.

Choose Lambda Function, fill in its name, and Save it. Make sure to select correct Lambda Region . From popup, agree to Give permissions for API Gateway to invoke your lambda .

Choose Test, and you should see contents of your Sheet.

Now you are ready to Deploy API.

Choose New Stage, give it a name, and you are ready to Deploy!

Now you see your Invoke URL from which you can find your API. Just Save Changes and you are done!

Now head to <invoke_url>/<resource> . My stage was named production and resource was api , so my url ends ...amazonaws.com/production/api . Go to your URL and your API should be ready! 🎉 Now make changes to your Sheets to verify that API is updated immediately.

If you want, you can also set up a custom domain for your API. We didn’t do that as we are quite lazy 😰