Google Sheets | Operate As Docs

Website: workspace.google.com/products/sheets
Connects by: Signing in with Google
Category: Spreadsheets and databases
Part of: Google
Tools: 19

Service	Key	Base URL
Google Sheets	`sheets`	`https://sheets.googleapis.com`

Connecting

Your client presses Connect on their link and approves on Google's own screen. Operate As never sees their password.

Check they're connected

curl https://api.operate.as/v1/me/clients \
  -H "Authorization: Bearer $OPERATE_AS_API_KEY"

curl https://api.operate.as/v1/me/clients \  -H "Authorization: Bearer $OPERATE_AS_API_KEY"

Response

[
  {
    "id": "6f1c2a7e-...",
    "name": "Miller Dental",
    "services": [
      "sheets"
    ]
  }
]

[  {    "id": "6f1c2a7e-...",    "name": "Miller Dental",    "services": [      "sheets"    ]  }]

Permissions

What the client reads	Permission it asks for
Read, add and edit rows in your spreadsheets	`https://www.googleapis.com/auth/spreadsheets`

Tools

Install Google Sheets's typed package for your language:

pip install operate-as-sheets

pip install operate-as-sheets

Run sheets.add_row

curl -X POST https://api.operate.as/v1/actions/sheets.add_row \
  -H "Authorization: Bearer $OPERATE_AS_API_KEY" \
  -H "Content-Type: application/json" \
  -d '{
    "clientId": "6f1c2a7e-...",
    "input": {
      "spreadsheet_id": "<spreadsheet_id>",
      "range": "<range>",
      "values": []
    }
  }'

curl -X POST https://api.operate.as/v1/actions/sheets.add_row \  -H "Authorization: Bearer $OPERATE_AS_API_KEY" \  -H "Content-Type: application/json" \  -d '{    "clientId": "6f1c2a7e-...",    "input": {      "spreadsheet_id": "<spreadsheet_id>",      "range": "<range>",      "values": []    }  }'

Input	Type	What it is
`spreadsheet_id`required	string	The ID in the sheet's address, after /d/
`range`required	string	Which cells, e.g. Sheet1!A1:D20
`values`required	array	The row's cells, in order

Response

{
  "status": 200,
  "data": {
    "…": "the service's own response"
  },
  "encoding": "json"
}

{  "status": 200,  "data": {    "…": "the service's own response"  },  "encoding": "json"}

Pass-through

Paths continue from https://sheets.googleapis.com. Your Operate As key goes in Authorization; the client's access is added for you.

See Pass-through requests for the full request and response format.

Call any endpoint

curl "https://api.operate.as/v1/clients/6f1c2a7e-.../sheets/..." \
  -H "Authorization: Bearer $OPERATE_AS_API_KEY"

curl "https://api.operate.as/v1/clients/6f1c2a7e-.../sheets/..." \  -H "Authorization: Bearer $OPERATE_AS_API_KEY"

Response

{
  "status": 200,
  "data": {
    "…": "the service's own response"
  },
  "encoding": "json"
}

{  "status": 200,  "data": {    "…": "the service's own response"  },  "encoding": "json"}

When access ends

Operate As renews the sign-in before it runs out and checks it daily. If Google refuses to renew it, the service shows Expired, you're alerted, and your client reconnects from the same link.

See Keeping access alive and Removing access.

Calls answer

HTTP/1.1 409 Conflict
Content-Type: application/json

{
  "detail": "Miller Dental's Google access ended. Send them their link to reconnect."
}

HTTP/1.1 409 ConflictContent-Type: application/json{  "detail": "Miller Dental's Google access ended. Send them their link to reconnect."}

Your webhook receives

{
  "id": "evt_3f9a1c…",
  "type": "connection.expired",
  "createdAt": "2026-10-16T08:00:00+00:00",
  "data": {
    "clientId": "6f1c2a7e-...",
    "clientName": "Miller Dental",
    "provider": "google",
    "services": [
      "sheets"
    ],
    "reconnectUrl": "https://…"
  }
}

{  "id": "evt_3f9a1c…",  "type": "connection.expired",  "createdAt": "2026-10-16T08:00:00+00:00",  "data": {    "clientId": "6f1c2a7e-...",    "clientName": "Miller Dental",    "provider": "google",    "services": [      "sheets"    ],    "reconnectUrl": "https://…"  }}