Google Sheets API Automation in Python
Ғылым және технология
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/
Пікірлер: 84
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
Great explanation! Very valuable, that You took us through the authentication and credential process...thanks!
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
Excellent tutorial. Thank you!
Brilliant tutorial! Thank you, it was superhelpful.
Great tutorial buddy. You earned a sub
Thank You dear,your typing speed is awosome
Thanks, this is super helpful! How can we modify the code so that it gets triggered when there is a change in the sheet?
Great! Very Helpful !! Thank You Again !!!
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?
Awesome video ! Complete explanation, This was the video i was searching for Thanks a ton bro :)
I did my first app yesterday using google sheets and looking for a good tutorial to go further. Thank you for the video.
@susanca8443
7 ай бұрын
Congrats. Please can you describe what the app does?
@bozok1903
7 ай бұрын
@@susanca8443 It was an expance tracker. I used google sheets as a database.
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?
Thats what i was looking for ❤
the best video to learn google sheets api, Thanks!
hi, i was using your example but got messed up wityh the security applied (oauth) . is there a way to use service instead???
Thank you so much for your tutorial
thanks for your video, may i ask how to get the lattest row in gspead, 9i want to run log histrory from many devices
Bro you are great!!
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.
Thanks a lot, usefull demo.
24:48 this part gives kind of satisfaction, like a magic
Awesome video Thanks for this
Great tutorial.
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
Does the cloud service sheet api cost anything?
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!
thank you alot man!!
Hey NeuralNine, do you have a video on the Keyboard shortcuts you use while developing in pyCharm? Some of these look really useful!
@kiwiwelch3620
Жыл бұрын
Only psychos use Pycharm
@ifigetbannedagainyoutubeis2018
11 ай бұрын
@@kiwiwelch3620nah pycharm is the best
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 ^^
@completelybear
Жыл бұрын
Pygsheets and/or gspread worked for me. Can manipulate the chosen cells as a pandas dataframe which makes it really handy!
Thank you so much!
Is it possible to refresh pivot table from python code ?
I think you should use real life case like inventory management system sheet
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.
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'
do you have to pay ? I am really afraid of using Google Cloud
after i run the script google said : error : 400 redirect_uri_mismatch google
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"
It is so complicated to set this configuration! Much easier to work via Excel, than this spreadsheets
excellent.
Yes, more about Flask
Does anybody know why googleapiclient does not install in Pycharm?
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?
@javiermorales5884
10 ай бұрын
just run the else: ----------- with () the two parts before the try
awesome
how can we all all the data and put it in pandas?
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.
Hey, man you seems the most intelligent guys among the youtube community.
I am gettint the error message: 400 redirect_uri_mismatch :(
Where's the code in your github? There's a bunch
good video
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’
@paololigori
6 ай бұрын
did you solve this man?
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.
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
@Idk-mk9cg
10 ай бұрын
Same problem, have you found the solution?
@user-xr4th2mw9y
9 ай бұрын
same thing have you found solution?@@Idk-mk9cg
@halasyamv3190
6 ай бұрын
@@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
@sowdah
5 ай бұрын
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"
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 .
I'm getting a developer permission error..
Tbh google app script is much better and more straightforward bcz that's basically its main function, to automate
I'm getting an error : 'Credentials' has no attribute 'from_authorized_user_file'
@jorgeduardo101
Жыл бұрын
use the following: "from google.oauth2.credentials import Credentials" instead of the line used in the video and it should work
@neilorourke814
2 ай бұрын
@@jorgeduardo101 holy crap thankyou
👍
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
Doesn't work...
хороший , молодец, www забыл
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