LEAD GENERATION
Merge attendee lists across multiple events into one master record
On a schedule, pulls badge-scan exports from several event folders, merges them into a single deduplicated master attendee record.
How it runs
The automated pipeline, trigger to output.
- TriggerWeekly schedule
- ActionGather new exports across event foldersGoogle Drive
- ActionNormalize and match against master by email
- LogicBranch: update existing vs create new record
- ActionRecompute touch counts and event lists
- OutputWrite updated master table to AirtableAirtable
What it does
Consolidates badge data from every event you run into one master attendee table. It dedupes a person across shows — someone scanned at three conferences becomes one record with an attended-events list and a touch count. Repeat attendees, the warmest prospects, rise to the top because the system tracks frequency rather than treating each event as a fresh import.
When to use it
Use it if you work a circuit of events and want a cumulative view of who keeps showing up, instead of siloed per-event spreadsheets. Run it weekly so each new event's export folds into the master automatically.
How it works
- 1A weekly schedule triggers the run.
- 2The flow gathers all new badge-scan exports across the configured event folders in Google Drive.
- 3Records are normalized and matched against the existing master table by email.
- 4A branch decides per record: append the event to an existing person, or create a new master record.
- 5Touch counts and attended-event lists are recalculated for matched people.
- 6The updated master table is written to Airtable with repeat attendees flagged for priority outreach.
Set it up
What you configure once, before turning it on.
- 1Connect Google DriveDocs, sheets, slides, files.
- 2Connect AirtableBases, tables, views, automations.
- 3Set each agent's modelWe leave models unset so you pick the tier — fast + cheap, or top-quality.
- 4Tune it to your dataEdit the prompts, filters, and field mappings so it matches how your team works.
- 5Test, 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.