App Logo
docs.google.com

Sheets: export / download

Download a Google Spreadsheet to a local file in your chosen format. Returns path (or url on cloud browsers) and filename. xlsx/ods/pdf/zip export the whole doc; csv/tsv export a single tab (pass gid).

Input

spreadsheetId required

Spreadsheet id or any full docs.google.com spreadsheet URL

gid optional

Tab gid for csv/tsv (from sheets_list_tabs). Default 0. Ignored for whole-document formats.

Default: 0
format optional

Default xlsx. csv/tsv export a single tab (see gid).

Default: "xlsx"

Output

filename required
url optional

Set instead of path on managed (cloud) browsers

path optional

Local path on the agent machine

Related scripts

docs.google.com

Sheets: rename tab

Rename one tab of a Google Spreadsheet by gid. Returns the gid and the name as displayed after the rename. If no tab in the spreadsheet has that gid it stops with a clear error instead of renaming a different tab. Waits for the editor's save before resolving; needs edit rights.

docs.google.com

Sheets: add tab

Add a tab to a Google Spreadsheet, optionally naming it in the same pass. Returns the new tab's gid and final name. Waits for the editor's save before resolving; needs edit rights.

docs.google.com

Sheets: list tabs

List the tabs of a Google Spreadsheet. Returns sheets (name, gid) and the spreadsheet title. gid feeds sheets_read_tab / sheets_write_cells / the edit?gid= URL.

Start building not clicking

Get started for free