Zapier & Make Integration

SheetsAPI exposes your Google Sheet as a standard REST API, which means it works seamlessly with any automation platform that supports HTTP requests - including Zapier, Make (formerly Integromat), n8n, Pipedream, and others.

Zapier - HTTP action

Zapier's Webhooks by Zapier action (or any app's built-in HTTP step) can call SheetsAPI endpoints.

Fetch rows from your sheet

1. In your Zap, add an action step.
2. Choose Webhooks by Zapier → GET.
3. Set the URL to:

   https://sheetsapi.gkit.mreshank.com/api/spreadsheets/YOUR_USER_KEY/Products?limit=20&sort=name
   

4. Under Headers, add:
   • Key: Authorization
   • Value: Bearer sk_your_api_key_here
5. Click Test step - the response body is parsed as JSON and each key in data[0] becomes a mappable field in later Zap steps.

For public sheets, skip the Authorization header.

Add a row when a Zap fires

To POST a new row - for example, when a Typeform response arrives:

1. Add an action step: Webhooks by Zapier → POST.
2. URL: https://sheetsapi.gkit.mreshank.com/api/spreadsheets/YOUR_USER_KEY/Submissions
3. Payload type: JSON.
4. Data: map Typeform fields to your sheet column names:

   name    → {{Name from Typeform}}
   email   → {{Email from Typeform}}
   message → {{Message from Typeform}}
   

5. Headers: Authorization: Bearer sk_your_api_key_here.

Zap example: new Stripe payment → row in Google Sheet

Fields to map: amount, currency, customer_email, payment_id.

Make (formerly Integromat) - HTTP module

Make's HTTP → Make a request module supports full REST calls.

Fetch and iterate rows

1. Add a HTTP → Make a request module.
2. URL: https://sheetsapi.gkit.mreshank.com/api/spreadsheets/YOUR_USER_KEY/Products
3. Method: GET.
4. Headers:

   Authorization: Bearer sk_your_api_key_here
   

5. Enable Parse response → the data array becomes an iterable in the next module.
6. Add an Iterator module connected to data to process each row individually.

Pagination in Make

Use Make's loop constructs to paginate through all rows:

1. Add a HTTP → Make a request module with URL params limit=100&offset={{offset}}.
2. Set offset as a variable starting at 0.
3. After the module, add a Router:
   • Route A (more pages): if response.meta.total > offset + 100, increment offset and loop back.
   • Route B (done): continue to the next stage of your scenario.

Add a row from a Google Form

n8n - HTTP Request node

n8n is open-source and self-hostable. The HTTP Request node handles SheetsAPI calls natively.

1. Add an HTTP Request node.
2. Method: GET (or POST).
3. URL: https://sheetsapi.gkit.mreshank.com/api/spreadsheets/YOUR_USER_KEY/Products.
4. Authentication: Header Auth → add Authorization: Bearer sk_your_api_key_here.
5. Response format: JSON.
6. Connect to a Split In Batches node to iterate over data.

Pipedream - Node.js step

Pipedream workflows support any npm package and run in a Node.js context:

// Pipedream step: fetch from SheetsAPI
import { axios } from "@pipedream/platform";
 
export default defineComponent({
  async run({ steps, $ }) {
    const response = await axios($, {
      url: `https://sheetsapi.gkit.mreshank.com/api/spreadsheets/${process.env.SHEETS_USER_KEY}/Orders`,
      headers: { Authorization: `Bearer ${process.env.SHEETS_API_KEY}` },
      params: { limit: 50, sort: "-created_at" },
    });
    return response; // { data: [...], meta: { total, limit, offset } }
  },
});

Store SHEETS_USER_KEY and SHEETS_API_KEY as Pipedream environment variables.

Security: keep your API key safe

All automation platforms provide a secrets or environment variables store:

Never put your API key directly in a URL query string - use the Authorization: Bearer header instead.

Summary

Any platform that can make HTTP requests can call SheetsAPI - no custom connector or OAuth flow required.