The main repository of this project lives at https://code.pecheny.me/pecheny/google_sheet_writer. All issues should be created there.

google_sheet_writer

google_sheet_writer is an object-oriented wrapper around (amazing!) gspread and gspread_formatting that allows to programmatically create Google Sheets tables in an easy way.

On top of being convenient, it strives to minimize the amount of requests to save API quota.

Install in development mode: pip install -e .

See examples in examples folder.

The examples assume United Kingdom spreadsheet locale (can be changed in File → Settings prior to launching generation script). Other locales (e.g. Russia) might not work.

Version history

v0.0.8

• Batch API calls for dramatically faster spreadsheet generation (especially 10+ sheets)
  • Worksheet creation/deletion batched into a single API call instead of one per sheet
  • Cell values for all sheets written in one values_batch_update call
  • Sheet resizing via updateSheetProperties instead of writing empty cells
  • Formatting and structural requests merged into a single batch_update call
  • Worksheet hiding folded into the formatting batch

v0.0.7

• After successfully finishing table generation, a link to the table is printed to the console

v0.0.6

• Raise exception if users tries to set cursor's x/y attributes to floats

v0.0.5

• Added support for older pythons (3.9 and newer)