LEAD GENERATION

Clean and Enrich an Uploaded Attendee List into Airtable

Takes an uploaded webinar or event attendee CSV, dedupes against existing records, enriches every valid contact.

CategoryLead Generation
Enginesim
Difficultybeginner
Triggerwebhook
Steps6
Setup~5 min

How it runs

The automated pipeline, trigger to output.

  • TriggerWebhook fires when attendee CSV is uploadedHTTP webhook
  • LogicParse CSV and validate emails and required fields
  • ActionDedupe against existing Airtable recordsAirtableAirtable
  • ActionEnrich new contacts with firmographicsExa
  • LogicScore fit and split clean leads from rejects
  • OutputWrite scored leads and log rejects to AirtableAirtableAirtable

What it does

Ingests a messy attendee CSV and produces a clean, enriched, de-duplicated lead sheet. It validates emails, removes people already in your base, enriches the rest with company and role data, applies a simple fit score, and lands the result in Airtable so the list is usable the moment the upload finishes.

When to use it

Use it whenever a sponsor, partner, or event platform hands you a raw spreadsheet of attendees and you need it deduped and enriched before anyone touches it. Ideal for teams whose system of record is Airtable and who want a repeatable intake instead of manual cleanup.

How it works

  1. 1A webhook fires when an attendee CSV is uploaded, passing the file location.
  2. 2The flow parses the CSV and validates each row's email format and required fields.
  3. 3It queries Airtable to drop contacts that already exist in the base.
  4. 4Exa enriches each new contact with company size, industry, and seniority.
  5. 5A logic step assigns a fit score and routes invalid or unenrichable rows to a rejects table.
  6. 6Clean scored leads are written into the Airtable leads table, with rejects logged separately.

Set it up

What you configure once, before turning it on.

  1. 1
    Connect HTTP webhookTrigger any URL on agent actions.
  2. 2
    Connect ExaNeural search across the web.
  3. 3
    Connect AirtableBases, tables, views, automations.
  4. 4
    Set each agent's modelWe leave models unset so you pick the tier — fast + cheap, or top-quality.
  5. 5
    Tune it to your dataEdit the prompts, filters, and field mappings so it matches how your team works.
  6. 6
    Test, then turn it onRun once against a sample, confirm the output, then enable the trigger.

Run this workflow in your colony.

14-day trial. No DevOps. No Sales call. Provisioned in under a minute.