CRM
Nightly Airtable Duplicate Cluster Review Queue
Runs every night to cluster fuzzy-duplicate contacts in an Airtable base and writes each cluster to a review queue table where an operator picks the master record before merging.
How it runs
The automated pipeline, trigger to output.
- TriggerNightly schedule
- ActionRead active contacts from AirtableAirtable
- LogicCluster fuzzy duplicates; drop singletons
- ActionWrite clusters to Airtable Review QueueAirtable
- OutputArchive losers into master after confirmationAirtable
What it does
On a nightly schedule, this template groups likely-duplicate contact records in Airtable into clusters and stages them in a dedicated review-queue table. An operator chooses the surviving master per cluster, and the flow then folds the rest into it.
When to use it
Use this when contacts accumulate in Airtable from imports, events, and integrations, and you want a calm batch review each morning instead of real-time interruptions. Ideal for teams that own dedupe as a daily hygiene chore.
How it works
- 1A nightly schedule trigger starts the run.
- 2The flow reads all active contacts from the Airtable contacts table.
- 3A logic step computes similarity on email, phone, and normalized name, grouping records into duplicate clusters and dropping singletons.
- 4Each multi-record cluster is written to a Review Queue table with a suggested master flagged.
- 5The next morning an operator confirms or changes the master per row.
- 6A follow-up pass reads confirmed rows and updates the losing records to point at the master, then archives them.
Set it up
What you configure once, before turning it on.
- 1Connect AirtableBases, tables, views, automations.
- 2Set each agent's modelWe leave models unset so you pick the tier — fast + cheap, or top-quality.
- 3Tune it to your dataEdit the prompts, filters, and field mappings so it matches how your team works.
- 4Test, then turn it onRun once against a sample, confirm the output, then enable the trigger.
More CRM workflows
Dormant Account Check-In Call Scheduler
On the anniversary of an account's last touch, books a tentative check-in call on the owner's Google Calendar and emails the contact a scheduling invite.
Weekly Dormant-Anniversary Cohort Digest
Every week, groups dormant Attio accounts by which last-touch anniversary they hit that week, builds a prioritized digest.
AI-Personalized Dormant Account Win-Back
On a dormancy anniversary, an agent researches the account's history and recent public signals, drafts a genuinely personalized win-back email.
Backfill Intercom conversation topics onto stale HubSpot contacts
Finds HubSpot contacts with no recent Intercom topic, pulls their conversation history from Intercom, classifies the dominant topic with OpenAI.
Daily orphaned-opportunity sweep with manager Slack digest
Each morning this scans Salesforce for open opportunities owned by inactive users and posts a per-manager digest in Slack listing the orphaned deals that need a new owner.
Tag closed Intercom conversations onto Salesforce contacts in real time
On each Intercom conversation close, classifies the topic with OpenAI and appends it to the matching Salesforce contact's activity timeline so the topic never goes stale…
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.