Google Sheet API

Overview

API Plugin’s Google Sheets API transforms your spreadsheets into dynamic JSON endpoints. Get instant API access to your Google Sheets data without any coding or complex setup.

Key benefits include:

• Instant JSON API from any Google Sheet
• Real-time data synchronization
• Secure access control
• Simple query parameters
• Multiple response formats
• Automatic caching
• No coding required

How to Setup

We assume you have signed up on API Plugin and are logged into the dashboard.

To set up the Google Sheets API:

1. Go to the marketplace
2. Select Google Sheets from the list
3. Click “Connect with Google”
4. Select the sheets you want to expose as API

After authorizing access, you can start using your sheets as APIs immediately.

Available Endpoints

1. Get Rows

GET /v1/{appId}/{token}

Query Parameters:

• tabId (required): Your Sheet Tab name (e.g., Sheet1)
• row_id: Get a specific row by ID
• perPage: Number of records per request
• page: Page number for pagination
• filterBy: Column key to filter results
• filterValue: Value to filter by
• filterType: Filter method (equal, contain, greater, less)
• valueRenderOption: How values should be rendered (FORMATTED_VALUE, UNFORMATTED_VALUE, FORMULA)

2. Add New Rows

POST /v1/{appId}/{token}

Parameters:

• tabId (required): Your Sheet Tab name
• Request Body: Array of objects representing rows

Example Request Body:

[
    {
        "Name": "John Doe",
        "Age": "30",
        "Email": "john@example.com"
    },
    {
        "Name": "Jane Smith",
        "Age": "25",
        "Email": "jane@example.com"
    }
]

3. Update Row

PUT /v1/{appId}/{token}

Parameters:

• tabId (required): Your Sheet Tab name
• Request Body: Object containing row_id and updated values

Example Request Body:

{
    "row_id": 3,
    "name": "API Plugin v2",
    "email": "hello@apiplugin.io"
}

4. Delete Row

DELETE /v1/{appId}/{token}

Query Parameters:

• tabId (required): Your Sheet Tab name
• row_id (required): Row ID to delete

5. Search Rows

GET /v1/{appId}/{token}/search

Query Parameters:

• tabId (required): Your Sheet Tab name
• searchKey (required): Column to search in
• searchValue (required): Value to search for
• searchType: Search method (equal, contain, greater, less)
• valueRenderOption: Value rendering option (FORMATTED_VALUE, UNFORMATTED_VALUE, FORMULA)

We have web based playground to test all these API endpoints. Get started by login and connect with yout Google Sheet API without any code.