Skip to main content
POST
/
api
/
gsheet
/
proxy
Google Sheets Proxy
curl --request POST \
  --url https://dash.empirical.run/api/gsheet/proxy \
  --header 'Authorization: Bearer <token>' \
  --header 'Content-Type: application/json' \
  --data '
{
  "method": "GET",
  "url": "<string>",
  "body": {}
}
'
{
  "data": {
    "values": [
      ["Name", "Email"],
      ["Alice", "alice@example.com"]
    ]
  }
}
Proxy endpoint to read, write, or append to a Google Sheet via the dashboard’s service account.

​
Finding the spreadsheet ID

The spreadsheet ID is the long string in the Google Sheet URL between /d/ and /edit: 
https://docs.google.com/spreadsheets/d/1uaoEmOYLQqIfZMB7nYnDxikTJyRnqAcZtuvmQ9G7CzY/edit
                                       └─────────────── spreadsheet_id ───────────────┘

​
Read

Returns cell values for the given range. 
{
  "data": {
    "values": [
      ["Name", "Email"],
      ["Alice", "alice@example.com"]
    ]
  }
}

curl -X POST "https://dash.empirical.run/api/gsheet/proxy" \
  -H "Authorization: Bearer $EMPIRICALRUN_KEY" \
  -H "Content-Type: application/json" \
  -d '{"action": "read", "spreadsheet_id": "1uaoE...", "range": "Sheet1!A1:D10"}'

​
Write

Overwrites cells at the specified range. Use an explicit cell range for precise placement (e.g. Sheet1!D6). 
{
  "data": {
    "updated_cells": 4
  }
}

curl -X POST "https://dash.empirical.run/api/gsheet/proxy" \
  -H "Authorization: Bearer $EMPIRICALRUN_KEY" \
  -H "Content-Type: application/json" \
  -d '{"action": "write", "spreadsheet_id": "1uaoE...", "range": "Sheet1!A1:B2", "values": [["Name","Email"],["Alice","alice@example.com"]]}'

​
Append

Appends rows after the last row of data in the sheet.
The append action auto-detects table boundaries and may place data in unexpected columns. For precise cell placement, use the write action with an explicit cell range instead.
{
  "data": {
    "updated_cells": 2
  }
}

curl -X POST "https://dash.empirical.run/api/gsheet/proxy" \
  -H "Authorization: Bearer $EMPIRICALRUN_KEY" \
  -H "Content-Type: application/json" \
  -d '{"action": "append", "spreadsheet_id": "1uaoE...", "range": "Sheet1", "values": [["Charlie","charlie@example.com"]]}'

Authorizations

​
Authorization
string
header
required

API key from the Empirical dashboard.

Body

application/json

Google API request to proxy.

​
method
enum<string>
required
Available options:
GET,
POST,
PUT,
PATCH,
DELETE
​
url
string
required
​
body
object

Response

JSON response from the Google API, wrapped in a data field.