Automate Google Sheets With Google Sheets API in Python

preview_player
Показать описание
Google Sheets offers a powerful platform for automating tasks, including managing spreadsheets and sending emails directly from your sheets. In this tutorial, we will dive into how to get started with Google Sheets API in Python.

💖 Show Support
☕ Venmo: @Jie-Jenn

00:00 - Use cases
00:30 - Enable Google Sheets API
01:50 - Set up OAuth Consent page
03:44 - Download OAuth2 client secret file
05:25 - Install Python Packages
05:56 - Example. Create a Google Sheet file
13:31 - Example. Read & Write & Clear cells

#googlesheets #python
Рекомендации по теме
Комментарии
Автор

Sorry the code "from google_apis import create_service" that "google_apis" cannot be resolved. I have installed three packages as you said. For now, it has six packages about google in my Python. That are: google-api-core, google-api-python-client, google-auth, google-auth-httplib2, google-auth-oauthlib, googleapis-common-protos. How to solve this problem?

divinerchan
Автор

hmmm i wonder if something similar can be done with smartsheet, gotta look at their api

LawrenceHe
join shbcf.ru