Quick Start

Get your Google Sheet API up and running in under 5 minutes.

Prerequisites

• A Google account
• A Google Sheet (we'll help you create one if needed)

Step 1: Create Your Account

Go to app.sheetstojson.com/register and sign up for a free account.

You'll get a 3-day free trial with no credit card required.

Step 2: Prepare Your Google Sheet

Option A: Use an Existing Sheet

If you already have a Google Sheet:

1. Open your sheet
2. Copy the URL from your browser
3. Make sure the first row contains column headers

Option B: Create a Sample Sheet

Create a new Google Sheet with this structure:

id	name	email	status
1	Alice	[email protected]	active
2	Bob	[email protected]	inactive
3	Charlie	[email protected]	active

Make Your Sheet Public (for testing)

For quick testing, make your sheet publicly viewable:

1. Click Share in the top right
2. Change "Restricted" to "Anyone with the link"
3. Set permission to "Viewer"

TIP

For private sheets, you'll need to complete the OAuth flow. See Authentication for details.

Step 3: Register Your Sheet

1. Go to your Dashboard
2. Click "Register New Sheet"
3. Paste your Google Sheets URL
4. Give it a descriptive name (optional)
5. Click "Register"

You'll immediately receive:

• Your Sheet ID
• Your API Key
• Links to your API endpoints
• Link to your API documentation

Step 4: Make Your First Request

Using cURL

curl -H "X-API-Key: YOUR_API_KEY" \
  https://api.sheetstojson.com/api/v1/{SHEET_ID}/Sheet1

Using JavaScript

const response = await fetch(
  'https://api.sheetstojson.com/api/v1/{SHEET_ID}/Sheet1',
  {
    headers: {
      'X-API-Key': 'YOUR_API_KEY'
    }
  }
);

const data = await response.json();
console.log(data);

Using Python

import requests

response = requests.get(
    'https://api.sheetstojson.com/api/v1/{SHEET_ID}/Sheet1',
    headers={'X-API-Key': 'YOUR_API_KEY'}
)

data = response.json()
print(data)

Step 5: Explore Your API

Visit your auto-generated documentation:

https://api.sheetstojson.com/docs/{SHEET_ID}

Here you can:

• See all available endpoints
• Try requests directly in the browser
• View response schemas
• Copy code examples

Next Steps

Create New Rows

curl -X POST \
  -H "X-API-Key: YOUR_API_KEY" \
  -H "Content-Type: application/json" \
  -d '{"name": "Diana", "email": "[email protected]", "status": "active"}' \
  https://api.sheetstojson.com/api/v1/{SHEET_ID}/Sheet1

Update a Row

curl -X PUT \
  -H "X-API-Key: YOUR_API_KEY" \
  -H "Content-Type: application/json" \
  -d '{"status": "inactive"}' \
  https://api.sheetstojson.com/api/v1/{SHEET_ID}/Sheet1/1

Delete a Row

curl -X DELETE \
  -H "X-API-Key: YOUR_API_KEY" \
  https://api.sheetstojson.com/api/v1/{SHEET_ID}/Sheet1/1

Common Issues

"Invalid API Key" Error

Make sure you're including the API key in your request headers:

• Header name: X-API-Key or Authorization: Bearer YOUR_KEY
• Value: The full API key from your dashboard

"Sheet not found" Error

Double-check:

• Sheet ID is correct
• Tab name matches exactly (case-sensitive)
• Sheet hasn't been deleted or permissions changed

Rate Limit Errors

Free tier has 100 requests/day. Upgrade your plan for higher limits.

Getting Help

• Read the full API reference
• Check authentication docs
• Email [email protected]

Next: Learn about Authentication

Check out our Authentication Guide to secure your APIs and use private sheets.