| name | google-sheets |
| description | Analyze, create, import, edit, and verify Google Sheets with exact tab, range, formula, chart, validation, and formatting awareness through Mail Pounder. Use when Codex must inspect spreadsheet data, search rows, repair formulas, restructure tables, create charts, or apply precise batch updates. |
Google Sheets
Keep every operation grounded in the exact spreadsheet, tab, sheetId, range, headers, formulas, and validation rules.
Workflow
- For a native template or reference, copy the entire workbook with
google_drive_copy_file. Treat a deep-linked gid as the initial view, not the copy scope.
- For new work, use
google_drive_create_file or import a local workbook with google_drive_import_spreadsheet and upload_mode: "native_google_sheets".
- Read
google_drive_get_spreadsheet_metadata before range reads or writes.
- Use exact visible tab names and bounded ranges with
google_drive_get_spreadsheet_range or google_drive_get_spreadsheet_cells. Never guess Sheet1 or scan an unbounded grid.
- Use
google_drive_search_spreadsheet_rows for targeted row discovery.
- Apply formulas, charts, formatting, validation, and structural changes through
google_drive_batch_update_spreadsheet.
- Re-read affected cells, formulas, metadata, and chart definitions after writing.
Safety
- Treat a reference Sheet as read-only unless the user explicitly asks to edit it.
- Preserve native formulas, rich values, validation, formatting, and adjacent populated structure when inserting rows or columns.
- Prefer one planned batch over many disconnected writes, but split fragile operations when readback is needed between them.
- Make headings, number formats, widths, frozen regions, and visual hierarchy scannable when the user requests a polished result.
- Return only the verified Google Sheet URL.
