Google Sheets API Automation in Python
Vložit
- čas přidán 22. 03. 2023
- In this video, we learn how to use the Google Sheets API to automate processes with Python.
Documentation: developers.google.com/sheets/...
◾◾◾◾◾◾◾◾◾◾◾◾◾◾◾◾◾
📚 Programming Books & Merch 📚
🐍 The Python Bible Book: www.neuralnine.com/books/
💻 The Algorithm Bible Book: www.neuralnine.com/books/
👕 Programming Merch: www.neuralnine.com/shop
🌐 Social Media & Contact 🌐
📱 Website: www.neuralnine.com/
📷 Instagram: / neuralnine
🐦 Twitter: / neuralnine
🤵 LinkedIn: / neuralnine
📁 GitHub: github.com/NeuralNine
🎙 Discord: / discord
🎵 Outro Music From: www.bensound.com/ - Věda a technologie
This is it! The tutorial that we've looking for. Very helpful for our new automation project. Looking forward for more automation tutorials. Done subscribe.
I was in the process of setting up an ETCD server for storing just a few shared variables. This would be perfect for our use case! Thanks!
The best video for this topic! Loved it
Thanks, this is super helpful! How can we modify the code so that it gets triggered when there is a change in the sheet?
Love watching you videos on my phone I always need my magnifying glass. Would love to see the text zoomed in a bit.
Amazing! Thank you for enabling me to get the job done so easily and getting me through all of the google api settings
Great explanation! Very valuable, that You took us through the authentication and credential process...thanks!
Great video! If I wanted to automate it even more, how can I trigger this code to run every time a new row gets added or a cell gets updated?
After first excecution on my local machine, script can run on a sever/cloud under cron task for example? In other words: does the authorization process depends on the machine under the script is running?
Excellent tutorial. Thank you!
Great tutorial buddy. You earned a sub
Brilliant tutorial! Thank you, it was superhelpful.
Great! Very Helpful !! Thank You Again !!!
Thank You dear,your typing speed is awosome
thanks for your video, may i ask how to get the lattest row in gspead, 9i want to run log histrory from many devices
I did my first app yesterday using google sheets and looking for a good tutorial to go further. Thank you for the video.
Congrats. Please can you describe what the app does?
@@susanca8443 It was an expance tracker. I used google sheets as a database.
hi, i was using your example but got messed up wityh the security applied (oauth) . is there a way to use service instead???
Awesome video ! Complete explanation, This was the video i was searching for Thanks a ton bro :)
Great introduction, it helped me a lot. Thanks.
Q: Why not use a Service Account instead? If I manage to make it work, I will share the code as a reply to this comment.
At 6:43 when he is storing the file. I don't get the option to store it as a Json File.
For me it autosaves as HTML / text document.
Please can someone help me out? Thanks!
Thats what i was looking for ❤
Thank you so much for your tutorial
Would it be easier with the library called pygsheets? As far as I know, that whole authentication process and data manipulation operations take less amount of code and time. Is there any disadvantages of it? Great video btw, recently discovered the channel as an intermediate python developer, been improving already ^^
Pygsheets and/or gspread worked for me. Can manipulate the chosen cells as a pandas dataframe which makes it really handy!
Thanks a lot, usefull demo.
Awesome video Thanks for this
I got json decoder error. Then, I checked the token.json file was empty after first authintication. I deleted token.json, then retried. it worked. Thank you brother, you really helped
I have an error at 18:50: "No se puede acceder a este sitio webLa página localhost ha rechazado la conexión.
Prueba a:
Comprobar la conexión
Comprobar el proxy y el cortafuegos
ERR_CONNECTION_REFUSED"
24:48 this part gives kind of satisfaction, like a magic
Hey NeuralNine, do you have a video on the Keyboard shortcuts you use while developing in pyCharm? Some of these look really useful!
Only psychos use Pycharm
@@kiwiwelch3620nah pycharm is the best
Does the cloud service sheet api cost anything?
Bro you are great!!
Is it possible to refresh pivot table from python code ?
When I try to run the first code which displays, all the data in the excel; a error occurs saying
'HttpRequest' object has no attribute 'get'
Great tutorial.
thank you alot man!!
Any reason you didn't use gspread? I use it and you install only that. The entire code one just three lines to authenticate and get the data.
Thank you so much!
do you have to pay ? I am really afraid of using Google Cloud
Background:
So I have two gmail accounts. For some reason with one of the email I am not able to create a projects, this being a university email. I created my project with a personal email and wrote a script resembling yours. the sheet is created by university email so the personal one does not have access.
Question:
At what point in your code does it tell which google account is running the code? or does the project creator always need access to the google file even if its another user?
or is it that since i ran the code and when asked for the account, such as you were when you first ran it, I selected the account without access?
just run the
else:
-----------
with ()
the two parts before the try
after i run the script google said :
error : 400 redirect_uri_mismatch google
Does anybody know why googleapiclient does not install in Pycharm?
I think you should use real life case like inventory management system sheet
It is so complicated to set this configuration! Much easier to work via Excel, than this spreadsheets
Hello friend, I think your content is excellent. but, can you make another example of storing data into a G sheet from a list or etc.
Yes, more about Flask
Hello great video, though I followed all the steps and when I try to write to the sheet it gives me an error saying ‘ACCESS_TOKEN_SCOPE_INSUFFICIENT’
did you solve this man?
If you get 'FileNotFoundError', try to specify an absolute path. Replace the "credentials.json" with its absolute file path.
E.g. line 22 could mention "d:\CODEFOLDER\SHEETSPROJECT\credentials.json" instead of just "credentials.json"
Tags : Errno 2. FileNotFoundError . No such file or directory . Folder . Can't Cant Find . Traceback . Same .
excellent.
Hey, man you seems the most intelligent guys among the youtube community.
I am gettint the error message: 400 redirect_uri_mismatch :(
Hello, the following error appears: FileNotFoundError: [Errno 2] No such file or directory: 'credentials.json'. Although the credentials file.json is in the python project folder. Help please
Same problem, have you found the solution?
same thing have you found solution?@@Idk-mk9cg
@@Idk-mk9cg the solution is you need to name that json file he downloads in the beginining credentials and then save it in the directory that you are working in
SPECIFY ABSOLUTE PATH. If anyone else has this error, replace the "credentials.json" with its absolute file path. E.g. line 22 could mention "d:\CODEFOLDER\SHEETSPROJECT\credentials.json" instead of just "credentials.json"
Great tutorial, but I must say, it would be WAY easier to do this natively in Google Apps Script. The merits I see of using python would be to package the code into a Cloud function or something similar, but even then - juice might not be worth the squeeze. For those saying, "I only know Python", Apps Script is a slightly easier version of JS, so it wouldn't be hard for y'all to do what you need to do.
Where's the code in your github? There's a bunch
how can we all all the data and put it in pandas?
awesome
good video
Tbh google app script is much better and more straightforward bcz that's basically its main function, to automate
i keep getting
Traceback (most recent call last):
File "e:\google sheets project\project.py", line 47, in
main()
File "e:\google sheets project\project.py", line 41, in main
values = result.get("values", [])
^^^^^^
NameError: name 'result' is not defined
I'm getting a developer permission error..
I'm getting an error : 'Credentials' has no attribute 'from_authorized_user_file'
use the following:
"from google.oauth2.credentials import Credentials" instead of the line used in the video and it should work
@@jorgeduardo101 holy crap thankyou
хороший , молодец, www забыл
Doesn't work...
👍
I am getting "TimeoutError: [WinError 10060] A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond" when it executes the "result = sheets.values().get(spreadsheetId=SPREADSHEET_ID..." line with firewall off.
18:58 googleapiclient.http.HttpRequest no longer has a method called "get", so the line *values = result.get("values",[]) fails
getting this error:
Traceback (most recent call last):
File "C:\Users\PC\Downloads\GoogleSheets_Project\connect_to_sheets.py.txt", line 45, in
main()
File "C:\Users\PC\Downloads\GoogleSheets_Project\connect_to_sheets.py.txt", line 23, in main
flow = InstalledAppFlow.from_client_secrets_file("credentials.json", SCOPES)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\PC\AppData\Roaming\Python\Python312\site-packages\google_auth_oauthlib\flow.py", line 198, in from_client_secrets_file
with open(client_secrets_file, "r") as json_file:
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
FileNotFoundError: [Errno 2] No such file or directory: 'credentials.json'
[Finished in 1.9s]
I think you should use real life case like inventory management system sheet