Google Sheets - Python API, Read & Write Data

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

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

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

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

[@TheLKStar]

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

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

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

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

👍

[@kunalyadav9873]

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

[@bhaskarsubramanian7092]

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

[@guillaumegeorges4430]

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

[@MarthaNelis]

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

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

[@maximilianposch1000]

A really good explanation for the useless documentation!

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

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

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

[@nicoloretis6328]

This is really a great level of explanation.

[@marianogonzalez33]

this is actual quality learning

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

[@mateusbrancatodearaujo6671]

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

[@Achiesamablog]

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

[@gunkov_egor]

the best tutorial I've ever seen

[@ExcelGoogleSheets]

👍

[@marianogonzalez33]

Best tutorial about read and write out there

[@ExcelGoogleSheets]

:)

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

[@muratparlak7601]

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

[@anumitamondal1320]

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

[@unubiopaluwa]

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

[@McBobX]

This is so straight, clear and very helpful!

[@umitsarioz]

Perfect ! Thanks for your effort and clear presentation

[@amor9125]

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

[@ExcelGoogleSheets]

Happy to hear that!

[@bobharrison574]

Thanks ... you demystified the approach for me!

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

[@Baba_kasih]

Man, this is still work, thank you bro.

[@hola_chelo]

This is a gold mine man, thanks!

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

[@parkerschlank1713]

Great tutorial. Extremely clear.

My friend, you're the best! thanks

[@ExcelGoogleSheets]

Thanks!

[@msssouza2]

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

[@ExcelGoogleSheets]

Great, thank you!

[@hopaloba800]

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

[@jotape5791]

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

[@ExcelGoogleSheets]

Great to hear!

[@pipeliner8969]

This is gold, 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!

[@navillion]

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

[@Retyioaqe]

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

[@ramirovaldes4889]

Thanks for making this. It actually works!

[@artstationideas6479]

Wow you explained everything beautifully thank you so much

[@amrihidayatulloh6883]

Very helpful for my project!, thank you mate!

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

[@sucharithaanumula1849]

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

[@ExcelGoogleSheets]

:)

[@andresrojasmantilla5736]

This is a very good example, thank you!!

[@adamkatarn7413]

Man you're awesome x). Exactly what i needed ! Thanks a lot and keep inspiring people !

[@ExcelGoogleSheets]

Thank You!

[@KC-hl4oj]

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

[@ExcelGoogleSheets]

Great to hear!

[@sejalbadgujar6522]

It was a great help. 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

[@viniciusventuraandreossi792]

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

[@ExcelGoogleSheets]

Thanks for the sub!

[@waleedtahir4979]

Thank you very much for this!

[@basundharasharan5386]

Nice 👍 👍👍

[@rbsfinger]

Another great video. Thank you!

[@CraigHollabaugh]

Excellent example, just what I needed. Thanks.

[@adamkovalak]

Absolute legend, thank you!

[@vitorguilhermecoutinhodeba3253]

Amazing explanation!

[@vitaliyking994]

You are amazing, you helped me very much.

[@agvg3289]

AWESOME!! Loved IT

[@ExcelGoogleSheets]

Thanks!!

[@hirenvora8032]

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

[@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 :)

[@Johnathonaaron]

Great explanation. Thank you.

[@ExcelGoogleSheets]

Glad you liked it

[@adrianogoto4904]

Really nice tutorial. Thanks a lot for explaining it

[@ExcelGoogleSheets]

Glad it was helpful!

[@flmnvd]

Very helpful! Thank you!

[@tarakeshnc7417]

Thank you very much for this video.

[@ExcelGoogleSheets]

👍

[@abdullohtursunov3380]

Just Fabulous!

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

[@shrikantbrahmankar5807]

Thanks, this video helped a lot

[@ossama3115]

Great work thanks a lot 😎

[@miguelmiloro1593]

sous un genio amigo me re ayudo tu tutorial

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

[@MarceloNashiro]

you are awesome, thank you!

[@3dmaxers]

Work like a charm 😉

[@ExcelGoogleSheets]

:)

[@kebebets]

Massive thank you!!!

[@samer10101010]

Many thanks ,ur video made my day

[@ExcelGoogleSheets]

Glad to hear that

[@manojpc9589]

Thanks mate was really helpful

[@ExcelGoogleSheets]

Awesome!

[@martybrals9748]

Thanks a lot, this helped a lot!

[@carlostasaycosilva7739]

Nice tutorial

[@cibulskia]

so nice and clear

[@ExcelGoogleSheets]

Thank you

[@luis96xd]

Excellent video, thank you so much!

[@privatemind]

Thank you! This was so helpful

[@AmritSingh-tr9eb]

This is very awesome!!! Thank you

[@navedakther4039]

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

[@loganathans7388]

Its very Good, thanks for this video.

[@priyankariperali7814]

Thanks so much, this is what I needed!

[@cha1868]

well said. This was really helpful - definitely helpful for beginners trying to ramp up on the API who have already used the read sample but want to understand how to write into google sheets as well.

[@EB-wt7xk]

Thank you so much!

[@esti445]

Amazing! Thanks :)

[@yeskavin]

Thank you so much! This was really useful :)

[@codewithmorris6492]

Thank you master!

[@TKR911]

nicely done. I enjoy your videos, thank you.

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

[@olle420]

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