📱 Airtable Extension Guide

Version 1.2.0 | Updated: December 2024
🎯 Official Extension: This is the official Airtable extension for the DataHQ Lead Enricher Apify actor. Developed and maintained by DataHQ, this extension provides seamless integration with our powerful lead enrichment infrastructure.

The Airtable Lead Enricher Extension allows you to enrich leads directly from your Airtable base without leaving the interface. Process up to 1,000 records per batch with real-time progress tracking. All data is securely processed through DataHQ's infrastructure.

📌 New in v1.2.0: Modular architecture, smart field mapping with fuzzy matching, increased batch size to 1,000 records, improved security features, and comprehensive documentation.

✨ Key Features

⚡ Batch Processing

Enrich up to 1,000 leads at once with progress tracking

🎯 Smart Mapping

Auto-fill field mappings with fuzzy matching algorithm

🔒 Secure

Keys stored locally in browser, show/hide toggle, clear all option

📊 Real-time Tracking

Live progress updates with status and completion percentage

🔍 Flexible Filtering

Filter by enrichment status, selected records, or custom views

🤖 AI-Powered

Optional OpenAI integration for lead scoring and insights

🚀 Installation

1 Open Your Airtable Base

Navigate to the Airtable base where you want to enrich leads.

2 Add the Extension

Click the Extensions button in the top right corner, then click + Add an extension.

3 Search & Install

Search for "Airtable Lead Enricher" in the marketplace and click Add extension.

💡 Note: The extension will appear in your base's sidebar. You can move or resize it as needed.

📖 Quick Start Guide

Once installed, the extension opens with a 3-step workflow to configure and enrich your leads.

1 Configure API Keys

Step 1: API Keys Configuration with security features and API key inputs

Required:

Optional (for enhanced features):

  • OpenAI API Key: For AI-powered lead scoring and insights
  • ICP Criteria: Your ideal customer profile (e.g., "B2B SaaS, 50-500 employees")
  • Hunter.io API Key: For LinkedIn, Facebook, Twitter profile discovery
✅ No Airtable PAT Required! The extension uses API mode and has direct access to your Airtable data.

Security Features:

  • 🔒 Keys stored locally in your browser only
  • 👁️ Show/Hide toggle for sensitive data
  • 🗑️ Clear All button to reset settings

Click "Continue" when done.

2 Map Your Fields

Step 2: Field Mapping with smart auto-fill and interactive field selection

Input Fields (your Airtable data):

  • Company Name Field: Which field contains company names
  • Website Field: Which field contains websites
  • Location Field: (Optional) Which field contains location data

Output Fields (where to write enriched data):

  • Click "Auto-fill" to automatically match fields using fuzzy matching
  • Or manually select "+ Add field mapping..." to map each field
  • Remove unwanted mappings with the X button
💡 Smart Auto-Fill: The extension uses fuzzy matching to automatically map fields. It handles variations like:
  • "lead_score" → "Lead Score" (exact match)
  • "icp score" → "ICP Score" (contains match)
  • "linkedin" → "LinkedIn URL" (word match)

Click "Continue" to proceed.

3 Select Records & Enrich

Step 3: Record selection with filtering options and batch configuration

Configuration Options:

Setting Description Recommendation
Table Select which table contains your leads Your main leads table
View Select which view to process Create a filtered view for specific criteria
Filter • Not enriched yet - Only records without enrichedAt
• All records - Process all matching records
• Retry failed - Re-process failed enrichments 		"Not enriched yet" to avoid duplicates
Max Records How many records to process (1-1000) Start with 10-20 for testing
⚠️ Selected Records Priority: If you have records selected in your Airtable view, the extension will ONLY process those selected records (up to the max limit).

The summary shows:

  • ✓ Number of selected records (if any)
  • X records ready to enrich
  • AI scoring enabled/disabled
  • Social profiles enabled/disabled

Click "Enrich X Records" to start.

⏳ Tracking Progress

Enrichment in Progress
(Add screenshot: screenshots/05-enrichment-progress.png)

Once started, you'll see:

  • Progress Bar: Visual indication of completion (0-100%)
  • Status: Current activity (Running, Fetching data, Writing to Airtable)
  • Processed Records: Count of completed records
  • Run ID: Unique identifier for this enrichment run
  • View in Apify Console → Link to detailed logs
⏱️ Estimated Time: Each record takes approximately 3-5 seconds to enrich. A batch of 100 records typically completes in 5-8 minutes.

✅ Completion

Enrichment Complete
(Add screenshot: screenshots/06-enrichment-complete.png)

When complete, you'll see:

  • ✅ "Enrichment Complete" message
  • Confirmation that data has been written to Airtable
  • Final record count and run details
  • "← Enrich More Leads" button to return to Step 3

All enriched data is automatically written back to your Airtable base using the field mappings you configured.

📋 Field Reference

Available enriched fields that can be mapped to your Airtable columns:

Enriched Field Type Description
Email Text Primary contact email
Phone Text Primary contact phone
Address Text Physical business address
Industry Text Business industry/category
Employee Count Number Estimated number of employees
LinkedIn URL URL Company LinkedIn profile
Facebook URL URL Company Facebook page
Twitter Handle Text Company Twitter username
Lead Score Number (0-100) AI-generated lead quality score
ICP Score Number (0-100) Ideal customer profile match score
ICP Reasoning Long Text Explanation for ICP score
Summary Long Text AI-generated company summary
Outreach Angles Long Text Suggested outreach strategies
Tech Stack Text Technologies used by company
Rating Number Google Maps rating (if available)
Review Count Number Number of Google reviews
Category Text Business category from Google Maps
Description Long Text Business description
Data Confidence Number (0-100) Confidence score for enriched data
Enriched At Date/Time Timestamp of enrichment
Enrichment Sources Text List of data sources used

🔧 Troubleshooting

Extension Won't Load

  • ✅ Verify you're using Node.js 14+ and npm 7+
  • ✅ Run npm install in the extension directory
  • ✅ Try npm start again
  • ✅ Clear browser cache and reload

"Invalid API Token" Error

  • ✅ Verify Apify token is correct (starts with apify_api_)
  • ✅ Check token hasn't expired
  • ✅ Ensure token has proper permissions in Apify Console

No Records Found

  • ✅ Check table and view are selected correctly
  • ✅ Verify records have both Company Name and Website filled
  • ✅ Try "All records" filter first to test
  • ✅ Make sure view isn't filtered to exclude all records

Enrichment Stuck at "Processing"

  • ✅ Check Apify console for actual run status
  • ✅ Extension polls every 5 seconds for updates
  • ✅ Large batches (500+ records) can take 25-40 minutes
  • ✅ If stuck for >10 minutes, check run in Apify Console

Data Not Writing to Airtable

  • ✅ Verify output field mappings are correct
  • ✅ Check field types match (Number fields need number data)
  • ✅ Ensure field names haven't changed in your base
  • ✅ Check browser console for error messages

💡 Best Practices

Testing Before Production

  1. Create a "Test" view with 5-10 known companies
  2. Run enrichment on test view first
  3. Verify all fields populate correctly
  4. Check data quality and accuracy
  5. Then scale to full production batches

Cost Optimization

  • Use "Not enriched yet" filter to avoid re-processing
  • Start with smaller batches (50-100) to test
  • Only enable AI features (OpenAI, Hunter.io) when needed
  • Monitor usage in Apify Console

Field Mapping Tips

  • Use consistent field names (e.g., "Lead Score" not "score lead")
  • Create numeric fields in Airtable for scores and counts
  • Use long text fields for summaries and reasoning
  • URL fields for social media links
  • Date field for "Enriched At" timestamp

Performance Tips

  • Optimal batch size: 100-200 records
  • Keep extension tab open during processing
  • Don't refresh the page during enrichment
  • Use filtered views to process specific segments

📜 Version History

v1.2.0 (Current - December 2024)

  • ✨ Refactored to modular architecture (18 files)
  • ✨ Increased max records from 100 to 1,000
  • ✨ Added smart auto-fill with fuzzy matching
  • ✨ Improved security (show/hide keys, clear all)
  • ✨ Added Terms of Service and Privacy Policy
  • 🐛 Fixed numeric field type conversion
  • 📚 Comprehensive documentation with screenshots

v1.1.0

  • ✨ Switched from batch mode to API mode
  • ✨ Removed Airtable PAT requirement
  • ✨ Added flexible field mapping
  • ✨ Added selected records support

v1.0.0

  • 🎉 Initial release
  • ✨ Basic enrichment functionality
  • ✨ Progress tracking

🆘 Support & Resources

Documentation • Extension Guide • Terms • Privacy