Concepts

BlazeSheets separates account setup from the public JSON surface your apps call.

Connection

A connection is a linked Google account (OAuth). It lets the console browse spreadsheets and create Google Sheets datasources. It is not the ID in public URLs.

Datasource

A datasource binds one workbook:

• google_sheets — a spreadsheet ID plus connection credentials
• excel — an uploaded workbook (plan-gated)

Optional default sheet name can live on the datasource config; requests can still override with $sheet.

API

An API is the public façade over one datasource. It has:

• an API ID (UUID) used in /v1/:apiId
• permissions: read, create, update, delete, calculate (new APIs default to ["read"])
• authentication: none or api_key
• optional captcha, CORS, domain restrictions, and rate limits

API key

When authentication is api_key, create keys in the console. Secrets look like bs_<prefix>_<secret> and are shown once. Send them as X-API-Key or Authorization: Bearer.

Permissions

Each public operation requires a matching permission on the API. Missing permission → 403 FORBIDDEN.

Requests and plans

Every public call counts toward your account’s monthly API request limit. Creating APIs and connections is also capped by plan. See Limits.