> ## Documentation Index
> Fetch the complete documentation index at: https://docs.asteragents.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Google Sheets Tools

> Read, edit, and create Google spreadsheets through the Google Drive connection

## Tool surface

Google Sheets uses three task-oriented tools rather than exposing individual
API methods:

| Tool                   | Use it for                                                                    |
| ---------------------- | ----------------------------------------------------------------------------- |
| `google_sheets_read`   | Spreadsheet/tab metadata and one or more bounded ranges                       |
| `google_sheets_edit`   | Ordered explicit writes, appends, and value clears on an existing spreadsheet |
| `google_sheets_create` | A new spreadsheet with optional tabs and initial values                       |

All require the existing **Google Drive** connection. See the
[Google Drive and Sheets integration guide](/integrations/google-drive) for
authorization modes, limits, safety behavior, examples, and troubleshooting.

With a read-only Drive connection, `google_sheets_read` remains available but
`google_sheets_edit` and `google_sheets_create` are rejected server-side before
any Google mutation. Read-and-write Drive authorization is required for those
two mutation tools.

## Selection guidance

Read before editing when the tab layout or current values are unknown. Use the
returned `modified_time` as `expected_modified_time` when a best-effort
concurrent-edit check is useful. Mutations require explicit spreadsheet IDs and
bounded ranges; `google_sheets_edit` does not infer a clear target.

Use the default `raw` input mode for literal values. Select `user_entered`
explicitly only when formulas and Sheets-style parsing are intended. For
whole-workbook downloads, use `google_drive_download_file`; native Sheets reads
are optimized for selected ranges and cell-level work.