Sheets: clear range
Input
range requiredA1 range accepted by the name box: "B2:D10", "C3", "A:C", "2:5", or a named range
spreadsheetId requiredSpreadsheet id or any full docs.google.com spreadsheet URL
gid optionalTab gid (from sheets_list_tabs). Default 0.
Default: 0Output
range requiredcleared requiredSheets: 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.
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.
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.