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

# List Google Sheets

> Tabs and header columns of a Google Sheets connection, to set up after-call auto-fill

Two read-only calls that drive the tab → columns picker for [sheet auto-fill](https://docs.60db.ai/features/agents-integrations.md#fill-a-google-sheet-after-each-call). `{id}` is a Google Sheets connection of your workspace. You need the `integration:use` permission.

| Call | Returns |
| - | - |
| `GET /agents/integrations/{id}/google-sheets/tabs?spreadsheet_id=` | `[{ "title" }]` |
| `GET /agents/integrations/{id}/google-sheets/columns?spreadsheet_id=&sheet=` | `[{ "name", "letter", "index" }]` from row 1 (letters go past `Z`: `AA`, `AB`, …) |

`spreadsheet_id` is the sheet's ID or its URL. There is no call that lists your spreadsheets: Google Sheets connects with the `spreadsheets` permission only, so the user pastes the sheet link.

```bash theme={null}
curl https://api.60db.ai/agents/integrations/<id>/google-sheets/columns?spreadsheet_id=<sheet-id>&sheet=Calls \
  -H "Authorization: Bearer your-api-key"
```

```json theme={null}
{ "success": true, "data": [{ "name": "Name", "letter": "A", "index": 0 }, { "name": "Phone", "letter": "B", "index": 1 }] }
```

## Errors

| Status | Code | Meaning |
| - | - | - |
| 400 | `VALIDATION_ERROR` | `spreadsheet_id` or `sheet` is missing or invalid |
| 404 | `INTEGRATION_NOT_FOUND` | Not a Google Sheets connection of your workspace |
| 422 | `INTEGRATION_RECONNECT_REQUIRED` | The Google sign-in cannot read this spreadsheet any more. Reconnect Google Sheets |
| 502 | `INTEGRATION_*` | Google refused or failed, for example `INTEGRATION_AUTH_FAILED` |


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.