LEAD GENERATION

Bulk Podcast-Guest List Enrichment to Salesforce Leads

Drop a raw CSV of podcast guests into a watched folder and this enriches every row with company, role, and firmographics, dedupes against existing records.

CategoryLead Generation
Enginesim
Difficultyintermediate
Triggerevent
Steps5
Setup~15 min

How it runs

The automated pipeline, trigger to output.

  • TriggerNew CSV lands in Drive folderGoogle DriveGoogle Drive
  • ActionParse CSV into guest rows
  • ActionEnrich each row via ExaExa
  • LogicDedupe and filter by firmographics
  • OutputBulk-create qualified Salesforce leadsSalesforce

What it does

Takes a messy, hand-collected list of podcast guests and turns it into clean, enriched Salesforce leads. You drop a CSV; it fills in company, title, industry, and headcount for every row, removes duplicates and existing accounts, and loads only the qualified, net-new contacts.

When to use it

Use this for one-off batch jobs — you've manually pulled a list of guests from a conference's speaker lineup or a season's worth of episodes and need it cleaned, enriched, and into the CRM without typing each record. Great for periodic backfills rather than continuous monitoring.

How it works

  1. 1A new CSV landing in the watched Google Drive folder triggers the run.
  2. 2The file is parsed into individual guest rows.
  3. 3Exa enriches each row with company, title, industry, and headcount from the live web.
  4. 4A dedupe step drops rows that already exist as Salesforce leads or contacts.
  5. 5A filter keeps only rows that meet your minimum firmographic bar.
  6. 6Qualified rows are bulk-created as Salesforce leads with a source tag of the original list name.

Set it up

What you configure once, before turning it on.

  1. 1
    Connect Google DriveDocs, sheets, slides, files.
  2. 2
    Connect ExaNeural search across the web.
  3. 3
    Connect SalesforceAccounts, opportunities, cases.
  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.