Join PyCon JP as a staff with Python! Remote

## Audience takes away - How to post a message to Slack with Python - How to do the above regularly (AWS Lambda) - How to manipulate Google Drive documents with Python - A series of ways to manipulate Google Drive documents from Slack (via Python scripts) - Knowledge of what the PyCon JP staff is doing ## Outline - Introduction (5min) - self-introduction - introduce the activities of the PyCon JP staff - Issue: We use a lot of tools, but I often feel not good enough to some tools - solve issues with original Python scripts - Example 1: Customized Slack reminder（11min） - introduce Slack's reminder feature (enable to post a specified message at a specified time repeatedly) - Not good enough point: we have to stop it manually! - Create a reminder which can end automatically = A Python script that reads a Google spreadsheet and posts messages within a period when a reminder is needed - how to post messages to Slack with Python (urllib) - how to read Google spreadsheets with Python (authlib, gspread) - Introduce AWS Lambda and CloudWatch Events as an environment where we can execute the script regularly - how to deploy on AWS Lambda (Combine third party libraries and source codes and compress to ZIP) - Pitfalls of using third party libraries with AWS Lambda - Example 2: Slack command to copy template Google Docs (11min) - There are staff meetings regularly, and we take minutes each time. - Not good enough point: we have to copy a template manually each time - There's a template for the minutes. -> copy it with a Python script - how to copy a document in Google Drive with Python (PyDrive) - Cool, but a little not good enough: we have to execute the Python script each time - Let's use the Slash command in Slack - how to call AWS Lambda from Slash command (using AWS API Gateway) - how to deploy on AWS Lambda, configure API Gateway - Summary (1min) - Questions and answers (2min)