Great video man. First one that actually covered all of the steps. The speed is a little quick, but that's why there is a pause button! Thanks for the great video!
Thanks for the feedback, Chris. I'm glad you found the video helpful! I've found that Google's reference documentation can be kind of hard to follow sometimes. I tried to make the video as concise but complete as possible!
Hey Jay, tried this out and hit an error: oauth2client.client.HttpAccessTokenRefreshError: invalid_grant: Invalid JWT Signature. I looked it up online and have tried everything on StackOverFlow etc, you have any idea why this may come up?
One question though- I'm trying to make a script that prompts a user to input data, which will then send it to a google sheet. I got it on my computer, but if I want to send it to friends to use on the same Sheet (who would need to download python), would they just need to install the correct modules and have the credentials json in the same folder as my script?
(My recommendation at the bottom) To answer your question: Yes, they would have to install python, etc. for that to work. Generally it would be better to have this code running on a webserver, and the user (your friend) would type the information into the website, which would pass data to the webserver. This way they wouldn't need to install python (because the python script is on the server) and you wouldn't need to share private credentials, which could cause security issues. My recommendation: I don't think that you need python for this specific case. Google already has a web tool where you can create input fields which save data to Google sheets. This would be much easier for you to create, and your friend wouldn't need to install any extra tools (they just need to fill out the information on a web page). You can read more about it here: www.howtogeek.com/434570/the-beginners-guide-to-google-forms/
@@JayMartMedia Thanks for the thoughtful reply! Unfortunately for the specific application I'm talking about, google forms would only make things marginally easier than going into the spreadsheet and typing values ourselves, while the script I've written makes it much faster and easier. I don't know a lot about web servers, but I'm thinking that's the next thing I'll be looking into.
This was already posted as a reply from Geronim0, but I want to repost it because it might help someone: make sure the gspread and oauth2client folders are in the folder where your python file is.
Hi, your video is great, that was exacly what i needed to do. Each step is clearly explained and the overall tutorial is very easy to understand and follow!!
You will need to use the update_cell method. It will look something like: sheet.update_cell( 3, 2, xyz) Where 3 is the row, 1 is the column, and xyz is the variable name (notice there are no quotes around the variable name). You can skip to 4:22 in the video to find this code.
Yes you can! To do this you will need to replace the following line: sheet = client.open('PythonSheets').sheet1 With: sheet = client.open('PythonSheets').worksheet("Sheet2") Where Sheet2 is the name of your second sheet, surrounded in quotes. Be default the name of the second sheet will be Sheet2. Let me know if that works for you!
Could you please make a video how to transport information from google sheet to google word. I would like to see solutions about(images, which viewed as links)
Thank you for your encouragement, I'm glad you found the video helpful! I will look into moving data from Google sheets to Google doc's (Google's version of word)
FOR ANYONE WHO IS GETTING AN ERROR SAYING GSPREAD MODULE IS NOT FOUND, when in terminal you type "pip3" instead of pip, so write "pip3 install gspread" instead of just "pip install gspread", and do the same for oauth2client. you're welcome.
U propably already found a solution. But u should always have your installed modules (like oauth2client, gspread, etc.) in the same folder as your python project.
Haha, hopefully you found it helpful! I try to be to the point and not waste people's time. The most frustrating thing is when you watch 7 minutes of a video and then in the 8th minute you find out it's not actually relevant for what you're doing!
scope = ['www.googleapis.com/auth/spreadsheets', "www.googleapis.com/auth/drive.file", "www.googleapis.com/auth/drive"]
Great video man. First one that actually covered all of the steps. The speed is a little quick, but that's why there is a pause button! Thanks for the great video!
Thanks for the feedback, Chris. I'm glad you found the video helpful!
I've found that Google's reference documentation can be kind of hard to follow sometimes. I tried to make the video as concise but complete as possible!
Excellent vid..the best and quickest i've seen
Idk how you were so informative so quickly but I thank you
wow this is so simple and easy and quick to the video without wasting time.
This is perfect, exactly as simple as it needs to be
Great! Thank you for the encouragement
Hey Jay, tried this out and hit an error: oauth2client.client.HttpAccessTokenRefreshError: invalid_grant: Invalid JWT Signature. I looked it up online and have tried everything on StackOverFlow etc, you have any idea why this may come up?
this video is a treasure
One question though- I'm trying to make a script that prompts a user to input data, which will then send it to a google sheet. I got it on my computer, but if I want to send it to friends to use on the same Sheet (who would need to download python), would they just need to install the correct modules and have the credentials json in the same folder as my script?
(My recommendation at the bottom)
To answer your question: Yes, they would have to install python, etc. for that to work. Generally it would be better to have this code running on a webserver, and the user (your friend) would type the information into the website, which would pass data to the webserver. This way they wouldn't need to install python (because the python script is on the server) and you wouldn't need to share private credentials, which could cause security issues.
My recommendation: I don't think that you need python for this specific case. Google already has a web tool where you can create input fields which save data to Google sheets. This would be much easier for you to create, and your friend wouldn't need to install any extra tools (they just need to fill out the information on a web page). You can read more about it here: www.howtogeek.com/434570/the-beginners-guide-to-google-forms/
@@JayMartMedia Thanks for the thoughtful reply! Unfortunately for the specific application I'm talking about, google forms would only make things marginally easier than going into the spreadsheet and typing values ourselves, while the script I've written makes it much faster and easier. I don't know a lot about web servers, but I'm thinking that's the next thing I'll be looking into.
Thanks Men,
you are a god!
The line about creds = just don't work. I've already installed the frameworks requested, or am I mistaken?
This was already posted as a reply from Geronim0, but I want to repost it because it might help someone: make sure the gspread and oauth2client folders are in the folder where your python file is.
That took me like 2 days to fix issue , root is not
enable for 'sheet api '
Hi, your video is great, that was exacly what i needed to do. Each step is clearly explained and the overall tutorial is very easy to understand and follow!!
Great video! Completely to the point.
i have a string variable named "xyz" how to write this value stored inside the varriable "xyz" into the excel sheet ?
You will need to use the update_cell method.
It will look something like: sheet.update_cell( 3, 2, xyz)
Where 3 is the row, 1 is the column, and xyz is the variable name (notice there are no quotes around the variable name).
You can skip to 4:22 in the video to find this code.
Brilliant video!! Very helpful.
Does anyone understand what we are suppose to paste in scope?
How we can do same things for stored excel file in one drive? Please help
Thanks a lot for posting this, Brother.
Really appreciate it. :)
How to color the particulars cell and how to open the sheet 2
Im getting this error ValueError: ('Unexpected credentials type', None, 'Expected', 'service_account')
the code section didn't work a lot of errors are coming....
I get unable to import oauth2client.service_account when trying to do this
Incredible incredible video, thank you so much!
Como envío una tabla pívot de pyton (pandas) a Google sheet
it says I do not have the permission to create a project in the no organization. How can I get around this
huh??? i clicked no orginization and it worked?
I'm getting this error - ValueError: ('Unexpected credentials type', None, 'Expected', 'service_account')
Hi! Can you tell me how to read a spreadsheet created my someone else using the link ?
Can I use this package to ask sheet2？
Yes you can!
To do this you will need to replace the following line:
sheet = client.open('PythonSheets').sheet1
With:
sheet = client.open('PythonSheets').worksheet("Sheet2")
Where Sheet2 is the name of your second sheet, surrounded in quotes. Be default the name of the second sheet will be Sheet2.
Let me know if that works for you!
@@JayMartMedia Excellent!! Thank you for your teaching，it works~
@@JayMartMedia how to color the cell
Thanks a lot! You are really cool teacher!
Could you please make a video how to transport information from google sheet to google word. I would like to see solutions about(images, which viewed as links)
Thank you for your encouragement, I'm glad you found the video helpful!
I will look into moving data from Google sheets to Google doc's (Google's version of word)
FOR ANYONE WHO IS GETTING AN ERROR SAYING GSPREAD MODULE IS NOT FOUND, when in terminal you type "pip3" instead of pip, so write "pip3 install gspread" instead of just "pip install gspread", and do the same for oauth2client. you're welcome.
Second solution if that wont work either: It could be your python admin rights. So, do "pip3 install --user gspread" and the same with oauth2client.
Great video.
thank you so much!
I get an error: cannot import name 'serviceAccountCredentials' from 'oauth2client.service_account'
U propably already found a solution. But u should always have your installed modules (like oauth2client, gspread, etc.) in the same folder as your python project.
@@GeronimOCZECH Oof, this makes so much sense, but I hadn't thought of it until I saw your comment. Thank you!
Amazing video but put the speed at .65 bc this went hella fast but super informative!
Thank you very much.
Very good 👍
Thank you!
is it free?
Very fast video not understandable..😡
first video in my life l had to slow down playback speed
Haha, hopefully you found it helpful!
I try to be to the point and not waste people's time. The most frustrating thing is when you watch 7 minutes of a video and then in the 8th minute you find out it's not actually relevant for what you're doing!