How to use the Google Sheets API in Python

Опубликовано 27 декабря 2023, 22:00

Learn how to ingest Google Sheets data into your Python application using the Google Sheets API with Blondie Bytes. We'll create a program that uses the Google Sheets API to pull product review comments and then the Google Cloud Language API to run sentiment analysis and determine whether the product has an overall good or bad review. In the video, we'll walk through how to set up a project in Google Cloud Platform, discuss different types of authentication that can be used with an API, and use Sublime for writing the code along with the terminal to run the code.

Resources:

Google Sheets API Documentation → goo.gle/3TGe98c
Google API Core Library documentation → goo.gle/3NHCqHb
Google API Client Library for Google Sheets documentation → goo.gle/48upD2H
Starting & completed code → goo.gle/4aD7nWS
Learn more about blondiebytes → goo.gle/3HhnbBb

Subscribe to Google for Developers → goo.gle/developers

Products Mentioned: Google Cloud