Stale Deal Follow-Ups
Daily agent finds stalled Salesforce deals and sends personalized emails, SMS, Slack alerts, and tasks to owners.
What it does
You get daily personalized follow-ups for stalled deals automatically sent as emails, SMS, Slack alerts, and owner tasks without any manual effort. This keeps your sales pipeline moving by proactively identifying opportunities that have gone stale and ensuring every deal receives timely attention.
Step by step
- Configure a daily cron trigger in n8n to initiate the workflow at a consistent time.
- Set up a Salesforce node with SOQL queries filtering opportunities by stage and last activity date against the stale threshold.
- Define SMTP credentials and Slack webhook URLs as environment variables for secure transmission.
Where the LLM does the work
- Prompt the OpenAI model to draft personalized email bodies based on specific deal history and recent sales notes.
- Instruct the LLM to summarize key blockers into concise Slack alerts tailored for different stakeholder roles.
- Generate structured JSON payloads for Salesforce tasks that include suggested next steps derived from the conversation context.
Watch out for
Salesforce API limits can block bulk updates, so implement batch processing with delays between chunks of records.
Email delivery failures due to spam filters can hurt reputation, so ensure the SMTP sender domain has proper SPF and DKIM records configured.
Stale thresholds might exclude recently active but stalled deals, so review the SOQL date logic weekly to adjust for changing sales cycles.
Tools that fit
SMTP Service Sending client emails
The agent brief
Everything your agent needs, including the gotchas. Copy it and go.
You are helping me build the following AI agent workflow. ## Goal Stale Deal Follow-Ups: Daily agent finds stalled Salesforce deals and sends personalized emails, SMS, Slack alerts, and tasks to owners. ## Specification - What it does: You get daily personalized follow-ups for stalled deals automatically sent as emails, SMS, Slack alerts, and owner tasks without any manual effort. This keeps your sales pipeline moving by proactively identifying opportunities that have gone stale and ensuring every deal receives timely attention. - Trigger: On a schedule (Scheduled · daily 8:00) - Autonomy: Fully hands-off - Expected setup effort: under an hour - Tools/services involved: - n8n: Workflow orchestration and JSON parsing - Salesforce: Querying opportunities and creating tasks - OpenAI: Generating personalized follow-up content - Slack: Notifying the sales team - SMTP: Sending client emails ## Known pitfalls, handle each one explicitly in your implementation 1. Salesforce API limits can block bulk updates, so implement batch processing with delays between chunks of records. 2. Email delivery failures due to spam filters can hurt reputation, so ensure the SMTP sender domain has proper SPF and DKIM records configured. 3. Stale thresholds might exclude recently active but stalled deals, so review the SOQL date logic weekly to adjust for changing sales cycles. ## Reference implementation https://n8n.io/workflows/11157 (workflow template) Fetch and inspect this before building. If it matches my stack, adapt it; if not, rebuild the pattern with my tools. ## Process requirements 1. Before building: ask me which of the listed tools I actually use and what my platform is (n8n / Make / code / other). Do not assume. 2. Adapt the pattern to my answers; do not force the reference stack. 3. Address every pitfall above; tell me how you handled each. 4. Provide a test plan I can run before letting this touch real data. 5. Ask before any step that sends messages, modifies data, or spends money. Source: https://usecasesforagents.com/use-case/automate-stale-deal-follow-ups/ via usecasesforagents.com
Frequently asked questions
Can I use a different Automation Platform than n8n?
Yes. n8n is only the example automation platform in this recipe. The same flow works with Home Assistant. Swap the automation platform connection and keep the rest of the setup as written.
Want this running in your business?
This is what I do. I design and build AI agents like this one, and keep them running. If you want it set up for your team instead of doing it yourself, get in touch.
Who it's for
Built for founders and execs who need sales handled without hiring for it.
Sales teams can plug this into their own CRM and call cadence just as easily.