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"
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!
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
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?
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.
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 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 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 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.
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.
Thank You dear,your typing speed is awosome
Love watching you videos on my phone I always need my magnifying glass. Would love to see the text zoomed in a bit.
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.
18:58 googleapiclient.http.HttpRequest no longer has a method called "get", so the line *values = result.get("values",[]) fails
The best video for this topic! Loved it
Amazing! Thank you for enabling me to get the job done so easily and getting me through all of the google api settings
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"
the best video to learn google sheets api, 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!
Awesome video ! Complete explanation, This was the video i was searching for Thanks a ton bro :)
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.
Thanks, this is super helpful! How can we modify the code so that it gets triggered when there is a change in the sheet?
Does the cloud service sheet api cost anything?
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?
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
Hey, man you seems the most intelligent guys among the youtube community.
Great! Very Helpful !! Thank You Again !!!
Brilliant tutorial! Thank you, it was superhelpful.
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?
Thank you for this video. Is it possible to actually add new rows of data from python, instead of only updating existing rows/cells?
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?
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"
Excellent tutorial. Thank you!
Great tutorial buddy. You earned a sub
hi, i was using your example but got messed up wityh the security applied (oauth) . is there a way to use service instead???
after i run the script google said :
error : 400 redirect_uri_mismatch google
Can you show how to creat tab level user acces management for Google sheets by python
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
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!
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
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'
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.
I think you should use real life case like inventory management system sheet
Where's the code in your github? There's a bunch
Is it possible to refresh pivot table from python code ?
I am gettint the error message: 400 redirect_uri_mismatch :(
Awesome video Thanks for this
Thats what i was looking for ❤
do you have to pay ? I am really afraid of using Google Cloud
Thanks a lot, usefull demo.
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?
Thank you so much for your tutorial
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.
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 .
Bro you are great!!
how can we all all the data and put it in pandas?
Does anybody know why googleapiclient does not install in Pycharm?
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.
Great tutorial.
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
Yes, more about Flask
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'm getting a developer permission error..
thank you alot man!!
Tbh google app script is much better and more straightforward bcz that's basically its main function, to automate
Thank you so much!
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...
excellent.
good video
awesome
Gspread seems better
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.
хороший , молодец, www забыл
👍
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