# Airtable Lead Enrichment

> Pull leads from your Airtable base, enrich them with Apollo and LinkedIn data, and write everything back automatically.

Source: https://cotera.co/solutions/sales/airtable-lead-enrichment

---

- **Team:** Sales
- **Tools:** Airtable, Apollo, LinkedIn
- **Difficulty:** medium
- **Setup time:** 10 min
- **Time saved:** 2 hrs/batch

## How it works
1. **Pull Leads** — Search Airtable for records matching your criteria
2. **Enrich via Apollo** — Get title, company, seniority, and contact info
3. **Get LinkedIn Intel** — Pull recent posts and activity for each lead
4. **Write Back** — Update each Airtable record with enriched data

## Example requests
- Enrich all leads in my Inbound table that are missing a LinkedIn URL
- Pull the 20 most recent leads from my Sales Pipeline base and enrich them
- Find all leads where Company Size is empty and fill it in from Apollo

## Prompt

```markdown
## 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 Records to pull leads matching the user's criteria (e.g., filter by empty LinkedIn URL field)
2. For each lead, use @Apollo/Enrich Person with their email or name + company to get full profile data
3. Use @LinkedIn/Get Profile with Posts to get their recent activity and posts
4. Use @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."
```

## Related reading
- [Airtable API Automation: We Built It, Then We Replaced It with an Agent](https://cotera.co/articles/airtable-api-automation-guide.md)
- [We Built a CRM in Airtable. Then We Taught an Agent to Run It.](https://cotera.co/articles/airtable-crm-automation-guide.md)