Agents Lookup

Use cases / Sales & outreach

CRM hygiene: duplicate contacts and stale-deal flags

A weekly agent pass finds likely duplicate contacts and deals that have gone quiet, then hands the owner a short review list instead of silently changing records.

DifficultyBeginner
Setup time3–5 hours (estimate)
CategorySales & outreach

The use case

In a small business CRM, the same person ends up entered three times from a web form, a business card, and an imported spreadsheet, and deals sit in Proposal Sent for months after the buyer went silent. Pipeline reports become unreliable and follow-ups get missed. A hygiene agent runs weekly, compares contacts for probable duplicates using name, email, domain, and phone, and flags open deals with no activity past a threshold you set. It produces a review list with a suggested action per item. The account owner approves merges or stage changes; the agent never deletes or merges on its own.

Example workflow

  1. A weekly schedule in Zapier or Make starts the run and exports contacts and open deals from the CRM.
  2. The agent groups contacts that likely refer to the same person and notes which fields conflict.
  3. It flags open deals with no logged activity, email, or task beyond the inactivity window you define.
  4. Claude writes a plain-language reason and suggested action for each flag, such as merge, update stage, or schedule a check-in.
  5. The review list lands in a Google Sheet or Slack message assigned to each record's owner.
  6. Owners approve or reject each item, and only approved changes are applied in the CRM by the owner or an approved automation step.
  7. Every approved change is logged with date, approver, and before-and-after values.

Tools

Risks and guardrails

Related recipe

Weekly KPI Digest from Google Sheets with Source-Cited Numbers: An agent reads your defined metrics from Google Sheets, compares them to last week and targets, and drafts a plain-English digest where every number cites its cell. The owner approves before it goes to Slack or email.

Want it set up for you? Request a quote.

Sources

Written by Agents Lookup. Credits and official pages for the tools this use case names: