LEAD GENERATION
Podcast Back-Catalog Guest Scrape to Airtable Research Queue
Crawls a podcast's entire back catalog once, extracts every past guest, dedupes them, and builds a scored research queue in Airtable for the SDR team to work through.
How it runs
The automated pipeline, trigger to output.
- TriggerManual run started with podcast feed URL
- ActionCrawl full archive and extract guests per episodeApify
- ActionEnrich each unique guest with firmographicsExa
- LogicScore fit and dedupe repeat guests
- OutputBuild scored research queue in AirtableAirtable
What it does
Mines a podcast's full episode archive in a single pass and turns years of guests into one organized, deduplicated research queue in Airtable. Each guest gets a fit score based on company size and role so the team works the best-fit prospects first.
When to use it
Use this once when onboarding a new target podcast, or when you adopt a show with a deep archive. It is the bulk-import counterpart to the live episode monitors: instead of trickling in new guests, you seed the pipeline with the entire historical roster in one run.
How it works
- 1A manual run starts the archive crawl with the podcast's feed URL.
- 2Apify paginates the full episode list and extracts guest names per episode.
- 3Exa enriches each unique guest with company, headcount, and title.
- 4A scoring step assigns a fit score and routes anyone below threshold to a parked status.
- 5A dedupe filter collapses repeat guests across episodes into one record.
- 6Airtable creates rows in the research queue with score, source episodes, and status.
Set it up
What you configure once, before turning it on.
- 1Connect ApifyActors, scrapers, datasets.
- 2Connect ExaNeural search across the web.
- 3Connect AirtableBases, tables, views, automations.
- 4Set each agent's modelWe leave models unset so you pick the tier — fast + cheap, or top-quality.
- 5Tune it to your dataEdit the prompts, filters, and field mappings so it matches how your team works.
- 6Test, then turn it onRun once against a sample, confirm the output, then enable the trigger.
More Lead Generation workflows
Webhook-triggered Brave rising-keyword check into a Notion trend queue
When an external trend or alert tool fires a webhook with a keyword, checks Brave for current intent volume and freshness, has an LLM judge whether it's a real warm signal.
Fuzzy-match badge companies to Salesforce accounts and enrich
Resolves messy hand-typed company names from badge scans to canonical Salesforce accounts using domain and fuzzy-name matching, enriches missing firmographics.
Manual Brave keyword sweep into an Airtable research board
On demand, sweeps a topic across Brave Search, clusters the results by buying stage with an LLM, and writes a deduplicated research board to Airtable with company, source URL.
Daily rollup of scored webinar leads from Airtable into HubSpot lists
On a schedule, read newly scored webinar leads from Airtable, sync each into the matching HubSpot tiered list (Hot/Warm/Cold).
Fast-track hot webinar leads into HubSpot and ping the rep on Slack
After a webinar, identify attendees whose poll answers signal high purchase intent, create or update their HubSpot contact with a lead score.
Classify open-text webinar poll answers with AI and enrich the lead record
For webinars that use free-text poll questions, an AI step reads each attendee's written answers, classifies intent and pain points into structured fields.
Run it inside a business
This workflow drops into a full company template. Import the org, and this is one of the playbooks its agents run.
Run this workflow in your colony.
14-day trial. No DevOps. No Sales call. Provisioned in under a minute.