Why integrate with Airtable?
Specter's Airtable Integration creates a dynamic two-way data flow. We pull every record from Airtable into Specter for real-time enrichment, giving you a unique, growth-ranked view of your Airtable workspace.
You can also push enriched data, whether it's a single company, a contact, or a bulk search, back into Airtable. You can automatically enrich Saved Searches and Lists so that any new results or updates are automatically pushed, keeping your data fresh and up to date in both systems.
Who can connect the integration?
Only Specter team admins can authorise the connection. If you're not an admin, ask your workspace owner to complete setup, or request admin rights via Settings → Team in Specter. Admins are marked with an "Admin" badge next to their name.
Step 1: Go to your Integrations Page
Navigate to Integrations in Specter and click Connect on the Airtable card.
In the pop-up, click Connect to proceed to Airtable's login.
Step 2: Authorize & Confirm
Log in to Airtable if prompted, select the correct workspace from the dropdown, review the permissions listed, and click Grant access to confirm.
What does Specter need access to? Specter uses Airtable's API to write records into your workspace. The permissions requested cover:
Reading your existing bases and tables (so Specter knows where to push records)
Creating and updating records in Airtable
Specter does not read or export data from Airtable for any purpose outside of enrichment.
Step 3: Record Mapping
Once connected, you'll land on the Push Setup wizard. Click Add Destination next to the entity you want to configure.
Select Your Airtable Base & Table
Once connected, you'll land on the Push Setup wizard. Click Add Destination next to the entity you want to configure.
Select the Airtable Base and Table you want to push records into. The base and table you choose should correspond to the type of data you're pushing, for example:
If you're pushing company data, select the base and table where your company records live.
If you're pushing people data, select the base and table set up for contacts.
If you're pushing investor data, select the relevant base and table.
Before you connect: Make sure the table you're pointing to already has the right columns set up in Airtable, for example a URL field for LinkedIn, a Text field for Domain, a Date field for Last Funding Date, and so on. Specter maps to existing columns; it won't create them for you.
From the second dropdown in screenshot, select the column in your table that contains the matching field Specter will use to identify existing records:
For companies and investors, select the column that holds the Domain.
For people, select the column that holds the LinkedIn URL.
Step 5: New Record Creation
Push mode controls what happens when Specter finds a record that doesn't already exist in your Airtable base.
Create + Update: Specter updates matched records and creates new Airtable records for any unmatched entries. Choose this if you want to capture every new prospect Specter finds.
Update Only: Specter updates matched records and skips unmatched entries. Choose this if you only want to enrich what's already in Airtable, keeping your base free of unvetted prospects.
Step 6: Field Mapping
Select which Specter data points you want to push to Airtable by mapping them to the appropriate fields.
❗ Check your data mapping ❗
Make sure each field is mapped to the correct data type to avoid errors. You can see what type Specter sends for each field displayed next to the field name in the mapping screen (e.g. Domain · Text, as shown above).
Examples:
A LinkedIn URL should be mapped to a URL field
A Last Funding Date should be mapped to a Date field
If the data types don't match (e.g. sending text into a date field), the push will fail.
Step 8: Save Your Mapping
Click Save Mapping to apply your settings for this entity.
Repeat Steps 3–8 for any additional entities (People, Investors) you want to push. Once all your destinations are configured, click Continue → on the Push Setup screen.
Step 9: Pull (Import) Airtable data into Specter
Pull Setup imports your Airtable records into Specter's My CRM for enrichment. You can pull from multiple Airtable tables at once, for example, your deal flow, portfolio, and watchlist running in parallel.
Click Pull Now.
Click Proceed with Pull to confirm.
The record count updates once the pull completes. Matched records appear in My CRM; unmatched ones are flagged for review.
3. Click Continue.
4.Click Complete Setup to finalise.
Step 10: Review Integration Activity
The Integration Activity screen shows a log of your recent syncs. Click Continue when you're ready to proceed.
Click More Info next to any sync entry to open the detailed breakdown. You'll see a step-by-step view of each sync (matching, creating, updating) along with record-level details.
This helps you quickly spot where a sync failed, identify issues, and understand exactly how your data was processed.
Step 11: You're Live!
Airtable and Specter now exchange data on the schedule you set. Monitor activity anytime from the Integrations hub.
Need a hand?
Open the Intercom chat in your Specter dashboard or email team@tryspecter.com, we're quick to respond and always happy to hear your feedback.