Use Python To Import Data to Google Sheets

Hey folks - in this video i'll show you how can import data to your Google Sheets using an API with Python. There's three examples to go through to give you a better understanding and you can also check out the code snippet below :)
00:00 Intro
01:00 Google Credentials Setup
10:10 Read Text File and Import to Sheets
12:30 Fetch API Data and Import to Sheets
14:20 Wrapping Up
gist.github.com/DanielOttodev...
#python #googlesheets #api

Пікірлер: 9

  • @garydunken7934
    @garydunken793425 күн бұрын

    Hi Mate, This video helped me today, thank you. I needed to transfer data from CSV files to GoogleSheets. Initially I struggled to understand Google authentication method, but later with few repeated views and attempts, I got the code to work. Awesome job man.

  • @ZZAudio
    @ZZAudio7 ай бұрын

    Great tutorial! Simple and easy to understand.

  • @delamberty
    @delamberty7 ай бұрын

    Will try this tonight

  • @siddharthchimahiti762
    @siddharthchimahiti7623 ай бұрын

    What to do if we want to input data using our terminal that should be writeen in sheets

  • @sreeshaiyer596
    @sreeshaiyer5966 күн бұрын

    How did you configure your consent screen? I'm stuck at that point.

  • @09alexandr
    @09alexandr4 ай бұрын

    Hello! I am following your guide step by step and faced into Error 403: access_denied. I am chosing the Google account through which I've created the new Google Sheets file. Whould you advise something to have it fixed? Thanks in advance!

  • @kylelyon
    @kylelyon3 ай бұрын

    What should you do when the token expires?

  • @kylelyon

    @kylelyon

    3 ай бұрын

    The script was working for four days then it stopped: google.auth.exceptions.RefreshError: ('invalid_grant: Token has been expired or revoked.', {'error': 'invalid_grant', 'error_description': 'Token has been expired or revoked.'})

  • @waynefilkins8394
    @waynefilkins83943 ай бұрын

    are you a clone