In this session I'll go over some of the different ways that we use Python scripts (with the gspread library) to leverage Google Workspace tools like Sheets, Forms, and Drive. When used together, you can accomplish quite a lot by improving workflows, building automations, creating data dashboards, and more. We'll discuss some general strategies as well as some of the specific implementations that we (the Peninsula School District) use. If you're from a district looking to start automating or otherwise use Google Workspace apps in your scripting, this could be a good place to start and get some ideas. Or perhaps your district already does similar things - in which case I would love if you could share your use-cases and additional thoughts/suggestions at the end!
