App Logo
docs.google.com

Sheets: list tabs

Automatically list tabs on docs.google.com. 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.

Input

spreadsheetId required

Spreadsheet id (the /d/<id>/ part) or any full docs.google.com spreadsheet URL

Output

title required

Spreadsheet title

sheets required

FAQ

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.
Ask an AI agent connected to Reduck to run reduck/docs.google.com/sheets_list_tabs, or run it from a terminal with the Reduck CLI: npx @reduck-ai/cli@latest run --script reduck/docs.google.com/sheets_list_tabs
You do not need one. "Sheets: list tabs" drives the real docs.google.com pages in a browser, so it works whether or not docs.google.com offers an API for this.
Required: spreadsheetId.
It returns title, sheets.
Yes. It acts as you on docs.google.com: on your own Chrome it reuses your session, and on a Reduck-hosted browser it loads the docs.google.com cookies saved by the Reduck extension.
It only reads. It looks things up on docs.google.com and changes nothing there.
Ask an AI agent connected to Reduck to run reduck/docs.google.com/sheets_list_tabs, or run it from a terminal with the Reduck CLI: npx @reduck-ai/cli@latest run --script reduck/docs.google.com/sheets_list_tabs
It is part of Reduck's official curated catalogue.

Related scripts

docs.google.com

Create a Google Sheets spreadsheet

Create a new Google Spreadsheet in My Drive, optionally with a title. Returns spreadsheetId, url, and firstGid (always 0). The file lands in Drive root (My Drive); moving it elsewhere is a Drive action, not a Sheets one.

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: write cells

Write a 2D block of values into one tab of a Google Spreadsheet, top-left at startCell, like the Sheets API: null leaves a cell as it is, "" clears it, anything else replaces it as if typed (dropdown rules and formatting stay; clearing a dropdown cell removes its dropdown). Returns range, rows, cols, saved once every edit is saved. A value the sheet refuses (data validation, outside the grid) stops the run with the sheet's own message. Values are parsed per the spreadsheet locale ("1.5" in a FR sheet becomes 1 May; prefix ' to force text); leading = enters a formula; needs edit rights.

Start building not clicking

Get started for free