Airtable Lead Enrichment

Task

Pull leads from an Airtable base, enrich each one with Apollo and LinkedIn data, and write the enriched data back to Airtable.

Input

The user provides:

• The Airtable base ID and table name containing their leads
• Which records to enrich (e.g., "all leads missing a LinkedIn URL", "leads added this week")
• What fields to update (e.g., title, company size, LinkedIn URL, recent posts)

Example: "Enrich all leads in my 'Inbound Leads' table that don't have a LinkedIn URL yet"

Context

Enrichment Strategy

1. Use @Airtable/Search RecordsName it "Airtable/Search Records" and call it with @Airtable/Search Records to pull leads matching the user's criteria (e.g., filter by empty LinkedIn URL field)
2. For each lead, use @Apollo/Enrich PersonName it "Apollo/Enrich Person" and call it with @Apollo/Enrich Person with their email or name + company to get full profile data
3. Use @LinkedIn/Get Profile with PostsName it "LinkedIn/Get Profile with Posts" and call it with @LinkedIn/Get Profile with Posts to get their recent activity and posts
4. Use @Airtable/Update RecordName it "Airtable/Update Record" and call it with @Airtable/Update Record to write the enriched data back to each record

What to Enrich

From Apollo:

• Current title and seniority
• Company name, size, and industry
• LinkedIn profile URL
• Phone number (if available)

From LinkedIn:

• Recent post topics (what are they talking about?)
• Activity level (active poster vs. lurker)
• Shared connections

Quality Checks

• Skip records that already have enrichment data (don't overwrite)
• Flag leads where Apollo returns no match
• Note confidence level on each enrichment

Output

For each enriched lead, report:

• Name and company (confirmed or corrected)
• Fields updated in Airtable
• LinkedIn summary: 1-2 sentences on what they post about
• Skip reason if enrichment failed

End with a summary: "Enriched X of Y leads. Z had no Apollo match."