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.
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
- A weekly schedule in Zapier or Make starts the run and exports contacts and open deals from the CRM.
- The agent groups contacts that likely refer to the same person and notes which fields conflict.
- It flags open deals with no logged activity, email, or task beyond the inactivity window you define.
- Claude writes a plain-language reason and suggested action for each flag, such as merge, update stage, or schedule a check-in.
- The review list lands in a Google Sheet or Slack message assigned to each record's owner.
- Owners approve or reject each item, and only approved changes are applied in the CRM by the owner or an approved automation step.
- Every approved change is logged with date, approver, and before-and-after values.
Tools
- HubSpot or Pipedrive
- Google Sheets
- Claude
- Zapier or Make
- Slack
Risks and guardrails
- Wrong merges can blend two different people's histories; keep merges human-approved and export a backup before applying changes.
- Stale flags can push reps to send pushy messages; frame suggestions as check-ins and keep the send decision with the rep.
- Contacts who opted out could be revived by a merge; preserve the most restrictive consent and unsubscribe status on any merged record.
- Thresholds that are too tight create noise and get ignored; start loose and tune after a few weeks.
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:
- HubSpot MCP server (official page): developers.hubspot.com/ai-tools/mcp (checked 2026-11-09)
- Pipedrive (official page): www.pipedrive.com (checked 2026-11-09)
- Claude (official page): claude.ai (checked 2026-11-09)
- Zapier MCP (official page): zapier.com/mcp (checked 2026-11-09)
- Make MCP server (official page): developers.make.com/mcp-server (checked 2026-11-09)
- Slack MCP server (official page): docs.slack.dev/ai/slack-mcp-server (checked 2026-11-09)