Getting Started

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

1. Create an Account

Head to the Sheet Gurus dashboard and sign in with your Google account. We use Google OAuth so you can authorize access to your spreadsheets securely.

2. Connect a Google Sheet

Once signed in, click New Sheet and paste your Google Sheets URL. Sheet Gurus will automatically detect the columns and data types in your spreadsheet.

Make sure your spreadsheet has a header row — the first row will be used as field names for your API responses.

3. Get Your API Key

Navigate to the API Keys section in your dashboard and create a new key. You can create multiple keys with different permissions for different use cases.

4. Make Your First API Call

Use your API key to fetch data from your sheet. Here's an example using curl:

curl -H "X-API-Key: YOUR_API_KEY" \
  https://api.sheetgurus.com/v1/data/YOUR_SHEET_ID

You should receive a JSON response containing the rows from your spreadsheet:

{
  "data": [
    {
      "id": "1",
      "name": "Widget Pro",
      "price": "29.99",
      "in_stock": "true"
    }
  ],
  "meta": {
    "total": 1,
    "limit": 50,
    "offset": 0,
    "headers": ["id", "name", "price", "in_stock"]
  }
}

Next Steps