Salesforce qualified lead alerts and daily digest for Slack
Build a workflow that keeps the sales team informed about CRM opportunities that have reached the "qualified" stage, delivering updates two ways into a team chat channel. Real-time pings. On a frequent schedule (every ~5 minutes via cron), query the CRM — I used Salesforce, but this could be any CRM — for opportunities currently in the qualified stage. Track which opportunities have already been seen using persistent state in a named volume, and only post the newly-arrived ones. For each new deal, post a richly-formatted card (account, owner, amount, close date, stage, next step, record link, etc.) to Slack — or whatever chat tool your team uses. On the very first run, seed the state silently so you don't flood the channel with the existing backlog. Daily digest. Once a day (via cron, with the step self-selecting the correct local send time so it stays right across daylight-saving changes), post a roll-up to the same channel: total deals in the qualified stage, how many are new since yesterday, and how many have moved on. Include a short list of the new arrivals. Diff against a separate daily snapshot stored in the same volume. Use a CRM connector for the querying steps and a chat connector for the posting steps — no secrets in code. Keep the "which stage counts as qualified" and "which channel" values easy to change. Note that cron only fires on the published version. Tools used: Salesforce (Salesforce REST API), Slack, 3B named volume for persistent state, cron triggers
What this prompt builds
This workflow monitors Salesforce for newly qualified leads and delivers visibility to the sales team through Slack. It posts real-time alerts within five minutes of a lead reaching qualified stage, storing state to avoid duplicates, and sends a daily digest summarizing total qualified leads, new arrivals, and stage changes. The workflow helps sales teams track pipeline progress and celebrate wins without constantly navigating Salesforce.
The problem
Sales teams using Salesforce often lack visibility into newly qualified leads because the CRM is large, overwhelming, and focused on individual user activity rather than team-wide pipeline health. This workflow solves that by automatically detecting when opportunities reach the qualified stage and broadcasting them to a Slack channel within five minutes, using persistent state to track what's already been shared. It also delivers a daily digest that rolls up total qualified leads, new arrivals since yesterday, and deals that have progressed, giving the team a birds-eye view of pipeline status without manual CRM checks.
Solution and impact
The workflow gives sales teams real-time awareness of qualified leads as they arrive, posting richly formatted cards with account details, owner, amount, close date, and next steps directly into Slack. The daily digest adds context by summarizing overall qualified lead counts and highlighting new opportunities, helping teams track progress, celebrate wins, and support each other. By surfacing CRM data automatically, it reduces time spent navigating Salesforce and ensures no qualified lead goes unnoticed.