sheets_* — Google Sheets
The Google Sheets tool namespace — reading ranges, the multi-mode write tool (write/append/clear/find-replace), and spreadsheet/sheet management, plus the read-vs-manage routing rule.
Three tools cover Google Sheets: sheets_read (values out), sheets_write
(values in, several modes), and sheets_manage (spreadsheet/sheet structure).
The split trips people up because sheets_manage sounds like it would read or
edit values — it doesn’t.
sheets_read
sheets_read(spreadsheet_id, range=None, value_render_option="FORMATTED_VALUE")| Param | Notes |
|---|---|
spreadsheet_id | Required — the sheet ID from its URL |
range | A1 notation (Full Order List for a whole tab, Sheet1!A1:D for a block). Omit for the default/first sheet. |
value_render_option | FORMATTED_VALUE (default), UNFORMATTED_VALUE (raw numbers), or FORMULA |
Use UNFORMATTED_VALUE when you need to do math on the cells — FORMATTED_VALUE
returns display strings (with currency symbols, thousands separators, etc.).
sheets_write
One tool, four modes via mode.
sheets_write(spreadsheet_id, mode="write", range=None, values=None,
value_input_option="USER_ENTERED", find=None, replace=None)mode | What it does | Key params |
|---|---|---|
write (default) | Set the values in range | range, values |
append | Add rows after the existing data | range, values |
clear | Empty a range | range |
find_replace | Substitute text across the sheet | find, replace |
values is a 2-D array (list of rows). value_input_option defaults to
USER_ENTERED (Sheets parses =FORMULAS, dates, numbers like the UI would);
use RAW to write literal strings without interpretation.
sheets_manage
Structure, not values.
sheets_manage(action, spreadsheet_id=None, title=None, sheet_names=None,
sheet_properties=None)action selects the operation — create a new spreadsheet (with title and
optional sheet_names), add_sheet to an existing one (spreadsheet_id +
sheet_properties), or inspect metadata. It does not read or write cell
values — that’s sheets_read / sheets_write.
Related pages
- RS Ticket Sync — reads the master order list via
sheets_read - drive — Drive files and Docs (but not Sheets values)
- Tools — catalog overview and routing rules