Creating a "Holiday Bot": Using AWS Lambda & Step Functions to Automate Google Sheet Processes Using Python

Level: All

In this talk, we’ll write a very basic Google script to forward Google Sheet and Google Form events onto an AWS Serverless architecture using AWS Lambda (in Python), API Gateway and AWS Step Functions. We’ll expand this Serverless infrastructure to support a multi-step Company Leave Approval system using Slack a custom Slack Bot.

This talk will cover the basics of the AWS Serverless Services, how Lambda Functions can be written in Python & how we can deploy this, as well as the Google Script and Slack App.

We’ll also look at the advantages of encoding all business process and how to lower the barrier to entry for your team to automate more, and reduce wasted time through code!