App Logo
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.

Input

gid required

gid of the tab to rename (from sheets_list_tabs)

name required

New tab name

spreadsheetId required

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

Output

gid required
name required

Name as displayed after the rename

Related scripts

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.

docs.google.com

Sheets: delete tab

Delete one tab of a Google Spreadsheet by gid. Returns deletedGid and remainingTabs (names left). The sheet's data goes with it (recover via Undo / Drive history); an unknown gid throws rather than risk deleting the wrong sheet; needs edit rights.

Start building not clicking

Get started for free