Automate Google Sheets with Python - Google Sheets API Tutorial
Tech with Tim via YouTube
-
64
-
- Write review
Power BI Fundamentals - Create visualizations and dashboards from scratch
Get Coursera Plus for 40% off
Overview
Coursera Flash Sale
40% Off Coursera Plus for 3 Months!
Grab it
Learn how to automate Google Sheets using Python and the Google Sheets API in this comprehensive tutorial. Set up Google Cloud, generate a service account, grant access to sheets and files, and connect to a spreadsheet. Explore useful documentation, select worksheets, modify cells, locate specific data, and apply basic and advanced formatting. Conclude with a mini project to practice your newly acquired skills in automating Google Sheets for efficient data management and task automation.
Syllabus
| Video Overview
| Google Cloud Setup
| Generating a Service Account
| Granting Access to Sheets/Files
| Connecting to a Sheet
| Useful Documentation
| Selecting Worksheets
| Modifying Cells
| Locating Cells
| Basic Formatting
| Advanced Formatting
| Mini Project/Usage
Taught by
Tech With Tim
Reviews
4.5 rating, based on 2 Class Central reviews
Showing Class Central Sort
-
I have learned many useful knowledge throught this course, which can help me improve working time and efficience. Thanks so much!
-
I recently completed the course Automate Google Sheets with Python - Google Sheets API Tutorial, and I found it to be an incredibly insightful learning experience. The course was well-organized, covering all the essential concepts needed to understa…