Skip to content
Sima.Journal
← Back to the journal

Integrate Airtable & Google Sheets for Real-Time Data Sync (2025 No-Code Guide)

By Sima Team | June 8, 2025

 Airtable and Google Sheets real-time sync cover image

TL;DR – With Airtable Automations 2.0 and Make.com's new "Instant Routers", you can push new or updated Airtable records into Google Sheets (and vice-versa) every 5 seconds—without hitting API rate limits or writing a line of Apps Script. Perfect for digital agencies that juggle client campaign data in Sheets while ops teams live in Airtable.

Why Sync These Two?

  • One source for ops, another for reporting. Ops teams love Airtable views; stakeholders still demand Sheets. Sync = happy marriage.
  • Eliminate CSV hell. No more weekly exports/imports that mis-align IDs.
  • Live dashboards. Google Connected Sheets can now query up to 500 k rows—ideal for Looker Studio blends.

2025 Feature Highlights

New FeatureReleaseWhy It Matters
Airtable Automations 2.0Jan 2025Adds "Call Webhook" and batch triggers—10× cheaper API quota
Google Connected Sheets v3Mar 2025Lets Sheets act as a BI layer on external data sources with auto-refresh every 5 min
Make.com Instant RoutersApr 2025Listen to Airtable webhooks in under 2 s and route to multiple branches without extra ops
Airtable 100 K Record LimitsFeb 2025Bases now support 100 k+ rows—no more splitting into sub-bases

Architecture Overview

flowchart LR
  AT[Airtable Base] --Webhook--> MK[Make.com Scenario] --Sheets API--> GS[Google Sheet]
  GS --Connected Sheets--> DS[Looker Studio Dashboard]
  MK -->|Bidirectional (optional)| AT
  • Trigger: Airtable's When record created or updated → Webhook.
  • Router: Make.com checks which fields changed and decides direction.
  • Action: Sheets API Update Row or Append Row.
  • Refresh: Connected Sheets polls every 5 min.

Prerequisites

ToolFree Plan OK?What You Need
Airtable✅Workspace with Automations enabled (any plan)
Google Sheets✅Sheet with header row + Service Account or personal OAuth
Make.comFree tier1,000 ops/mo good for ~5,000 record syncs
Looker Studio (optional)✅For dashboards

Step-by-Step Setup

Step 1 – Create Airtable Webhook Automation (3 min)

  1. Automations → Create → When record matches conditions. Table: Campaigns View: All
  2. Condition: Last modified time is not empty (fires on updates too).
  3. Action: Run script → Call outgoing webhook Paste Make.com instant trigger URL.
  4. Test & Enable.

Step 2 – Build Make.com Scenario (7 min)

  1. Trigger – Webhook (Custom hook).
  2. Router – "Instant Router" Branch A (Create): If airtable_id does not exist in Sheets → Append Row Branch B (Update): If exists → Update Row

Wrap-Up & Next Steps

With this setup, your Airtable and Google Sheets stay in real-time sync—no more manual exports, no more stale dashboards.

  • Zero manual copy-paste between ops and reporting.
  • Instant updates for dashboards and stakeholders.
  • Scalable: Handles 100k+ records and bi-directional sync.

Happy automating!