Add to favorites
Learn how to use Google Sheets API in Python. We are using the gspread module for this. It’s super simple to setup a project, and then access and modify our spreadsheet with a Python script. Google Sheets can be pretty powerful and used as a backend to store some data for your web applications.
🚀🚀 JOIN MY NEWSLETTER 🚀🚀
If you enjoyed this video, please subscribe to the channel!
The code can be found here:
Check out gspread documentation here:
You can find me here:
Website:
Twitter:
GitHub:
#Python
source
Huge like, share and thumbsup, your guide is the perfect introduction on Youtube and that's final.
BTW, is there a way to reference columns by their letter instead of number?
Thank you! This video helped a lot.
Thanks a lot, this was very useful for me. Im noob in Python, but i try to create application which uses sheets API
i dont have create key option
very useful! I am just starting out with Python and GoogleSheets, and am looking to read QR-codes, and append the information scanned + time/date for an attendance system.
Love the idea of the data in the cloud, and my task is to get a foolproof input system maybe a raspberry pi headless with a barcode scanner….
Subscribed!
cheers und danke
Very useful video. This means a lot to me. I couldn’t have done it without you.
Thanks a lot for the very useful information!!!! But I have a question do I need to pay for the usage of the api than Google offers me or is it free?
Subscribed! Please make more google apps and python videos! You have good content and are explaining pretty well! Or maybe sync Libre Office Calc with Sheets.
How do I select a specific sheet?
what to write if we have sheet name with spaces?
Thanks!
Thank you very much
How to append all rows of a dataframe in python, to an existing google sheet? I followed till the process, where you mentioned appending one row. But I want to append all rows of a dataframe. Can you help?
I don't know why, but when I'm on the last step of creating the service account for the Google Drive API, the create key is not an option here. What should I do?
when i run it, it got "NameError: name 'credentials' is not defined" does anyone have an idea on why this is happening?
This is great. Would love to see something on conditional formatting.
Hi, I receive thi error
('invalid_grant: Invalid JWT Signature.', '{"error":"invalid_grant","error_description":"Invalid JWT Signature."}')
at this line:
worksheet = sh.sheet1
Very very useful
I tried doing the pip install on the command prompt for my windows laptop and I keep on getting "'pip' is not recognized as an internal or external command, operable program or batch file." any ideas how I can get this to work?
Thank you!
is there a way to switch between the sheets in the google sheets (bottom left corner of the google sheets)