Airtable Lead Enricher

Automatically enrich your Airtable CRM leads with contact info, company data, and AI-powered lead scoring. No Zapier. No middleware. One actor does everything.

📖 View Documentation • 🎭 Try on Apify • 💬 Get Support

---

What It Does

Reads incomplete leads from Airtable → Enriches from multiple sources → Writes back automatically.

Before:

Company Name	Website	Email	Phone
Acme Corp	https://acme.com	-	-

After (30 seconds later):

Company Name	Email	Phone	Rating	Lead Score
Acme Corp	contact@acme.com	+1 555 0100	4.5	85

---

Key Features

• Contact Discovery - Email, phone from website + Google Maps
• Verified Emails - Hunter.io integration (BYOK)
• Social Profiles - LinkedIn, Facebook, Twitter (via Hunter.io)
• AI Lead Scoring - 0-100 score with ICP matching
• Batch Processing - Up to 100 leads per run
• Scheduled Runs - Daily/hourly automated enrichment
• Webhook Support - Real-time notifications
• BYOK - Bring your own LLM keys

---

Quick Start (3 Minutes)

1. Get Airtable Token

1. Go to airtable.com/create/tokens
2. Create token with scopes: data.records:read, data.records:write
3. Copy token (starts with pat)

2. Get Your IDs

• Base ID: From URL https://airtable.com/appXXXXXX/... → copy appXXXXXX
• Table ID: Click ... on table → "Copy table ID" → starts with tbl

3. Run

{
  "airtable": {
    "apiKey": "patXXXXXXXXXXXXXX",
    "baseId": "appXXXXXXXXXXXXXX",
    "tableId": "tblXXXXXXXXXXXXXX",
    "inputFields": {
      "companyName": "Company Name",
      "website": "Website"
    }
  }
}

---

Pricing

$0.03 per lead enriched

Leads	Cost
100	$3.00
1,000	$30.00

vs. Competitors: Clearbit $0.36 (12x), Apollo $0.15 (5x), ZoomInfo $0.50+ (17x)

---

Data Sources

Source	Fields	API Key?
Website	email, phone, description, techStack	No
Google Maps	phone, address, rating, reviewCount, category	No
Hunter.io	email (verified), LinkedIn, Facebook, Twitter	Yes (BYOK)
AI/LLM	leadScore, icpScore, summary	Yes (BYOK)

---

Output Fields

Field	Type	Source
email	string	Website / Hunter
phone	string	Google Maps / Website
address	string	Google Maps
category	string	Google Maps
rating	number	Google Maps (0-5)
reviewCount	number	Google Maps
description	string	Website
techStack	string	Website
industry	string	Website / AI
foundingYear	number	Website
employeeCount	string	Website
companyStage	string	Website / AI
linkedinUrl	string	Hunter.io
leadScore	number	AI (0-100)
icpScore	number	AI (0-40)
summary	string	AI
targetCustomers	string	AI (with ICP)
valueProposition	string	AI (with ICP)
keyProducts	array	AI (with ICP)
outreachAngles	array	AI (with ICP)
enrichedAt	datetime	System

---

AI-Generated Outreach Angles

When ICP criteria is provided, the AI automatically generates 3-4 personalized outreach talking points tailored to each lead:

{
  "outreachAngles": [
    "Reference their 25,000+ employee scale and potential LLM cost optimization needs",
    "Lead with multi-provider AI usage (OpenAI, Anthropic, Google) as a pain point",
    "Mention compliance-ready infrastructure needs (BYOK, SOC2, HIPAA) for legal tech market",
    "Ask about intelligent routing challenges across different LLM providers"
  ]
}

Key Features:

• Contextualized to company characteristics (size, industry, tech stack)
• Connected to your ICP requirements
• Actionable conversation starters
• Only generated when ICP criteria is defined

Example: For a B2B SaaS company selling to enterprises with 500+ employees, the AI might generate angles focusing on scale, compliance, and integration challenges specific to that lead.

---

Configuration

Minimal

{
  "airtable": {
    "apiKey": "patXXX",
    "baseId": "appXXX",
    "tableId": "tblXXX",
    "inputFields": {
      "companyName": "Company Name",
      "website": "Website"
    }
  }
}

With AI Scoring

{
  "airtable": {
    "apiKey": "patXXX",
    "baseId": "appXXX",
    "tableId": "tblXXX",
    "filterFormula": "NOT({enrichedAt})",
    "inputFields": {
      "companyName": "Company Name",
      "website": "Website"
    }
  },
  "llm": {
    "enabled": true,
    "provider": "openai",
    "apiKey": "sk-XXX"
  },
  "scoring": {
    "icpCriteria": "B2B SaaS companies, 50-500 employees"
  }
}

With Hunter.io (Social Profiles)

{
  "enrichment": {
    "sources": ["google_maps", "website", "hunter"],
    "hunter": {
      "enabled": true,
      "apiKey": "YOUR_HUNTER_KEY"
    }
  }
}

---

Processing Modes

Mode	Use Case	Required Fields
batch	Scheduled enrichment	airtable config
single	Webhook-triggered	recordIds array
api	No Airtable (data pipelines)	companies array

Single Mode (Webhook)

{
  "mode": "single",
  "recordIds": ["recABC123"],
  "airtable": { ... }
}

API Mode (No Airtable)

{
  "mode": "api",
  "companies": [
    {"companyName": "Acme", "website": "https://acme.com"}
  ],
  "webhookUrl": "https://your-system.com/webhook"
}

---

Airtable Integration Options

Option 1: Extension (Recommended for Batch Processing)

Install the Airtable Extension for batch enrichment with filtering:

• ✨ Batch process up to 100 leads
• 📊 Select any view + apply filters
• ⚙️ Built-in configuration UI
• 📈 Real-time progress tracking

📦 airtable-extension/ - Full-featured batch processor

Option 2: Button (Best for Real-Time)

Add a one-click "Enrich" button for real-time enrichment (30-60 seconds):

• 🔘 One-click per record
• ⚡ Real-time enrichment
• 🎯 Perfect for ad-hoc needs

📖 docs/AIRTABLE_BUTTON_SETUP.md - Step-by-step automation setup

---

Common Use Cases

Real-Time Button Click

User clicks "Enrich" button → Actor runs instantly → Data appears in ~60 seconds

See docs/AIRTABLE_BUTTON_SETUP.md for full setup.

Scheduled Nightly Enrichment

{
  "airtable": {
    "filterFormula": "NOT({enrichedAt})",
    "maxRecords": 100
  }
}

Schedule: 0 2 * * * (daily at 2 AM)

Real-Time (Airtable Automation)

1. Airtable trigger: "When record enters view"
2. Action: Send webhook to Apify
3. Body: {"mode": "single", "recordIds": ["{Record ID}"]}

Dry-Run (Preview)

{
  "dryRun": true,
  "airtable": { "maxRecords": 3 }
}

---

Troubleshooting

Error	Solution
Invalid API key	Use PAT (starts with pat), not old API key
Unknown field name	Field names are case-sensitive
No records found	Check filterFormula, viewId
Social links missing	Enable Hunter.io (website crawler doesn't extract social)
LLM rate limit	Reduce concurrency or check API quota

---

Update Modes

Mode	Behavior
append	Only fill empty fields (default)
overwrite	Replace all fields
skip	Skip if any field has data

---

LLM Providers

Provider	Model	Cost/Lead
OpenAI	gpt-4o-mini	~$0.001
Anthropic	claude-3-5-haiku	~$0.001
AWS Bedrock	claude-3-5-haiku	~$0.0004

---

API Integration

For data pipelines (Lambda, Airflow, Glue, Snowflake), use API mode:

import requests

response = requests.post(
    "https://api.apify.com/v2/acts/datahq~airtable-lead-enricher/run-sync-get-dataset-items",
    params={"token": "YOUR_APIFY_TOKEN"},
    json={
        "mode": "api",
        "companies": [{"companyName": "Acme", "website": "https://acme.com"}]
    }
)
results = response.json()

Full integration docs: https://docs.airtable-lead-enricher.datahq.pro

---

Links

• 📖 Documentation Home
• ⚙️ Full Configuration Guide
• 🔌 External Integrations
• 🐍 Pipeline Examples
• 📚 API Reference
• 🎭 Apify Actor Page
• 🐛 Report Issues

---

Enrich leads, not your stress levels.