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.
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?
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"
probably better to use the app script built-in extension of google sheets if you want to set a trigger, or use GCP scheduler if you want to use it in python
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!
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.
This comment sent me down the service account rabbit hole and I actually got it to work but with Google Forms, as I find that to be more suitable for my application versus the Google Sheets. Did you ever get yours to work?
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 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"
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 ^^
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?
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 .
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.
I figured it out!! I will explain it below for Others facing the same issue: The above response means that " Python can't find the google module, which ultimately means that the necessary libraries (All or Some) haven't been installed in your environment " To double check this, I used CHATGPT with the following Prompt, ending it with Copy/Pasting the status code error output on my IDE.. here is the prompt: "What does this mean when receiving error in Pycharm IDE trying to import modules for automating Google Sheets: [ PASTE YOU STATUS CODE ERROR OUTPUT] I then could see that I was missing a few modules in order to run the above video time [09:32] successfully. Once all modules was added successfully, I then try'd again and it worked with no errors as seen above!
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.
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
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]
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.
Love watching you videos on my phone I always need my magnifying glass. Would love to see the text zoomed in a bit.
Thank You dear,your typing speed is awosome
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?
18:58 googleapiclient.http.HttpRequest no longer has a method called "get", so the line *values = result.get("values",[]) fails
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?
Amazing! Thank you for enabling me to get the job done so easily and getting me through all of the google api settings
the best video to learn google sheets api, Thanks!
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!
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.
Does the cloud service sheet api cost anything?
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"
Awesome video ! Complete explanation, This was the video i was searching for Thanks a ton bro :)
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?
probably better to use the app script built-in extension of google sheets if you want to set a trigger, or use GCP scheduler if you want to use it in python
Thank you for this video. Is it possible to actually add new rows of data from python, instead of only updating existing rows/cells?
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.
Hey, man you seems the most intelligent guys among the youtube community.
Great explanation! Very valuable, that You took us through the authentication and credential process...thanks!
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!
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
what I don't to use web auth. I want to run the app 100% at the backend, is it possible to just use the API key?
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.
This comment sent me down the service account rabbit hole and I actually got it to work but with Google Forms, as I find that to be more suitable for my application versus the Google Sheets. Did you ever get yours to work?
after i run the script google said :
error : 400 redirect_uri_mismatch google
Great! Very Helpful !! Thank You Again !!!
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"
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'
Brilliant tutorial! Thank you, it was superhelpful.
It is so complicated to set this configuration! Much easier to work via Excel, than this spreadsheets
This can be beneficial for teams. If the sheet has data that the team needs access.
hi, i was using your example but got messed up wityh the security applied (oauth) . is there a way to use service instead???
Is it possible to refresh pivot table from python code ?
thanks for your video, may i ask how to get the lattest row in gspead, 9i want to run log histrory from many devices
U can got the last row by,
sheets = service.spreadsheets()
# 获取电子表格的数据
result = sheets.values().get(
spreadsheetId=sheet_id,
range="Sheet1"
).execute()
# 获取所有数据行
rows = result.get('values', [])
# 找到实际有数据的最后一行
if rows:
last_row_with_data = len(rows)
else:
last_row_with_data = 0
Can you show how to creat tab level user acces management for Google sheets by python
I think you should use real life case like inventory management system sheet
do you have to pay ? I am really afraid of using Google Cloud
Great tutorial buddy. You earned a sub
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!
Excellent tutorial. Thank you!
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?
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
Does anybody know why googleapiclient does not install in Pycharm?
how can we all all the data and put it in pandas?
Where's the code in your github? There's a bunch
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 .
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.
Thats what i was looking for ❤
Awesome video Thanks for this
I am gettint the error message: 400 redirect_uri_mismatch :(
Thanks a lot, usefull demo.
Thank you so much for your tutorial
Bro you are great!!
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.
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
Great tutorial.
Yes, more about Flask
Thank you so much!
I'm getting a developer permission error..
I received the error " ModuleNotFoundError: No module named 'google' " Please help
I figured it out!! I will explain it below for Others facing the same issue:
The above response means that " Python can't find the google module, which ultimately means that the necessary libraries (All or Some) haven't been installed in your environment "
To double check this, I used CHATGPT with the following Prompt, ending it with Copy/Pasting the status code error output on my IDE.. here is the prompt:
"What does this mean
when receiving error in Pycharm IDE
trying to import modules for automating Google Sheets: [ PASTE YOU STATUS CODE ERROR OUTPUT]
I then could see that I was missing a few modules in order to run the above video time [09:32] successfully.
Once all modules was added successfully, I then try'd again and it worked with no errors as seen above!
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.
thank you alot man!!
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
Tbh google app script is much better and more straightforward bcz that's basically its main function, to automate
excellent.
Doesn't work...
awesome
good video
хороший , молодец, www забыл
👍
Gspread seems better
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