Spreadsheet

1.2.1 verified Sat May 09 auth: no python

A Python tool for manipulating Google Spreadsheets. Version 1.2.1 is the latest release. The project appears to be in maintenance mode with no recent updates (last commit in 2019).

pip install spreadsheet

Common errors

error ImportError: No module named gdata ↓

cause Missing required library gdata which is not automatically installed.

fix

Run 'pip install gdata' before using spreadsheet.

error gdata.service.BadAuthentication ↓

cause Google has disabled ClientLogin for many accounts; authentication fails.

fix

Enable 'Less secure app access' or use an App Password if 2FA is enabled, or migrate to OAuth 2.0 based library.

Warnings

breaking Depends on gdata library which is no longer maintained and uses the deprecated Google Data API (not Sheets API v4). May stop working as Google sunsets older APIs. ↓

fix Consider migrating to google-api-python-client with google-auth for Sheets API v4.

gotcha The library uses username/password authentication (Google's ClientLogin) which is now disabled by Google for many accounts (OAuth 2.0 required). Authentication may fail. ↓

fix Use a Google App Password if 2FA enabled, or switch to a modern library like gspread or pygsheets.

Imports

Spreadsheet
wrong
```
import spreadsheet
```
correct
```
from spreadsheet import Spreadsheet
```
Direct import of module does not provide Spreadsheet class
Client
```
from spreadsheet import Client
```

Quickstart

Basic usage: authenticate with Google account, access a worksheet, and update a cell. Note: uses older Google Data API (not Sheets API v4).

from spreadsheet import Spreadsheet
# Requires Google account credentials
sheet = Spreadsheet('username@email.com', 'password')
ws = sheet.worksheet('Sheet1')
ws.update_cell(1, 1, 'Hello World')