gspread

Features:

Google Sheets API v4.

Open a spreadsheet by title, key or url.

Read, write, and format cell ranges.

Sharing and access control.

Batching updates.

インストール

$ pip install gspread

簡単な使い方

code:py

import gspread

gc = gspread.service_account()

# Open a sheet from a spreadsheet in one go

wks = gc.open("Where is the money Lebowski?").sheet1

# Update a range of cells using the top left corner address

# Or update a single cell

wks.update('B42', "it's down there somewhere, let me take another look.")

# Format the header