Overview
Airtable Forms are lightweight form views built directly into Airtable bases. Submissions populate Airtable table rows instantly, making them popular for internal tools and simple data collection. However, when embedded on a marketing website, Airtable Forms lack UTM tracking, referrer capture, and the cross-team accessibility that Google Sheets provides. LeadToSheet works between the two by writing a parallel copy of each submission to Google Sheets with full attribution metadata, while Airtable continues to serve as the primary database.
Implementation checklist
- 1
Add the LeadToSheet SDK to your Airtable form embed page
Place the script tag on the web page where your Airtable form is embedded via iframe or share link. The SDK captures page-level attribution data from the host page.
LeadToSheet snippet
<script src="https://cdn.leadtosheet.com/sdk.min.js" data-client="YOUR_CLIENT_KEY"></script> - 2
Configure an Airtable Automation to relay submissions
Airtable Forms embed in a cross-origin iframe. Create an Airtable Automation that triggers when a new record is created in the form's target table, then use a 'Send webhook' action to POST the record data to your LeadToSheet webhook URL.
Tip: In Airtable Automations, the 'When record is created' trigger fires for every new form submission. Map the fields you want in the webhook payload.
- 3
Test with UTM parameters and verify the merged row
Visit your embed page with UTM parameters appended, submit the Airtable form, and confirm that both the form fields (via Airtable Automation webhook) and the attribution data (via SDK) appear in your Google Sheet.
Customization ideas
Maintain Airtable as primary database with Sheets as analytics layer
Keep Airtable as your operational database for linked records, views, and automations, while using the Google Sheet from LeadToSheet as a read-only analytics layer with attribution data for marketing analysis.
Track form submissions across multiple Airtable bases
If you use separate Airtable bases for different projects, LeadToSheet consolidates form submissions from all bases into a single Google Sheet with a base identifier column, providing a unified view.
Build Sheets dashboards unavailable in Airtable
Google Sheets offers charting, pivot tables, and Apps Script automations that Airtable's interface views do not. Use the LeadToSheet-powered sheet as your reporting layer for executive dashboards and ad-hoc analysis.
Troubleshooting
Airtable form iframe blocks direct capture
Airtable form embeds use a cross-origin iframe on airtable.com. LeadToSheet cannot access form fields from the browser. The Airtable Automation webhook is the required method for delivering field data to your Google Sheet.
Automation webhook not firing for prefilled forms
Airtable form prefill parameters work via URL, but the Automation still triggers on record creation. If prefilled values are not appearing, verify that the prefilled fields are included in the Automation's webhook payload configuration.
Limited conditional logic in Airtable Forms
Airtable Forms have minimal conditional logic compared to dedicated form builders. All fields configured in the form view will appear in the webhook payload. Empty fields from unanswered optional questions will appear as blank cells in your Google Sheet.
Resources
Frequently asked questions
- Why mirror Airtable data in Google Sheets?
- Airtable is excellent for structured data and linked records, but Google Sheets offers broader team access, richer charting, Apps Script automation, and integration with tools that do not connect to Airtable natively. LeadToSheet also adds attribution data that Airtable Forms cannot capture.
- Will this create duplicate records in Airtable?
- No. Airtable receives the form submission natively as always. LeadToSheet writes a separate copy to Google Sheets via the webhook relay. There is no feedback loop that creates Airtable duplicates.
- Can I use Airtable's share link instead of an iframe embed?
- The share link opens the form in a new tab on airtable.com, where the LeadToSheet SDK is not present. For attribution capture, embed the form via iframe on a page that includes the LeadToSheet SDK, and use the Automation webhook for field data.