What this connection does
Deliberately not the Google Sheets page: Airtable people chose Airtable because they want views, filters, and linked records. Once the source lands as structured data, you can group leads by channel, build a view per client, or link a lead to a campaigns table, none of which a plain sheet does well.
Field mapping
Source and Medium as Single select, everything else as text or date.
| Lead Recorder field | Airtable field | Notes |
|---|---|---|
| submittedAt | Date | Date field |
| nameField | Name | One combined name, not split first/last |
| emailField | Blank for phone-click leads | |
| phoneNumber | Phone | |
| utmSource | Source | Single select, not free text |
| utmMedium | Medium | Single select, not free text |
| utmCampaign | Campaign | |
| formPage | Page |
Setting it up
Pre-create your Source options
Before touching Zapier, add the Source field as Single select and create the options you expect: Google Ads, Organic Search, Direct, Referral, Facebook/Instagram Ads, Other.
Open the Zap template and connect both accounts
Use the embed below, or open the template directly on Zapier. Connect Lead Recorder as the trigger and your Airtable base as the action.
Map each field
Match each Lead Recorder field to its column using the table above.
Send a test lead
Submit a form or click-to-call on your own site and confirm the record lands with the right Source option selected, not a Zap error.
What catches people out
What catches people out
Single-select fields reject values that don't already exist as options.If Source is a Single select and Zapier tries to write “Google Ads” before that option exists, the Zap errors instead of creating it. Pre-create the categories you expect before the first real lead arrives. This is the real difference from the Sheets page, and the reason these two pages aren't duplicates of each other.
What it looks like when it's working
Stop re-typing leads.
Start recording.
Your next lead is about to hit your website. Know exactly where it came from, structured the way your base already works.
No credit card required · Included on every plan
Found you via Google Ads · "best plumber near me"
Found you via Organic Search · "emergency electrician"
Found you via Facebook Ads