0

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.

pnuts
  • 58,317
  • 11
  • 87
  • 139
rishubk
  • 441
  • 2
  • 8
  • 19
  • 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

1 Answers1

2

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

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('thedude@abid.es', '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