LEAD GENERATION
Merge Multi-Booth Scan Exports Into One Deduped Master List
On a schedule during the event, pulls badge-scan exports from several booth files in Google Drive, merges them into a single deduplicated attendee master list in Airtable.
How it runs
The automated pipeline, trigger to output.
- TriggerScheduled run during show hours
- ActionList and download all booth scan filesGoogle Drive
- LogicMerge and dedupe across files, tag booths visited
- LogicDiff against existing master list
- ActionUpsert new unique attendees to AirtableAirtable
- OutputPost running unique-lead count to SlackSlack
What it does
At a large event you run several booths or scanners, each producing its own export. Left alone you end up with overlapping lists and no single source of truth. This workflow gathers every booth's export on a recurring schedule, merges them into one master attendee list with cross-file duplicates collapsed, records which booths each person visited, and posts a live total so the team always knows the real unique-lead count.
When to use it
Run it every few hours during a multi-booth conference when scans are landing in separate per-station files and leadership keeps asking how many unique leads you actually have.
How it works
- 1A schedule trigger fires at a set interval during show hours.
- 2A Google Drive step lists and downloads every booth scan file in the shared event folder.
- 3A merge step combines all rows and dedupes across files by email, attaching the list of booths each attendee visited.
- 4A logic step diffs against the existing Airtable master list to find genuinely new attendees.
- 5New unique attendees are upserted into the Airtable master list.
- 6A Slack post reports the new and cumulative unique-lead counts.
Set it up
What you configure once, before turning it on.
- 1Connect Google DriveDocs, sheets, slides, files.
- 2Connect AirtableBases, tables, views, automations.
- 3Connect SlackChannels, DMs, threads, mentions.
- 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.