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
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.
Great tutorial! Simple and easy to understand.
Will try this tonight
What to do if we want to input data using our terminal that should be writeen in sheets
How did you configure your consent screen? I'm stuck at that point.
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!
What should you do when the token expires?
@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.'})
are you a clone