How to Automate Google Sheets with Python

[@mpeguru]

Jake, thanks for your videos. I'm learning Python 100 days of code. Its very cool to see you do these easy projects in a way that makes sense to me.

[@jakeeh]

That’s amazing! I’m so happy you’re enjoying the videos! :)

[@HyperUpscale]

Well DONE!!!

[@jakeeh]

Thank you! :)

[@macavitymacavity126]

Great stuff! I would try to find some time tomorrow to try the assistant proyect.

[@jakeeh]

That’s awesome! Hope this was useful or just fun in some way :)

[@costantinoserafini2252]

@@jakeeh you're awesome

[@jakeeh]

Thank you so much! You’re awesome too 🙂

[@vitaliydominichenko7791]

Well done!

[@jakeeh]

Thank you! 😊

[@ha_nguyen_146]

thank you very much

[@jakeeh]

So happy it helped you in some way :)

[@yixian0716]

hello i am new here may i know is there any difference with Google Sheet Official API?

[@jakeeh]

Do you mean the official API here: developers.google.com/sheets/api/guides/concepts and the one I'm using within App Script? I don't know if it's a 1 to 1 match, but you should be able to do most things from App Script just fine.

[@管理員S]

Excuse me, is there anyting to do with python?

[@jakeeh]

This uses a mix of Python and JavaScript to be able to interface with Sheets so you can control whatever part of it you like. The reason this is so powerful is because the JavaScript part can be called from anything :)

[@jwfans3127]

😮😮😮

[@jakeeh]

Thanks for your comment! Hope you enjoyed the video! :)

[@GohOnLeeds]

Jake mate. Was happily following this tutorial until I get 10 minutes in, and I have to paste the code into some Python code that I have zero prior knowledge of and you don't even mention in this video what it is, lol. Doesn't really qualify as a tutorial unless you tell people what they need to do to make it runnable. Introducing 'random' code half way into the tutorial without introducing it .... not great :-) peace

[@jakeeh]

Hey 👋 That’s a fair point. It’s always a bit of a fight between trying to make the video concise, while still making it useful. Sometimes that means a corner is cut that maybe shouldn’t be. My bad! Rest assured, all of the code for my videos are in the description of the video (and if they’re not they should be). The code for this video is all in the description. Happy to explain any parts that don’t make sense in the comments section too! :)