How to Automate Google Sheets with Python

Опубликовано: 29 Сентябрь 2024
на канале: JakeEh

5,634

142

In this video we go over how you can automate Google Sheets with Python and a little bit of App Script. You don't even need API access or anything fancy to automate so much of your workflows with Google Sheets and a bit of code!

Code:
Assistant Code: https://github.com/Jalsemgeest/Python...
App Script Code: https://github.com/Jalsemgeest/Python...

Thanks for watching! ❤️

Timestamps:
0:00 Intro
0:30 How to interface with Google Sheets
0:56 Creating an App Script script
1:45 Connecting Google Sheets
3:26 doGet Implementation
8:40 Deploying App Script Web App
10:30 Writing to Sheets with Python
12:00 Adding to Bologna Assistant
14:30 How to read from Sheets
14:42 Updating App Script to read the Sheet
16:53 Implementing Sheets read in Python
17:54 Final Example
18:32 Outro