Google Sheets and Python – Tutorial 2020

///Google Sheets and Python – Tutorial 2020

Google Sheets and Python – Tutorial 2020

FavoriteLoadingAdd 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

By |2020-10-17T10:07:56+00:00October 17th, 2020|Python Video Tutorials|21 Comments

21 Comments

  1. João Neto October 17, 2020 at 10:08 am - Reply

    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?

  2. Apic Productions October 17, 2020 at 10:08 am - Reply

    Thank you! This video helped a lot.

  3. Игорь Быкадоров October 17, 2020 at 10:08 am - Reply

    Thanks a lot, this was very useful for me. Im noob in Python, but i try to create application which uses sheets API

  4. Talha Anwar October 17, 2020 at 10:08 am - Reply

    i dont have create key option

  5. Hans de Corti October 17, 2020 at 10:08 am - Reply

    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

  6. 새벽별 October 17, 2020 at 10:08 am - Reply

    Very useful video. This means a lot to me. I couldn’t have done it without you.

  7. Jose Perez October 17, 2020 at 10:08 am - Reply

    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?

  8. Pipeliner October 17, 2020 at 10:08 am - Reply

    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.

  9. Rayla Kurosaki October 17, 2020 at 10:08 am - Reply

    How do I select a specific sheet?

  10. Ajay Babu October 17, 2020 at 10:08 am - Reply

    what to write if we have sheet name with spaces?

  11. Said Sirazhov October 17, 2020 at 10:08 am - Reply

    Thanks!

  12. 3D Tech October 17, 2020 at 10:08 am - Reply

    Thank you very much

  13. Medialytics Ninja October 17, 2020 at 10:08 am - Reply

    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?

  14. Priscilla Matthews October 17, 2020 at 10:08 am - Reply

    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?

  15. Kang Du October 17, 2020 at 10:08 am - Reply

    when i run it, it got "NameError: name 'credentials' is not defined" does anyone have an idea on why this is happening?

  16. John Reynolds October 17, 2020 at 10:08 am - Reply

    This is great. Would love to see something on conditional formatting.

  17. Andrea Bandiera October 17, 2020 at 10:08 am - Reply

    Hi, I receive thi error
    ('invalid_grant: Invalid JWT Signature.', '{"error":"invalid_grant","error_description":"Invalid JWT Signature."}')
    at this line:
    worksheet = sh.sheet1

  18. Davide Kra October 17, 2020 at 10:08 am - Reply

    Very very useful

  19. Steven Azmeux October 17, 2020 at 10:08 am - Reply

    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?

  20. PYCT CDX October 17, 2020 at 10:08 am - Reply

    Thank you!

  21. Vincent Chen October 17, 2020 at 10:08 am - Reply

    is there a way to switch between the sheets in the google sheets (bottom left corner of the google sheets)

Leave A Comment

*