Join PyCon JP as a staff with Python! Remote

Abstract

If you're a Pythonista, you've probably experienced the pleasure of automating the boring stuff with Python.
In this talk, I'll be sharing two examples of automation with Python from the PyCon JP staff activities.
1. an alternative to a reminder in Slack to stop when it's due.
2. Slack command which enable to copy a document in a Google Drive template.
You'll learn how to work with Slack and Google Drive in Python.

Description

## 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)

Slides

https://docs.google.com/presentation/d/1uVMYiCewRAVITS7-uw0J9u9F3LTj0w--_vWmzLGr4so/edit?usp=sharing

Speaker

nikkie

- Software engineer in Japan
- Career is in the fourth year after this April
- start python about 1 year ago
- building web applications in Flask at work
- automate some boring stuffs in Python at work
- joined Django Girls Tutorial Japanese translation from May 2018
- Django Girls Workshop (Yokohama, Tokyo) coach in autumn 2018
- self-taught & output-driven
- Django Basic Hands-on based on Django Girls Tutorial Jan & Feb 2019 (in Japanese)
- Kaggle Titanic Hands-on based on PyData.Tokyo Tutorial Mar 2019 (in Japanese)
- Blog: https://nikkie-ftnext.hatenablog.com/
- love anime