App Logo
docs.google.com

Sheets: read tab values

Read one tab of a Google Spreadsheet as a 2D array of display values. Returns values (row-major, '' for empty and non-top-left merged cells), nRows, nCols. Values are display strings after formatting (a date may read as "1.5").

Input

spreadsheetId required

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

gid optional

Tab gid (from sheets_list_tabs). Default 0 (first tab).

Default: 0

Output

nCols required
nRows required
values required

Row-major display values; '' for empty cells and non-top-left cells of merges

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