How to use the Google Sheets API in Python

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:

Products Mentioned: Google Cloud

[PMS]

Can we also write to sheets with API key or with API key th scope is just ready only?

[sergioinD]

Does this mean using a Q.R. Code to track the performance of the cooler to the vegetable and meat?

[mokimkhan]

Hi I am your new Subscriber 🎉🎉🎉🎉🎉🎉🎉🎉🎉🎉🎉🎉

[Graham_Wideman]

Given the title of the video, this demo is a mess, muddling together two different services and their APIs. This obscures more than illuminates the bare bones needed to just access google sheets. As a side note, the code can't decide whether functions should receive the API_KEY via an argument, or just directly use the global API_Key variable. And then we have "RANGE_NAME", which is not a name for a range, it's a specification for a range in text format. And at that it's fixed. If the demo was going to go beyond the bare bones Google Sheets access, then at least it could have added another feature relevant to Sheets, which is how to spec a range that includes all the available (or contiguous) occupied cells.

[robc-ks]

47 lines of code just to get values. wow....:-/

[Graham_Wideman]

5:18 discussion of "range of values". This is a conceptually harmful way of talking about it. It's NOT a range of values. It's a range of CELLS, for which we want the API to return VALUES (as opposed to formulas).

[dmsalomon]

Not Google's best day in the spelling department

[mukesh_jat]

She already have the code pre written 😅