BlazeSheets

Quick Start

Turn a spreadsheet into a JSON API with BlazeSheets in a few minutes.

Welcome to BlazeSheets — turn Google Sheets and Excel workbooks into configurable, formula-aware JSON APIs.

Getting started

  1. Sign up and open the console.
  2. Connect a Google account (or upload an Excel file on a plan that includes Excel).
  3. Create an API from a spreadsheet. Put column names in the first row.
  4. Copy your API ID from the console. Public requests use that ID in the path.

BlazeSheets treats the first row as the schema for every data row beneath it.

What is a request

Each call to a public data endpoint counts as one API request against your monthly plan quota. That includes reads, creates, updates, deletes, and calculate calls.

Making your first request

Once you have an API ID, send a GET request:

curl -X GET 'https://api.blazesheets.com/v1/<api-id>'

If the API requires a key, include it:

curl -X GET 'https://api.blazesheets.com/v1/<api-id>' \
  -H 'X-API-Key: bs_...'

A successful response looks like:

{
  "data": [
    { "name": "Ada", "email": "ada@example.com", "active": "true" }
  ],
  "meta": {
    "limit": 100,
    "offset": 0,
    "format": "rows"
  }
}

Next: prepare your sheet, learn product concepts, or jump to the API reference.

On this page