Access and Edit Google Sheets with Python

Access and edit google sheets with python.

[chrismorgan]

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!

[Mythikal]

Idk how you were so informative so quickly but I thank you

[isb]

Excellent vid..the best and quickest i've seen

[karthickr]

wow this is so simple and easy and quick to the video without wasting time.

[robalexnat]

Hey Jay, tried this out and hit an error: 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?

[logancain]

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.

[nihalhakim]

This is perfect, exactly as simple as it needs to be

[rafaeldanderfer]

The line about creds = just don't work. I've already installed the frameworks requested, or am I mistaken?

[geraldl]

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!!

[DrewMixer]

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.

[kishoreg]

i have a string variable named "xyz" how to write this value stored inside the varriable "xyz" into the excel sheet ?

[pranjalagrawal]

Does anyone understand what we are suppose to paste in scope?

[kartickghosh]

How we can do same things for stored excel file in one drive? Please help

[sambcel]

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?

[muneebbolo]

the code section didn't work a lot of errors are coming....

[jakelamotta]

first video in my life l had to slow down playback speed

[yamininegi]

Im getting this error ValueError: ('Unexpected credentials type', None, 'Expected', 'service_account')

[DrewMixer]

Amazing video but put the speed at .65 bc this went hella fast but super informative!

[hunterpruett]

I get unable to import oauth2client.service_account when trying to do this

[oxytic]

How to color the particulars cell and how to open the sheet 2