Sheets API

List, create, and fetch spreadsheet workbooks under /api/sheets.

The sheets endpoints manage spreadsheet workbooks built on query results. Listing and reading need the read scope; creating needs write.

#List sheets

GET /api/sheets — return the sheets the service account can read.

curl https://flax-analytics.com/api/sheets \
  -H "Authorization: Bearer flax_pat_..."

#Create a sheet

POST /api/sheets — create a new sheet. Requires the write scope.

curl https://flax-analytics.com/api/sheets \
  -H "Authorization: Bearer flax_pat_..." \
  -H "Content-Type: application/json" \
  -d '{ "name": "Q1 revenue model" }'

#Get a sheet

GET /api/sheets/{sheetId} — fetch a single sheet by id. Returns 404 if it does not exist or is not visible to the account.