Sheetfront Docs

Use this page when setting up Sheetfront for the first time.

Choose an Environment

Set an API base URL before copying examples.

export API_BASE_URL="https://api.sheetfront.com"

For staging, use https://api-staging.sheetfront.com. For local development, use http://localhost:8000.

1. Connect a Sheet

Sign in to the dashboard.
Click Connect Sheet.
Authorize Google access.
Select the spreadsheet and tab.

Sheetfront reads row 1 as column headers.

2. Choose an Output

From the connected sheet you can:

Open Pages and create a searchable mini page at https://p.sheetfront.com/your-slug or https://pages.sheetfront.com/your-slug.
Open Forms and publish a hosted form at /f/your-slug.
Open API Keys and create a key for server-side API access.

3. Create a Key

Open the connected sheet.
Go to API Keys.
Click Create API Key.
Save the full key immediately.

4. Read Rows

curl -H "Authorization: Bearer your_key_here" \
  "$API_BASE_URL/api/v1/sheets/{connection_id}/data"

Use the interactive API reference to inspect query parameters, response fields, and error shapes.

5. Append a Row

Appending rows requires a Starter plan or higher and an API key with create permission.

curl -X POST \
  -H "Authorization: Bearer your_key_here" \
  -H "Content-Type: application/json" \
  -d '{"data": {"name": "Widget A", "price": 29.99}}' \
  "$API_BASE_URL/api/v1/sheets/{connection_id}/data"

Store API keys server-side. Full keys are shown only once.

Getting Started