Airtable Destination
Overview
The Airtable destination writes evaluation results to your Airtable Contacts and Companies tables. TrailSpark maps scores, reasoning, and evaluation dates to fields you specify in your Airtable base, and optionally pushes buying-group coverage data when you enable that section.
Prerequisites
- Airtable integration connected with table mapping configured
- Fields created in your Airtable Contacts table for TrailSpark data
- Admin or Owner role in TrailSpark
Fields in Airtable
Create these fields on your Contacts table:
| Field Name (suggested) | Field Type | Purpose |
|---|---|---|
| TrailSpark Score | Single line text (or Single select with hot/warm/cold options) | Evaluation score |
| TrailSpark Evaluation Date | Date | When the evaluation occurred |
| TrailSpark Reasoning | Long text | AI-generated evaluation reasoning |
For company propensity, create on your Companies table:
| Field Name (suggested) | Field Type | Purpose |
|---|---|---|
| TrailSpark Propensity | Single line text (or Single select with high/medium/low options) | Account-level propensity rating |
Buying-group fields are documented below — add them only if you plan to use that feature.
You can use any field names you like -- you'll select them from a dropdown during configuration. The names above are suggestions for clarity.
Configuration
Go to Settings > CRM Integration > Destinations tab.
Destination Settings
- Send Evaluations to Airtable -- Toggle to enable/disable the destination
- Airtable Integration -- Select which connected Airtable instance to use (auto-selected if only one exists)
- Create Records if Not Found -- When enabled, creates new Contact records if no match exists. Filter by score level (Hot, Warm, Cold)
Contact Field Mapping
Map three required fields to your Airtable Contacts table:
| UI Label | Description |
|---|---|
| Score Field | Where the evaluation score is stored (hot, warm, or cold) |
| Evaluation Date Field | Where the evaluation timestamp is stored |
| Reasoning Field | Where the AI reasoning is stored |
TrailSpark loads your Airtable field metadata automatically. Select fields from the dropdown. If a previously mapped field no longer exists in Airtable (e.g., it was renamed or deleted), the mapping resets to blank.
Company Propensity Score
The propensity score card configures where account-level propensity (high/medium/low) is written:
- Company Propensity Field (primary) -- Written to the Companies table when a linked company exists
- Contact Propensity Field (fallback) -- Written to the Contacts table when no company is linked
Both fields are optional.
Buying Group Fields
Enable the Push buying-group fields toggle to push coverage data alongside evaluation scores. All fields in this section are optional — they write only when you map them.
Account properties
| UI Label | Written to | What it contains |
|---|---|---|
| Buying-group stage | Companies | Dormant, Forming, or Complete |
| Engagement completeness (%) | Companies | Share of required roles with an actively engaged person |
| Known completeness (%) | Companies | Share of required roles with any person assigned |
| People still needed | Companies | Count of additional people needed to complete the group |
| Missing roles | Companies | Role names not yet filled (semicolon-separated) |
| Engaged roles | Companies | Role names currently active (semicolon-separated) |
| Propensity as-of date | Companies | Date the propensity score was last evaluated |
| At-risk status | Companies | "At Risk" when high propensity meets stalled engagement; otherwise "Current" |
| Renewal health | Companies | Health signal for renewal-ICP accounts: Healthy, Cooling, Fading, Cold, or Pending |
For what these values mean, see Account coverage.
Airtable does not currently support a contact-level buying-group roles field. Use Salesforce or HubSpot if you need per-contact role data in your destination.
How Record Matching Works
TrailSpark matches records by email address:
- Looks up the contact's email in your Airtable Contacts table
- If found, updates the existing record with evaluation results
- If not found and Create Records is enabled, creates a new Contact record
- For propensity and buying-group fields, follows the Contact → Company linked record to find the associated company
The Contact → Company link field must be configured in your table mapping for company-level fields to work.
Troubleshooting
| Issue | Resolution |
|---|---|
| Field not in dropdown | Verify the field exists on your Contacts or Companies table and that your table mapping is configured correctly |
| Data not writing | Check that the destination is enabled and the Airtable integration is still connected |
| Contact not found | TrailSpark matches by email -- ensure the contact exists with a valid email in your Contacts table |
| Propensity not updating company | Verify the Contact → Company link field is configured in table mapping |
| Buying-group fields not writing | Confirm the "Push buying-group fields" toggle is on and the field is mapped |
| "No Airtable Integrations" message | Connect Airtable first from Settings > CRM Integration > Connect tab |
Next Steps
- Salesforce Destination
- HubSpot Destination
- Account coverage -- Understand the values being pushed