LEAD GENERATION
Harvest Guest Sites from Podcast Show Notes into Airtable
Crawls a list of podcast episode pages, extracts each guest's name, company, and personal website from the show notes.
How it runs
The automated pipeline, trigger to output.
- TriggerWeekly schedule fires with episode URL list
- ActionScrape each show-notes page to markdownFirecrawl
- ActionExtract guest name, company, and websiteOpenAI
- LogicDrop rows with no site or duplicate domain
- OutputWrite unique guests as prospect rowsAirtable
What it does
Given a list of podcast episode URLs, this workflow scrapes each show-notes page, pulls out the guest's name, company, and outbound website link, and writes one row per guest into an Airtable prospecting base. It dedupes against sites you've already captured so the base stays clean.
When to use it
Run this when you've identified a few relevant podcasts in your niche and want to turn their back catalog of episodes into a structured list of guest websites worth pitching for a backlink or guest post.
How it works
- 1A scheduled run fires weekly (or on demand) with the configured list of episode URLs.
- 2Firecrawl scrapes each episode page and returns clean markdown of the show notes.
- 3An OpenAI extraction step parses the markdown into structured fields: guest name, company, role, and primary website URL.
- 4A logic step filters out rows with no website and drops any domain already present in the base.
- 5Airtable receives each surviving guest as a new prospect row, tagged with the source podcast and episode.
Set it up
What you configure once, before turning it on.
- 1Connect FirecrawlCrawl, scrape, structured extract.
- 2Connect OpenAIModels, embeddings, files.
- 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
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.
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.
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.
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).
Instantly triage uploaded badge CSVs and notify the SDR lead
Accepts a badge-scan CSV via webhook, validates and dedupes it on the spot, checks each attendee against HubSpot.
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.