LEAD GENERATION
Dedupe scanned conference badges and match against your CRM
Ingests a raw badge-scan export, collapses duplicate scans of the same person, and matches each unique attendee against existing HubSpot contacts so you know who is already…
How it runs
The automated pipeline, trigger to output.
- TriggerNew badge-scan file in Drive folderGoogle Drive
- ActionParse export and normalize fields
- LogicCollapse duplicate scans by email and company
- ActionLook up each attendee in HubSpotHubSpot
- LogicTag row Known or Net-new
- OutputWrite reconciled list to AirtableAirtable
What it does
Turns a messy badge-scan CSV into a clean, deduplicated attendee list with a CRM-match verdict on every row. It collapses repeat scans (the same person scanned at three booth stations), normalizes name and email formatting, and checks each unique attendee against your HubSpot contacts. The output is a single reconciled sheet marking each attendee as Known (already in CRM) or Net-new.
When to use it
Run this the day after a conference or trade show once the badge-scanner export lands in Drive. It is the first pass before any SDR claims leads — it removes the noise so reps never waste time on duplicate or already-owned contacts.
How it works
- 1A new badge-scan file dropped in a Google Drive folder triggers the run.
- 2The pipeline parses the export and normalizes emails, names, and company strings.
- 3Duplicate scans are collapsed by email (falling back to name + company), keeping the richest record.
- 4Each unique attendee is looked up in HubSpot by email and domain.
- 5A branch tags every row Known or Net-new based on the match result.
- 6The reconciled list is written to an Airtable base for downstream claiming.
Set it up
What you configure once, before turning it on.
- 1Connect Google DriveDocs, sheets, slides, files.
- 2Connect HubSpotCRM, deals, marketing, support.
- 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
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.
Score Zoom webinar poll answers into a tiered outreach queue
When a Zoom webinar ends, pull each attendee's poll responses, compute an intent score, and write a tiered (Hot/Warm/Cold) outreach queue to Airtable for the sales team to work.
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.
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.
Agent-driven Brave intent harvest with enrichment and Gmail draft outreach
A CEO-driven agent harvests intent signals from Brave, enriches each prospect via web research, writes a personalized cold email.
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.
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.
