Make.com Airtable Integration

Why Airtable + Make.com

Airtable is more structured than a spreadsheet (data types, linked records, views) but easier to manage than a traditional database. Combined with Make.com:

• Airtable as a source: Make.com reads records from Airtable to trigger downstream automations (send emails, create CRM records, call APIs)
• Airtable as a destination: Make.com writes data from other services into Airtable (collect all lead enrichment data, log automation runs, build operational dashboards)
• Airtable as a trigger: Make.com watches Airtable for new or updated records and responds immediately

This creates systems where non-technical users can interact with data (add records in Airtable), and Make.com handles all the downstream logic.

Setting Up the Airtable Connection

1. In Make.com, open a scenario and add an Airtable module
2. Click "Add connection" and follow the OAuth flow — log into Airtable and authorize Make.com
3. Select your Airtable base and table
4. Make.com will fetch the table schema so all fields are available for mapping

You can also use Airtable's Personal Access Token instead of OAuth for non-interactive setups.

Reading Records (Input Scenarios)

Common patterns for reading Airtable:

Process new records (polling): Use "Watch New Records" trigger. Make.com checks the table at your scheduled interval and returns records created since the last run. Best for: nightly batch processing of records added during the day.

Process all records matching criteria: Use "Search Records" with a filter formula. Fetch only records where {Status} = "To Process". Best for: batch job scenarios.

Fetch a specific record: Use "Get a Record" with a record ID. Best for: when another service returns an Airtable record ID and you need the full record data.

React to new records instantly: Use the Airtable "Watch Records" trigger with a short interval, or use Airtable Automations to trigger a Make.com webhook on new record creation. Best for: real-time processing.

Writing to Airtable (Output Scenarios)

Create Record: Add a new row. Map fields from previous modules. All field types are supported (text, number, date, select, linked record).

Update Record: Modify an existing record. Requires the record ID (Airtable's internal ID, returned when you created the record or found it via search).

Upsert pattern: Search for a record by unique identifier (email, external ID) → if found, update; if not found, create. This is the most common write pattern — it's idempotent and prevents duplicate records.

Practical Airtable Scenarios

Lead management base:

• Form submission → Create Airtable record in "Leads" table
• Airtable as source → HubSpot contact creation
• Enrichment results → Update Airtable record with company data

Content publishing workflow:

• Content writer adds article record in Airtable with status "Draft"
• Make.com watches for status "Ready to Publish"
• Trigger: publish to WordPress, tweet announcement, log in analytics

Client onboarding tracker:

• New HubSpot deal "Closed Won" → Create Airtable record in "Onboarding" base
• Each onboarding step completion → Update Airtable record status
• Airtable becomes the dashboard of all active client onboardings

Operations log:

• Every Make.com scenario logs its execution to Airtable (scenario name, status, records processed, timestamp)
• Airtable provides a searchable, filterable audit trail

Linked Records and Relational Data

Airtable supports linked records — relationships between tables. Make.com can create and read these links:

Creating a linked record: Set the linked record field value to an array of record IDs: ["recXXXXX", "recYYYYY"]. Make.com needs the record ID of the linked record — fetch it first with "Search Records."

Reading linked records: When Make.com fetches a record with linked fields, it returns the linked record IDs (not the linked record data). Use "Get a Record" with the linked record IDs to fetch the full linked data.

For complex relational queries, consider using Airtable's built-in formulas or views to pre-compute the relationships and expose them as simple fields for Make.com to read.

Recommended Tools

• Airtable — Flexible database and operational source of truth
• Make.com — Automation that reads, writes, and reacts to Airtable
• HubSpot — CRM that Make.com syncs bidirectionally with Airtable
• Claude API — AI enrichment with results stored in Airtable
• Typeform — Form submissions written to Airtable via Make.com

“Airtable + Make.com is a non-technical team's database with automation. It doesn't require SQL or engineers — just careful table design and well-built Make.com scenarios.”