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:
console.develo...
developers.goo...
developers.goo...
www.python.org/
code.visualstu...
developers.goo...
#Python #api #google #sheets #read #write

[@shellbot972]

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

[@unknownentity330]

You are an absolute gent. Experimenting with Google APIs was daunting until being guided so eloquently. Thanks so much

[@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.

[@Swonke]

Agreed. Google's documentation is extremely painful for a beginner. I would no have known that so much of the quickstart.py is useless for a basic get/update script.

[@aidengrayson4056]

you all probably dont care at all but does someone know a trick to log back into an instagram account? I somehow forgot the account password. I love any help you can offer me!

[@ifigetbannedagainyoutubeis2018]

I've found just messing around and trying to build basic things first as i read through the documentation helps me a lot

[@monireachtang712]

I have been struggling with Google APIs for days. Your explanation is so clear and easy to understand. Can't thank you enough.

[@ExcelGoogleSheets]

Great to hear!

[@ilektrokioydio]

I cannot stress it enough how amazing this video is. You explain everything so well and with so much detail. All Google APIs have been making me go crazy and i never managed to use one, until this video! Just amazing work!

[@jamesvandermost3802]

I cannot tell you how great this video is. Literally so much easier to follow than googles documentation. Thank you so much.

[@ExcelGoogleSheets]

Thank You!

[@mansivermani5313]

@@ExcelGoogleSheetshow to reach u on LinkedIn?

[@TheLKStar]

This video is invaluable, this is much harder than I imagined.

[@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!

[@RodrigoLobatorodrigo]

Simply Awesome! I was struggling with google's API instructions and your tutorial made it look sooooo much easier. Thanks a bunch! It really helped me :)

[@ExcelGoogleSheets]

Great to hear!

[@guillaumegeorges4430]

It works pretty well ! I had to install "pip google-api-client" before to run the program

[@diegovel2]

You rock! The Google docs are a mess and your video is insanely clear in comparison. I lost half a day battling with the Google documentation but thankfully you appeared.

[@ExcelGoogleSheets]

👍

[@JbotMischief]

I really like the way you present information, you make concepts accessible to people who may not have a formal technical background. Keep it up, I've learned several genuinely useful techniques/methods from you that I put to use in my work.

[@ExcelGoogleSheets]

Thank You!

[@lanceposthumus318]

thank you so much for this video. it was straightforward to follow and made a lot more sense than reading through the documentation

[@ExcelGoogleSheets]

Great to hear!

[@gers6431]

My problem was making an API -> json. You explenaed it very good and understandeble for the Dutch people. Many thanks for the lessen also with the Python script 👍👍

[@ExcelGoogleSheets]

Great to hear!

[@mateusbrancatodearaujo6671]

Awesome video! I like how you just cut to the chase.

[@kunalyadav9873]

Excellent explanation. Am using the google sheet APIs for the first time and this saved a ton of time. Thanks!

[@amitayudas1411]

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.

[@muratparlak7601]

Very great walkthrough, you also show a bit how you do the digging in the docks. Thank you very much. Gracias Muchas.

[@maximilianposch1000]

A really good explanation for the useless documentation!

[@aiviral_]

WOW. Thank you, you just introduced me to a whole new world. Great explanation and loved the fact that you didn't cut the video so we could see your reasoning and debugging

[@MarthaNelis]

thank you SO much!! i have a deadline next week and this was an essential part of my code. you saved my grade :)

[@emadjabbour]

Thanx man i was working with chatgpt for this matter it didn't work until i watched your video and understood some details thank you so much

[@bhaskarsubramanian7092]

Thanks a lot for making this video. Explains how to access google sheets so much better than the google documentation.

[@nicoloretis6328]

This is really a great level of explanation.

[@marianogonzalez33]

this is actual quality learning

[@marianogonzalez33]

Best tutorial about read and write out there

[@ExcelGoogleSheets]

:)

[@Achiesamablog]

Thank you, this saved much of my time and efforts to simply read from gsheet.

[@Baba_kasih]

Man, this is still work, thank you bro.

[@bobharrison574]

Thanks ... you demystified the approach for me!

[@surathi]

NIce video.. one query - If I use google colab to create script then where to save secret_key.json and how to change our code as I am getting error 'ValueError: Authorized user info was not in the expected format, missing fields client_secret, refresh_token.

[@parkerschlank1713]

Great tutorial. Extremely clear.

[@McBobX]

This is so straight, clear and very helpful!

[@gunkov_egor]

the best tutorial I've ever seen

[@ExcelGoogleSheets]

👍

[@hopaloba800]

Спасибо, брат! Ты лучший!

[@umitsarioz]

Perfect ! Thanks for your effort and clear presentation

[@harshal.rathore]

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

[@ExcelGoogleSheets]

That's Google :)

[@pipeliner8969]

This is gold, thank you!

[@purple5920]

Man i'm not gonna lie you earned your sub from my part. A very nice tutorial i'd absolutely recommend if someone asked me hw to use gsheets and py. Nicely done m8

[@ExcelGoogleSheets]

Thanks for the sub!

[@hola_chelo]

This is a gold mine man, thanks!

[@amor9125]

only clear tutorial i've seen! Thank you so much!

[@ExcelGoogleSheets]

Happy to hear that!

My friend, you're the best! thanks

[@ExcelGoogleSheets]

Thanks!

[@unubiopaluwa]

Thank you so much, your videos are simply the best out there. Thank you

[@netboy1102]

Thank you for all the tutorials. I have learnt alot from the Google sheets and App Script. I realized that there is much more for me to learn. And endless..

[@anumitamondal1320]

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

[@Uxdkkkhcddvbh]

Thank you soo much you are soo brilliant! Most concise, clear, easy to follow, well explained tutorial out there! Can't thank you enough

[@navillion]

Thanks! I can finally create my own stat tracker with this!

[@Retyioaqe]

Thank you for this useful manual, it hepls me a lot!

[@msssouza2]

Thanks... that`s the best tutorial I have found...

[@ExcelGoogleSheets]

Great, thank you!

[@ΣυμεώνΠαπαδόπουλος-λ4ο]

Thank you for your great tutorials, I can't express my gratitude for the knowledge you provide us for free. Because I don't know about APIS and python I had a problem when I tried to install pip. The message was: pip3 : The term 'pip3' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was inclu ded, verify that the path is correct and try again. I would be grateful to anyone who can help. Thank you!

[@ExcelGoogleSheets]

try pip instead of pip3 if you are on windows

[@zdinbalti]

finally did it. thank you for this video. explain everything perfectly.

[@ExcelGoogleSheets]

Great to hear!

[@ramirovaldes4889]

Thanks for making this. It actually works!

[@artstationideas6479]

Wow you explained everything beautifully thank you so much

[@ayanupadhaya6972]

Thank you for, by this thing first I scraped a news site then exported all the news headlines and links in my google sheet, thank a lot...

[@PMS2529]

Can we not write to sheets by authenticating API with API key only? Service account creation or oautj is mandatory to update sheets?

[@KC-hl4oj]

Thanks for this video - very easy to follow and understand 👍

[@ExcelGoogleSheets]

Great to hear!

[@waleedtahir4979]

Thank you very much for this!

[@josuequintero10]

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?

[@basundharasharan5386]

Nice 👍 👍👍

[@jotape5791]

You rock! Was trying to figure this out for a while but this made it very simple :)

[@ExcelGoogleSheets]

Great to hear!

[@navedakther4039]

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

[@olle420]

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

[@vitaliyking994]

You are amazing, you helped me very much.

[@AshSmashReacts]

For get, is there a way to get the values with just the starting point or do you always need to have both?

[@ExcelGoogleSheets]

I think if you skip the argument it gives you the whole worksheet, otherwise you need the specify the range.

[@sejalbadgujar6522]

It was a great help. Thank you.

[@amrihidayatulloh6883]

Very helpful for my project!, thank you mate!

[@vitorguilhermecoutinhodeba3253]

Amazing explanation!

[@ConradBraam]

Very nice tutorial, easy and simple to follow, great job. Still not getting over "PieTon" though.

[@ExcelGoogleSheets]

So what's the correct way?

[@ConradBraam]

@@ExcelGoogleSheets Because the google cloud security setting up is rather complicated, the easy way to get set up i to watch a YT clip like your brilliant one here to get you over the tough bits. It helped a lot. I just had to giggle a lot, in English language, the 'h' is sometimes silent (not pronounced) but in python, it's not, it's a "th" sound, as in "thick". So the world is pronounced like "pie"-"thonn" , because you linger on the "n" a bit. Do keep sharing more of these tech explainer videos, great presentation skills!

[@andresrojasmantilla5736]

This is a very good example, thank you!!

[@suyambulingamr4753]

Thanks for making this, I have a problem with while reading the data(can able to read the data, but the data is not formated) from google spread sheet Sample data 1;03.05.2022 00:12:14;1,04992;1,05079; Column separator is ; but the problem is data's are reading in different format, existing output: 1;03.05.2022 00:12:14;1, 04992;1, 05079; expected output 1 03.05.2022 00:12:14 1,04992 1,05079

[@adamkovalak]

Absolute legend, thank you!

[@rbsfinger]

Another great video. Thank you!

[@abdullohtursunov3380]

Just Fabulous!

[@CraigHollabaugh]

Excellent example, just what I needed. Thanks.

[@sucharithaanumula1849]

Thank you soo much Amazing video Works perfectly !!!!!

[@ExcelGoogleSheets]

:)

[@kian69topgun1]

Hey, what changes to be made if access is to be requested as well to read the spreadsheet?

[@agvg3289]

AWESOME!! Loved IT

[@ExcelGoogleSheets]

Thanks!!

[@miguelmiloro1593]

sous un genio amigo me re ayudo tu tutorial

[@flmnvd]

Very helpful! Thank you!

[@MrToy007]

Hello, excellent video. Thank you. One queston, do you think this will work on microython?

[@ExcelGoogleSheets]

Very likely. Just run pip install and if you don't get any errors then you should be fine.

[@Johnathonaaron]

Great explanation. Thank you.

[@ExcelGoogleSheets]

Glad you liked it

[@gafadin_578]

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

[@carlostasaycosilva7739]

Nice tutorial

[@yuwei5231]

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

[@tarakeshnc7417]

Thank you very much for this video.

[@ExcelGoogleSheets]

👍

[@adrianogoto4904]

Really nice tutorial. Thanks a lot for explaining it

[@ExcelGoogleSheets]

Glad it was helpful!

[@franciscobahamondes1313]

Hello Mr, thanks for your video, it was very helpful! Is there a way to get the data in JSON format instead of list of lists? Thanks

[@ExcelGoogleSheets]

Not sure what you mean by JSON format since this is not JavaScript.

[@MrThiago150]

you could use a dict comprehension to create a python dict since it has a identical structure to json object

[@philgoddard8606]

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...:)

[@ExcelGoogleSheets]

One key should work for both services so long as you setup authorizations scopes correctly.

[@ossama3115]

Great work thanks a lot 😎

[@cibulskia]

so nice and clear

[@ExcelGoogleSheets]

Thank you

[@sambitmohanty4030]

please put out more videos using python

[@shrikantbrahmankar5807]

Thanks, this video helped a lot

[@kebebets]

Massive thank you!!!

[@hirenvora8032]

It helped me a lot! Thanks for the such a wonderful content.

[@MarceloNashiro]

you are awesome, thank you!

[@cobyhong852]

what would be a good way to privatize the json file?

[@samer10101010]

Many thanks ,ur video made my day

[@ExcelGoogleSheets]

Glad to hear that

[@jamespyle6398]

Very nice tutorial! How would you read a local spreadsheet and then write that to the google sheet (then it would be run on a schedule to keep the Google sheet updated)?

[@OmerOmer-xg9kl]

looking for something similar

[@MrThiago150]

you could use pandas (a python package) to read the xlsx/csv from local, transform it into a dataframe, make the necessary transformations and then send it to google sheets using his method :D

[@sikandarkhan2436]

This is Excellent, but i need help with once the document uploaded or updated, how to save commit message (version control) ?? Please help with python script or programming

[@royalwinautomatedsoftware2985]

Hai sir, ur video super. I learn so much ur channel. I have one doubt I'm using excel data python. Excel sheet cells I have created formula. Excel read data python program only copy formula not value. Please help me I need excel rows read values only. Please advise sir.

[@luis96xd]

Excellent video, thank you so much!

[@privatemind]

Thank you! This was so helpful