CRM
Verified by Toolspoke

CRM hygiene report

By Toolspoke

Every Monday, finds stale close dates, missing amounts and next steps, and quiet deals in Salesforce, and posts them to Teams by owner.

Needs a Toolspoke account. You choose which project it installs into.

An illustration with made-up examples. It is not a recording.
Salesforce + Microsoft Teams
Required integrations
Runs on a schedule
Mondays at 9am by default
Post one message
What its last step does
Some actions can delete
3 of 20 actions in its tools
On this page
  1. The short version
  2. What it will never do
  3. What CRM hygiene report does
  4. How it works
  5. What a Monday report looks like
  6. Who uses CRM hygiene report
  7. What it connects to
  8. When it runs
  9. How to set it up
  10. Make CRM hygiene report fit your pipeline
  11. Compared with other options
  12. Questions
  13. Related agents

The short version

What it is
A ready-made Toolspoke agent that finds the gaps in your Salesforce records and tells each owner on Monday.
What it reads
Open opportunities with close date, amount, next step and last activity, and recent contacts with no email address.
Where it posts
One Microsoft Teams channel, grouped by record owner.
What it flags
Close dates in the past, missing amounts, missing next steps, deals quiet for 30 days and contacts with no email.
How often
Mondays at 9am once you switch it on.
What it never does
Create or update a Salesforce record, or call a deal lost.
What you need
A Toolspoke account, a Salesforce sign-in and a Microsoft Teams team.

What CRM hygiene report will never do

CRM hygiene report is told never to create or update a Salesforce record, and never to call a deal lost. It shows the gap and the owner fills it.

CRM hygiene report will never

  • Create or update a Salesforce record: no new close date, amount, next step, owner, task or note.
  • Call a deal lost or recommend closing it.
  • Reply in a thread, message anyone in a chat, or post more than once a run.

Why it does not fix the records

A missing amount or a stale close date has a right value, and only the owner knows it. An agent that filled in a guess would make the data look complete while making it less true.

Why it names gaps, not verdicts

A deal with no activity for six weeks may be waiting on a customer's budget cycle. So each flag says what is missing, not what should happen.

A flag that judgesAtlas Print has gone cold. Close it out.
What this agent writes insteadAtlas Print, 30,000, Proposal. No activity for 44 days.

Why it posts once

One message a week, to one channel, is a report people read. It never replies in threads or messages a rep in a chat.

These are written into CRM hygiene report's instructions. They guide the agent, but they are not a permission. What it is allowed to touch is set by the access you grant.

CRM hygiene report reads Salesforce and shows where the records are thin. Every fix stays with the record's owner.

What CRM hygiene report does

CRM hygiene report is an AI agent that reads your open Salesforce opportunities every Monday and posts the records with gaps to a Microsoft Teams channel, grouped by owner, so each person can tidy their own.

Every forecast and pipeline report rests on fields that people fill in by hand. A close date that passed in September, a deal with no amount, a next step left blank: each one makes the report a little less true, and nobody notices until a quarter ends.

Asking reps to tidy up in general does not work. Showing each rep their own list does.

CRM hygiene report checks every open deal against the same four gaps, adds a count of contacts with no email, and posts one message grouped by owner. Each deal comes with its reasons and a link, so fixing it takes a minute.

In practice, each Monday morning you get:

  • Open deals whose close date has already passed
  • Deals with no amount or no next step
  • Deals with no activity in 30 days
  • A count of recent contacts with no email, by owner

How it works

CRM hygiene report works in four steps each Monday: it finds the channel, reads the open deals and contacts, flags the gaps and posts one message by owner. All of it comes from the agent's written instructions, which you can read and edit after you install it.

  1. Step 1: Read open deals

    It queries every open opportunity with close date, amount, next step and activity.

  2. Step 2: Read contacts

    It counts recent contacts with no email address, by owner.

  3. Step 3: Flag the gaps

    It marks each deal with every reason that applies and ranks them.

  4. Step 4: Post by owner

    It posts one message to your Teams channel, grouped by owner.

Drawn from this agent's own tools and instructions. It is not a recording of a run.

It reads Salesforce with a few queries

It uses soql_query for open opportunities and for contacts created in the last 90 days with no email. Large orgs are paged with LIMIT and OFFSET. A field your org lacks is checked with describe_object and dropped.

It uses your threshold

Quiet means no logged activity in 30 days unless you choose another number. Any default it used is named in the post.

It posts once, to one channel

It finds the team and channel with list_joined_teams and list_channels, then posts one message with post_channel_message. It never replies in threads or messages anyone in a chat.

It reports and stops

It never fills in a missing field or moves a close date. The owner knows the right value. The limits are under what it will never do.

What a Monday report looks like

A message from CRM hygiene report is one Teams post, grouped by owner, with each owner's deals ranked by the number of gaps and then by amount.

Sales · Pipeline

CRM hygiene reportAPP9:00 AM

Week of 26 October. 212 open deals and 340 recent contacts read. Quiet means 30 days, the default.

Lena Fischer (3 deals, 4 contacts)

  • Kestrel Mining, 85,000, Negotiation. Close date 30 September, 28 days ago. No next step.
  • Lumen Dental, Discovery. No amount. No activity for 37 days.
  • Brightwater Hotels, 12,000, Proposal. No next step.

Omar Siddiqui (1 deal, 2 contacts)

  • Atlas Print, 30,000, Proposal. No activity for 44 days.

The rest

6 more owners with one gap each, listed at the end of the message. 181 open deals had no gap.

One message, posted on Monday at 9:00 AM. The companies, people and amounts are made up.
Several gaps

Deals with two or more gaps, or a close date that has passed. These distort the forecast most.

One gap

Deals with a single missing field or a quiet spell, with the reason, so the owner can fix it in a minute.

The rest

How many records were read and how many were complete, so the report is never mistaken for the whole pipeline.

When everything is tidy

If no record has a gap, CRM hygiene report posts one line saying so and how many it checked.

A failed run is different. If Salesforce cannot be read, it posts that once. If the contact check fails, it posts the deal report and says the contact check was skipped.

Who uses CRM hygiene report

CRM hygiene report suits sales teams that run their pipeline in Salesforce and talk in Microsoft Teams. The examples use made-up names.

A sales operations manager

Grace Liu spends Friday chasing missing fields before the forecast call. Now each rep sees their own list on Monday.

In their reportNeeds youKestrel Mining, 85,000. Close date 30 September, 28 days ago.

A rep who forgets the admin

Omar Siddiqui updates deals after calls when he remembers. His section tells him which ones he missed.

In their reportWorth knowingAtlas Print, 30,000. No activity for 44 days.

A sales director before the forecast

Ruth Adeyemi wants the forecast to mean something. Close dates in the past are the first thing she asks about.

In their reportNeeds you9 deals past their close date, 3 of them over 50,000.

A marketing lead using contact data

Pablo Ruiz needs emails on contacts for campaigns. The count per owner shows where the gaps come from.

In their reportEverything else12 recent contacts with no email.

What CRM hygiene report connects to

CRM hygiene report connects to two tools: it reads Salesforce and posts to Microsoft Teams. You connect each one yourself, and Toolspoke stores the connection encrypted, so the agent never sees the credential.

  • Salesforce

    Required

    Query records with SOQL, read and update any object through the REST API.

    Authentication: Sign in with Salesforce

    View integration for Salesforce

  • Microsoft Teams

    Required

    Read Teams channels and chats, follow threads, and post messages and replies.

    Authentication: Sign in with Microsoft

    View integration for Microsoft Teams

What CRM hygiene report does and cannot do in each connected tool
ToolWhat CRM hygiene report doesWhat it cannot do
SalesforceReads open opportunities and contacts with soql_query, and checks fields with describe_object.Delete a record: the connector has no delete action. It can create and update records, which this agent's instructions forbid.
Microsoft TeamsFinds your team and channel (list_joined_teams, list_channels) and posts one message with post_channel_message.Delete or edit a message: the connector has neither action. It can reply in threads and send chat messages, which this agent is told never to do.

The Salesforce connection can create and update records. CRM hygiene report is told never to. That is an instruction, not a lock. To enforce it, switch create_record and update_record off in your project, or connect a Salesforce user that can only read. The access control guide explains how.

Teams classes every message it sends as destructive, because a post cannot be recalled. This agent needs post_channel_message, so allow that one action by name and leave reply_to_message and send_chat_message off.

When CRM hygiene report runs

CRM hygiene report runs on Mondays at 9am, but only after you switch its schedule on. It arrives switched off, so nothing runs and nothing is charged until you decide.

  • Each run reads every open opportunity and the last 90 days of contacts.
  • When nothing is flagged, it posts one line.
  • Any default it used is named in the post.
  • If Salesforce cannot be read, it posts that once.

Each run uses model credit from your workspace balance, so it makes one run a week. The Salesforce and Teams calls themselves are free.

Your copy is an ordinary agent in your project. You can pause its schedule there, run it once on demand, change the day and time and edit its instructions. The agent's page lists recent runs and their cost.

How to set up CRM hygiene report

To see the gaps each Monday, add CRM hygiene report to a Toolspoke project, connect Salesforce and Teams, choose the channel and switch on the schedule. Nothing runs until the last step.

  1. Step 1: Create a Toolspoke account or sign in

    Choose Use this agent. If you are new, you will be asked to sign up first, and you come straight back to this agent afterwards.

  2. Step 2: Add it to a project

    Pick the project it should live in. You get your own editable copy, and you can see the two tools it brings before anything connects.

  3. Step 3: Connect Salesforce

    Sign in with a Salesforce user that can read opportunities and contacts. A read-only user is the safest choice.

  4. Step 4: Connect Microsoft Teams

    Choose Sign in with Microsoft, using an account that is a member of the team the report should go to.

  5. Step 5: Limit what it can send

    In the project's access settings, allow post_channel_message by name for this agent and leave the other Teams send actions off.

  6. Step 6: Choose the channel and threshold

    Name the team and channel, and the days without activity that count as quiet. Leave the number out to use 30.

  7. Step 7: Switch on the schedule

    The schedule arrives switched off. Run it once to see a report, then switch it on.

Make CRM hygiene report fit your pipeline

CRM hygiene report's instructions are plain English and you can edit them after you install it. Installing copies the agent, so your edits stay with your copy. Open the agent in Toolspoke and tell the builder what to change, and it rewrites the instructions.

Paste any sentence below into the builder chat, or say the same thing in your own words.

Change what counts as quiet
Treat a deal as quiet after 14 days without activity.
Check your own fields
Also flag open deals where the custom field Decision_Maker__c is empty.
Only late stages
Only check deals in Proposal or Negotiation.
Leave out a team
Leave out deals owned by the partner team.
Run before the forecast
Run on Thursdays at 4pm.

This changes when the agent wakes up, so the builder edits its schedule, not the instructions.

None of these edits needs more access or touches the Never rules. They change what CRM hygiene report is told, not what the connections allow.

How it compares to other options

CRM hygiene report beats the alternatives when you want every owner shown their own gaps each week, in the place the team already talks. It loses to them when you want fields enforced at the moment a record is saved.

CRM hygiene report compared with Salesforce validation rules, A Salesforce report, A manual audit
Compared onCRM hygiene reportSalesforce validation rulesA Salesforce reportA manual audit
Checks every open dealYesOnly on saveYesA sample
Catches close dates that passedYesNoYesYes
Arrives in Teams by ownerYesNoBy email subscriptionIf someone posts it
Changes Salesforce recordsTold not toBlocks savesNoUp to the auditor
Rules you can read and changePlain EnglishFormula syntaxReport filtersWhatever is checked
Setup effortConnect two accountsAn admin per ruleBuild the reportHours each quarter

Validation rules are the better choice for a field that must never be empty, such as an amount at a late stage. They stop the gap at the source, though they cannot catch a close date that simply passed.

A Salesforce report is better when the list should stay inside Salesforce and update live. CRM hygiene report suits a team that wants the list put in front of each owner once a week.

Frequently asked questions

Can CRM hygiene report fix records in Salesforce?

The Salesforce connection can create and update records, and the agent is told never to. To enforce it, switch create_record and update_record off in your project, or connect a read-only user (how access works).

Why does it need a destructive action in Teams?

Teams classes every message it sends as destructive, because a post cannot be recalled. Allow post_channel_message by name and leave the reply and chat actions off.

Does it message reps directly?

No. It posts one message to one channel, grouped by owner. It is told never to send a chat message or reply in a thread.

Which records does it check?

Every open opportunity, and contacts created in the last 90 days. You can leave out record types or owners at install.

Can it check my own custom fields?

Yes. Tell the builder which field should never be empty, and it adds that to the checks.

Does it work with Slack instead?

This agent posts to Teams. Deal risk radar reads Salesforce and posts to Slack, and you can ask the builder to move this one to Slack after you install it.

Is CRM hygiene report free?

It has no price of its own, and every Toolspoke plan includes agents. Tool calls cost nothing, but each run draws on your usage balance. Pricing has the details.

Keep the pipeline honest, one owner at a time

Connect Salesforce and Teams, choose the channel and switch on the schedule. Your first report lands at 9am on Monday.