Using Python to write to Google Sheets

Question

I want to take data from a a website using Python, and write it onto the Google Sheets that I own. I searched for a way to do this for like an hour, but can't really find it. I found gdata and gpsread but they both look like they're outdated unless you have a Google Developer account. I may be wrong though.

Can someone tell me a way to do what I'm trying to do without a Google Developer account?

I don't really want to buy one, but if it's the only option, I might.

possible duplicate of [How can I read and edit Google Spreadsheets using Python 3.x?](http://stackoverflow.com/questions/4886052/how-can-i-read-and-edit-google-spreadsheets-using-python-3-x) — Matthew Trevor, Jul 10 '15 at 05:59

score 2 · Accepted Answer · answered Jul 10 '15 at 05:58

2

The library gspread seems to be actively maintained and looks like it works using only standard Google credentials.

answered Jul 10 '15 at 05:58

Matthew Trevor

14,354
6
37
50

I found that also but it looks like it's outdated. See below, which is from the website – rishubk Jul 10 '15 at 06:11
import gspread # Login with your Google account gc = gspread.login('[email protected]', 'password') # WARNING: The code above uses ClientLogin and was disabled # on April 20, 2015. – rishubk Jul 10 '15 at 06:11
The very next line tells you to use OAuth2 instead, and [provides instructions on how to do so](https://github.com/burnash/gspread#authorization-using-oauth2). – Matthew Trevor Jul 10 '15 at 06:12
I know, but doesn't that require a developers account? – rishubk Jul 10 '15 at 06:14
Ah yes, so it does. I'm pretty sure they're free, though, the charges associated are only for running code on AppEngine. – Matthew Trevor Jul 10 '15 at 06:15
there's a 2 month trial, but I want this for the long term – rishubk Jul 10 '15 at 06:19

Using Python to write to Google Sheets

1 Answers1