← All templates

Operations

CRM Hygiene Sweeper

A CRM decays quietly: deals sit untouched, records lose their phone numbers and the pipeline number becomes fiction. This workflow sweeps weekly for anything untouched past your threshold or missing required fields, then creates one review task per record so the pipeline reflects reality.

6 stepsRequires Zapier Starter or higher20 minMedium
HubSpotTodoistGoogle SheetsSlackSchedule by ZapierFilter by Zapier

What you get

Stale deals get closed or revived rather than lingering.
Records missing key fields are fixed weekly, not annually.
Your pipeline forecast is based on live deals only.

Workflow blueprint

SC
When this happens
Schedule by ZapierEvery Week
1HU
HubSpotFind Deals
2FI
Filter by ZapierOnly continue if
3TO
TodoistCreate Task
4GS
Google SheetsCreate Spreadsheet Row
5SL
SlackSend Direct Message

The full blueprint — every field mapping, example value and the written copy for each message — is included with purchase.

Getting it into Zapier

Build this one from the recipe. The blueprint gives you the exact trigger, action events and field mapping for all 6 steps, so it is a copy-and-paste job rather than a design job.

You need your own Zapier account. Zapier’s Free plan runs single-step Zaps only; multi-step Zaps need a paid plan, and Paths and Webhooks need Professional. How this works →

Not on Zapier?

n8n — import and go

An n8n workflow JSON ships with this template. Import it and all 6 steps arrive on the canvas wired in order, and 4 of the 6 nodes arrive with their fields already filled in — the subject lines, the message copy, the delays, the column names. Every step maps to a native n8n node.

What an import cannot carry is your credentials, and the IDs that only exist inside your own account — which spreadsheet, which channel, which board. Those stay in a sticky note under the node, listing what is already done so you do not retype it, and what is left so you can see it.

Make — build guide

A Make-specific guide ships with this template: every module in order, every field value, and the concept translations that catch people out — filters live on the links between modules, and the schedule lives on the scenario rather than in a trigger module.

Self-hosted n8n has no per-task fee, which is worth knowing if this workflow runs at volume. Platform coverage →

Setup steps

1
Sweep every Monday

Configure this step using the field mapping in the blueprint.

2
Find deals untouched for 21 days

Configure this step using the field mapping in the blueprint.

3
Flag records missing key fields

Configure this step using the field mapping in the blueprint.

4
Create one review task per record

Configure this step using the field mapping in the blueprint.

5
Report the sweep result

Configure this step using the field mapping in the blueprint.

Implementation notes

  • Twenty-one days is a starting point. Match it to your real sales cycle — a six-month cycle needs a longer threshold.
  • Pipedrive, Airtable, Zoho CRM, Close and Google Sheets all substitute for HubSpot.
  • Closing a dead deal is a valid outcome. The goal is an accurate pipeline, not a large one.