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.
- 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
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.
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.
Step 1: Read open deals
It queries every open opportunity with close date, amount, next step and activity.
Step 2: Read contacts
It counts recent contacts with no email address, by owner.
Step 3: Flag the gaps
It marks each deal with every reason that applies and ranks them.
Step 4: Post by owner
It posts one message to your Teams channel, grouped by owner.
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
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.
- 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.
A rep who forgets the admin
Omar Siddiqui updates deals after calls when he remembers. His section tells him which ones he missed.
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.
A marketing lead using contact data
Pablo Ruiz needs emails on contacts for campaigns. The count per owner shows where the gaps come from.
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
RequiredQuery records with SOQL, read and update any object through the REST API.
Authentication: Sign in with Salesforce
Microsoft Teams
RequiredRead Teams channels and chats, follow threads, and post messages and replies.
Authentication: Sign in with Microsoft
| Tool | What CRM hygiene report does | What it cannot do |
|---|---|---|
| Salesforce | Reads 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 Teams | Finds 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.
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.
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.
Step 3: Connect Salesforce
Sign in with a Salesforce user that can read opportunities and contacts. A read-only user is the safest choice.
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.
Step 5: Limit what it can send
In the project's access settings, allow
post_channel_messageby name for this agent and leave the other Teams send actions off.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.
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.
Treat a deal as quiet after 14 days without activity.
Also flag open deals where the custom field Decision_Maker__c is empty.
Only check deals in Proposal or Negotiation.
Leave out deals owned by the partner team.
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.
| Compared on | CRM hygiene report | Salesforce validation rules | A Salesforce report | A manual audit |
|---|---|---|---|---|
| Checks every open deal | Yes | Only on save | Yes | A sample |
| Catches close dates that passed | Yes | No | Yes | Yes |
| Arrives in Teams by owner | Yes | No | By email subscription | If someone posts it |
| Changes Salesforce records | Told not to | Blocks saves | No | Up to the auditor |
| Rules you can read and change | Plain English | Formula syntax | Report filters | Whatever is checked |
| Setup effort | Connect two accounts | An admin per rule | Build the report | Hours 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.