Connect Google Sheets and Make

In short

Connecting Google Sheets to Make lets rows trigger actions in other tools. The main risk is cost, because scenarios that loop over rows use up operations quickly. On a five-person studio build, SBD moved heavier processing to Apps Script and Cloudflare Workers to keep Make costs down, and admin time fell by 60%.

The workflows

What runs between Google Sheets and Make.

Each line is one automated workflow. It shows the event in one tool, the checks and mapping in between, the action in the other tool and who is notified.

1. Low-cost team automation

   When

   A new row reaches the status Ready

   Automation

   • Verify and validate
   • Map and normalise
   • Upsert by key

   Then

   Make picks it up and sets it to Processing

   And

   • Audit log entry
   • Alert if it fails or goes quiet
   • Review queue if unsure

2. Reducing Make operations

   When

   The job involves many rows

   Automation

   • Verify and validate
   • Map and normalise
   • Upsert by key

   Then

   Pass it to Apps Script or a Worker and collect the result

   And

   • Audit log entry
   • Alert if it fails or goes quiet
   • Review queue if unsure

3. Status columns as a queue

   When

   The work finishes

   Automation

   • Verify and validate
   • Map and normalise
   • Upsert by key

   Then

   Update the status and tell the next person

   And

   • Audit log entry
   • Alert if it fails or goes quiet
   • Review queue if unsure

4. Apps Script for heavy work

   When

   A step fails

   Automation

   • Verify and validate
   • Map and normalise
   • Upsert by key

   Then

   Mark the row, keep the error and alert a named person

   And

   • Audit log entry
   • Alert if it fails or goes quiet
   • Review queue if unsure

Every record passes through the same stages

1. 1Receive

   Webhook or polling from the source tool, with a signed payload and a replay log.

2. 2Validate

   We check required fields, types and the record key. Anything that fails goes to the review queue.

3. 3Map

   Fields are mapped to the destination schema, with dropdown values, currencies and dates normalised.

4. 4Upsert

   Each write is matched on the record key, so a retry updates the existing record.

5. 5Confirm

   The outcome is logged, an alert fires if the count stops moving, and a reconciliation runs each night.

Read this first

Where the simple setup breaks down.

A one-step Zap connects Google Sheets and Make in an afternoon. This is what tends to go wrong once volume grows and edge cases appear.

• Looping over rows burns operations

  A scenario that touches every row on each run can use many operations for little work. Heavy processing is often cheaper in Apps Script or a small Worker, with Make coordinating the steps.

• Watching a sheet can miss or repeat changes

  Trigger settings depend on which rows Make has already seen, and sorting or inserting rows can confuse them. A status column makes it clear what has been processed.

• Scenarios can stop quietly

  After repeated errors a scenario can be switched off, and the sheet looks normal while nothing happens. An alert has to reach a named person.

• Formulas are not stable data

  A column full of formulas can change after a read, and a value can look different from what is stored. Automation should read from settled values.

What we wire up

The data flows.

1. 01
   When

   A new row reaches the status Ready

   Then

   Make picks it up and sets it to Processing

2. 02
   When

   The job involves many rows

   Then

   Pass it to Apps Script or a Worker and collect the result

3. 03
   When

   The work finishes

   Then

   Update the status and tell the next person

4. 04
   When

   A step fails

   Then

   Mark the row, keep the error and alert a named person

In every build

What every integration build includes.

Security and your data

Where the data goes, and who holds the keys.

Accounts

Every platform account is created in your name. We work through managed access you can revoke.

Credentials

Stored encrypted in the orchestration layer, scoped per connection and rotated at handover.

Data in transit

All traffic uses TLS, and webhooks are checked by signature before anything is processed.

Data at rest

We store only what the sync needs and keep no copies of your customer data on our machines.

AI steps

Where an integration uses a model, it is through a business API that does not train on your data.

Retention

Run logs are kept 90 days by default, which you can change. Card and ID numbers are redacted from payloads.

Agreements

DPA and NDA on request. Regional rules covered in our privacy policy.

Keys and sensitive data

How API keys, tokens and personal data are handled.

• Keys are kept in a vault

  API keys and tokens are stored in the orchestration layer's encrypted credential store or the platform's secret manager. None are written into workflows, repos, spreadsheets or chat.

• One credential per connection

  Each integration gets its own key, scoped to the objects and actions it needs. A lead sync cannot read invoices. Revoking one key stops one thing.

• Service accounts for connections

  Connections use a dedicated service user in your account, so nothing breaks when a person leaves and nothing runs under someone's name.

• Two-factor on every account

  Each platform account we set up has two-factor authentication on, and the recovery codes are handed to you.

• Rotation on handover and on request

  Keys are rotated when the build is handed over, when anyone with access leaves, and at any time you ask.

• Secrets are redacted from logs

  Audit logs redact tokens, card numbers, government IDs and anything you flag as sensitive before a line is written.

• Webhooks verified before processing

  Inbound calls are checked against the sending tool's signature. Unsigned or stale payloads are dropped and counted.

• Access you can see and revoke

  Our access is through managed roles in your accounts. You can see it, limit it or remove it without touching the build.

Engineering decisions

Decisions we make before writing the first workflow.

• Rate limits and backoff

  Each API has a ceiling, so calls are batched, queued and retried with increasing delays during busy periods.

• Backfill and pagination

  The first run loads history as well as new events. Backfills page through the source in order and resume after an interruption without writing a record twice.

• Out-of-order and duplicate events

  Webhooks can arrive twice or out of sequence. Each event carries a version or timestamp, so an older version cannot overwrite a newer one.

• Schema changes

  A renamed field or a new dropdown value is a common cause of silent failure. Payloads are checked against a contract, and a mismatch stops the run and raises a flag.

• Time zones, currencies, units

  Dates are stored in UTC and shown in local time. Amounts carry their currency and quantities their unit, and conversions happen once, in the map step.

• Sandbox first

  Builds run against sandbox or test accounts with seeded data first. Going live means switching credentials.

• Versioned and reversible

  Workflows and code are version-controlled. A release can be rolled back in minutes without losing the records processed since.

• API deprecations watched

  Tools retire API versions on a schedule. We track the dates for every connection in the runbook and upgrade before the cut-off.

• Cost per run known

  Each run logs its cost, including any model calls, so you can see spend as it builds up.

• Run metrics

  We chart runs per hour, records in and out, exception rate and latency, which often shows a problem before an alert fires.

Proof

Where we have done this.

• Customer story

  Lightweight project management system

  A five-person studio where Apps Script and Cloudflare Workers take the heavier processing to keep Make costs down.

  Read the story →
• Customer story

  Automated cashback and loyalty system

  A QR cashback system on Make, Cloudflare Workers, Razorpay X and Google Sheets.

  Read the story →

Questions

What people ask about this pair.

Related

• +

  SmartSuite and Make

  SmartSuite holds the record, and Make sends changes to the other systems within the API quota.

• +

  Airtable and Retool

  Airtable is a good database with a limited interface. Retool adds the screens and permissions it lacks.

• +

  Tally and Airtable

  Tally stays the book of record, and your team can see what is in it without asking accounts.

• Solution

  Operations

  The workflows we automate for this kind of team.