Quick Start Guide

Get your first API up and running in under 5 minutes.

Prerequisites

Before you begin, make sure you have:

• A Google account
• A Google Sheet with some data

Step 1: Sign Up

Create your free SheetsJSON account by signing in with Google. We’ll use your Google credentials to securely access your spreadsheets.

Step 2: Create Your First Sheet

Once logged in, navigate to the Sheets section in your dashboard. Click Connect Sheet to link your Google Sheet.

Preparing Your Sheet

For best results, structure your sheet like a database table:

Tip: The first row should contain column headers. These become the keys in your JSON response.

Step 3: Generate an API Key

Navigate to API Keys and create a new key. Give it a descriptive name like “Production” or “Development”.

API Key: sk_live_xxxxxxxxxxxxxxxxxxxxxxxx

Important: Keep your API key secure. Never commit it to version control or expose it in client-side code.

Step 4: Make Your First Request

Use your favorite HTTP client to fetch data:

curl -X GET "https://api.sheetsjson.com/v1/sheets/YOUR_SHEET_ID" \
  -H "Authorization: Bearer YOUR_API_KEY"

Response

{
  "data": [
    {
      "id": "1",
      "name": "Widget A",
      "price": "29.99",
      "category": "Electronics"
    },
    {
      "id": "2",
      "name": "Widget B",
      "price": "49.99",
      "category": "Electronics"
    }
  ],
  "meta": {
    "total": 2,
    "sheet_name": "Products"
  }
}

What’s Next?

• Learn about Authentication to secure your APIs
• Explore Query Parameters for filtering and pagination
• Check out the API Reference for all available endpoints