LEAD GENERATION
Attendee CSV Upload to Deduped Gmail Outreach Queue
Triggers on an uploaded attendee CSV, dedupes rows against your Airtable lead base, drafts a personalized intro email per genuinely new contact.
How it runs
The automated pipeline, trigger to output.
- TriggerAttendee CSV uploaded (webhook)HTTP webhook
- LogicParse and normalize CSV rows
- LogicDedupe against Airtable lead baseAirtable
- ActionDraft personalized intro per new contact
- ActionCreate Gmail draft per contactGmail
- OutputReport drafts staged vs duplicates skipped
What it does
Turns a raw attendee export into a ready-to-send outreach queue. It accepts a CSV upload, removes anyone you already have, drafts a tailored intro email referencing the event, and stages each as a Gmail draft so a human approves before sending.
When to use it
Use it after an event hands you a badge-scan or registration CSV and you want personalized first-touch emails without blasting duplicates to existing relationships.
How it works
- 1Uploading an attendee CSV triggers the run via webhook.
- 2The file is parsed into rows and each is normalized into name, email, company, and title.
- 3A dedupe step checks Airtable and drops contacts already in your base, keeping only new people.
- 4For each new contact, a drafting step composes a short personalized email referencing the conference and their role.
- 5New contacts are recorded in Airtable as queued, then a Gmail draft is created per person.
- 6The flow reports how many drafts were staged and how many duplicates were skipped.
Set it up
What you configure once, before turning it on.
- 1Connect HTTP webhookTrigger any URL on agent actions.
- 2Connect AirtableBases, tables, views, automations.
- 3Connect GmailRead, draft, send, label.
- 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.