gspreadsheet 0.1.2

Google Spreadsheets the easy way

A wrapper around a wrapper to get Google spreadsheets to look like csv.DictReader.

If you’re used to working with CSVs or a human, you’ll find that working with Google’s Python API for spreadsheets is so frustrating. With gspreadsheet, you can adapt your existing csv code to work with Google Spreadsheets with just two line changes. As an added bonus, if you alter the dict, those changes get saved back to the original spreadsheet.

Installation

pip install gspreadsheet

Usage

If your old CSV code looked like this:

from csv import DictReader
with open("data.csv") as f:
    reader = Dictreader(f)
    for row in reader:
        process(row)

It would look like this with gspreadsheet:

from gspreadsheet import GSpreadsheet
reader = GSpreadsheet("https://docs.google.com/myspreadsheet",
    email="[e-mail]", password="12345")
for row in reader:
    process(row)

So looking at more examples…

Get a spreadsheet if you know the key and worksheet:

sheet = GSpreadsheet(key='tuTazWC8sZ_r0cddKj8qfFg', worksheet="od6")

Get a spreadsheet if you just know the url:

sheet = GSpreadsheet(url="https://docs.google.com/spreadsheet/"
                         "ccc?key=0AqSs84LBQ21-dFZfblMwUlBPOVpFSmpLd3FGVmFtRVE")

Since just knowing the url is the most common use case, specifying it as a kwarg is optional. Just pass whatever url is in your browser as the first arg.:

sheet = GSpreadsheet("https://docs.google.com/spreadsheet/"
                     "ccc?key=0AqSs84LBQ21-dFZfblMwUlBPOVpFSmpLd3FGVmFtRVE")

Google will also complain if you’re anonymous. Best specify some credentials. Get a spreadsheet as a certain user:

sheet = GSpreadsheet(email="[e-mail]", password="12345",
                     key='tuTazWC8sZ_r0cddKj8qfFg', worksheet="od6")

Then iterate over each row.:

for row in sheet:
    print row
    if row['deleteme']:
        row.delete()  # delete the row from the worksheet
    row['hash'] = md5(row['name'])  # compute the hash and save it back

data = row.copy()   # get the last row as a plain dict
sheet.add_row(data)  # copy the last row and append it back to the sheet

Scary Warnings

I really want to say this is alpha software, but we’ve been using bits and pieces of this for over a year now. Everything is subject to change, even the names.

Similar Python packages

• gspread