Google Sheets - Python API, Read & Write Data
Вставка
- Опубліковано 5 лют 2025
- 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
Love this guy's personalty and teaching style.
You are an absolute gent. Experimenting with Google APIs was daunting until being guided so eloquently. Thanks so much
I have been struggling with Google APIs for days. Your explanation is so clear and easy to understand. Can't thank you enough.
Great to hear!
0:00 : Intro
1:53 : Dependancy Installation
3:45 : Authentication
15:25: Reading Data
19:54: Writing Data
03:26 Authentication | Create a developer console
04:27 Authentication | Activate Google Sheets API
04:57 Authentication | Create service account
06:21 Authentication | Create service account
07:21 Authentication | Create service account | Create key
09:15 Authentication | Connect service account
11:46 Authentication | Access sheet
12:41 Reading Data
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!
I cannot tell you how great this video is. Literally so much easier to follow than googles documentation. Thank you so much.
Thank You!
@@ExcelGoogleSheetshow to reach u on LinkedIn?
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.
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.
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!
I've found just messing around and trying to build basic things first as i read through the documentation helps me a lot
This video is invaluable, this is much harder than I imagined.
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.
👍
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!
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 :)
Great to hear!
thank you SO much!! i have a deadline next week and this was an essential part of my code. you saved my grade :)
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.
Thank You!
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 👍👍
Great to hear!
Excellent explanation. Am using the google sheet APIs for the first time and this saved a ton of time. Thanks!
A really good explanation for the useless documentation!
Awesome video! I like how you just cut to the chase.
thank you so much for this video. it was straightforward to follow and made a lot more sense than reading through the documentation
Great to hear!
Thanks a lot for making this video. Explains how to access google sheets so much better than the google documentation.
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
Thanks ... you demystified the approach for me!
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
the best tutorial I've ever seen
👍
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.
Best tutorial about read and write out there
:)
This is really a great level of explanation.
this is actual quality learning
Thanks... that`s the best tutorial I have found...
Great, thank you!
Man, this is still work, thank you bro.
It works pretty well !
I had to install "pip google-api-client" before to run the program
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
Thanks for the sub!
Thank you for this useful manual, it hepls me a lot!
My friend, you're the best! thanks
Thanks!
Great tutorial. Extremely clear.
Nice 👍 👍👍
Thank you, this saved much of my time and efforts to simply read from gsheet.
Thank you so much, your videos are simply the best out there. Thank you
Thanks for this video - very easy to follow and understand 👍
Great to hear!
Thank you soo much
Amazing video
Works perfectly !!!!!
:)
only clear tutorial i've seen! Thank you so much!
Happy to hear that!
Thank you for explaining it so good. You should continue publishing your easy way of explaining more often.
Perfect ! Thanks for your effort and clear presentation
Thanks! I can finally create my own stat tracker with this!
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..
This is so straight, clear and very helpful!
This is gold, thank you!
Wow you explained everything beautifully thank you so much
Very great walkthrough, you also show a bit how you do the digging in the docks. Thank you very much. Gracias Muchas.
finally did it. thank you for this video. explain everything perfectly.
Great to hear!
You are amazing, you helped me very much.
This is a gold mine man, thanks!
Thank you soo much you are soo brilliant! Most concise, clear, easy to follow, well explained tutorial out there! Can't thank you enough
Very helpful for my project!, thank you mate!
You rock! Was trying to figure this out for a while but this made it very simple :)
Great to hear!
It was a great help. Thank you.
Amazing explanation!
Thanks for making this. It actually works!
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!
try pip instead of pip3 if you are on windows
Спасибо, брат! Ты лучший!
Great explanation. Thank you.
Glad you liked it
Another great video. Thank you!
Thank you very much for this!
Great work thanks a lot 😎
Really nice tutorial. Thanks a lot for explaining it
Glad it was helpful!
Thank you very much for this video.
👍
Many thanks ,ur video made my day
Glad to hear that
Nice tutorial
This is a very good example, thank you!!
Man you're awesome x). Exactly what i needed ! Thanks a lot and keep inspiring people !
Thank You!
Thank you so much! I have spent a while trying to learn this api and you made it incredibly easy and well explained! +1 sub :))
Thanks for the sub!
Thanks, this video helped a lot
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...
Excellent example, just what I needed. Thanks.
AWESOME!! Loved IT
Thanks!!
Very nice tutorial, easy and simple to follow, great job. Still not getting over "PieTon" though.
So what's the correct way?
@@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!
so nice and clear
Thank you
Thanks mate was really helpful
Awesome!
Work like a charm 😉
:)
Excellent video, thank you so much!
It helped me a lot!
Thanks for the such a wonderful content.
sous un genio amigo me re ayudo tu tutorial
yeah they do change their UI like crazy fast. difference between a same video 1 year ago and this one is huge.
That's Google :)
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
Its very Good, thanks for this video.
Absolute legend, thank you!
Nice Video Sir please make more content how to use the other methods like clear, append using node.js
Can we not write to sheets by authenticating API with API key only? Service account creation or oautj is mandatory to update sheets?
Very helpful! Thank you!
This is very awesome!!!
Thank you
nicely done. I enjoy your videos, thank you.
For get, is there a way to get the values with just the starting point or do you always need to have both?
I think if you skip the argument it gives you the whole worksheet, otherwise you need the specify the range.
This is awesome, very detailed. Thanks and God bless. Already subscribed :)
Awesome, thank you!
Thank you so much!
This was really useful :)
please put out more videos using python
Just Fabulous!
you are awesome, thank you!
Thank you! This was so helpful
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.
Hey, what changes to be made if access is to be requested as well to read the spreadsheet?
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?
Thanks a lot, this helped a lot!