Google Sheets - Python API, Read & Write Data

Learn how to use Python and Google Sheets API to read and write data to a spreadsheet with a service account.

Resources:

#Python #api #google #sheets #read #write

[salterrific]

Please continue making these videos. I've tried learning apps script and the APIs on my own and it was very difficult without seeing examples. I don't have a computer science degree, but I do a fair amount of coding for my job and these tutorials have helped tremendously.

[dipinkrishnan]

Really appreciate for creating this video. Was following the Google API docs and went into error loops. Following exactly what you mentioned worked. Thanks a ton. Cheers!

[amitayudas]

great tutorial. highly appreciated. being a novice it took ages to understand it and also tect the code. requesting a follow on tutorial for updating live stock market date on google sheets using python. will be highly appreciated.

[shellbot]

0:00 : Intro
1:53 : Dependancy Installation
3:45 : Authentication
15:25: Reading Data
19:54: Writing Data

[anumitamondal]

Thank you for explaining it so good. You should continue publishing your easy way of explaining more often.

[harshal.rathore]

yeah they do change their UI like crazy fast. difference between a same video 1 year ago and this one is huge.

[navedakther]

Nice Video Sir please make more content how to use the other methods like clear, append using node.js

[josuequintero]

Hello! I have a question regarding the accounts to interact with the API. How could I create accounts for users who are going to access the spreadsheet to save or read information?

[yeskavin]

Thank you so much!

This was really useful :)

[gafadin_]

Hello, I was wondering how you would format cells. Such as background color, text size, text color, merging cells ect.

[yuwei]

may I ask why your method do not need any token.pickle? I haven't use my token for a while and then it is not valid and cause refresh error. I tried but cannot generate new token, always get error

[knalsgtes]

This is awesome, very detailed. Thanks and God bless. Already subscribed :)

[anhthangzoro]

I have a simpler way like this:

We create a sheet, importrange data on to this sheet then use protection (only me) on it. then other people can use this data on other sheets

[dubOZ]

is there a way to extract URL from the text in a cell with this method?

[olle]

hello! i have a problem where my service.spreadsheet() where it says "Instance of 'Resource' has no 'spreadsheets'" can you help me?

[philgoddard]

Thank you! I'm trying now to connect to slides with the spreadsheet data and write to slides from within a single project. Seems like i will have 2 scopes and 2 services and 2 keys? But there's no where I can find that clearly shows how those connect in a single project. I send examples of 2 scopes, and I've tried creating the 2 services just like you've created the one for spreadsheet. But I don't see how to manage the 2 separate keys and I'm getting token errors. Thanks for any advice, example out there in the universe...:)

[mohammadrezatavasoli]

hi Thanks for the videos,
how can write more than one value in same spread sheet?

[morenasandroni]

hey! how can i create an object from this data?

[CraigHollabaugh]

Do you have a video showing the create API?
My create API question. I've taken this example and trying service.spreadsheets().create to work using a service account. My request returns a sheet json doc with ID, I can't open it (I get the browser authorization request blocker) and the sheet doesn't show up in my personal drive.
1. Does create API work with a service account?
2. When created, where does it goes?
3. Can I create a sheet inside a pre-existing folder?
Hope you answer, thanks for this video. My read&write python code worked without issue.

[briannguyen]

Will this work with Jupyter Notebooks also?