How it works - Runs every morning at 8:00 using the Schedule Trigger. - Sets a staledays value and queries Salesforce for Opportunities where StageUnchangedDaysc equals that value and the stage is not Closed Won / Closed Lost. - For each “stale” Opportunity, loads full deal details and sends them to an OpenAI model. - The model uses the querysoql tool to pull recent Notes, the primary Contact, and the Opportunity Owner, then returns a single JSON object with: - a persona

How it works - Runs every morning at 8:00 using the Schedule Trigger. - Sets a staledays value and queries Salesforce for Opportunities where StageUnchangedDaysc equals that value and the stage is not Closed Won / Closed Lost. - For each “stale” Opportunity, loads full deal details and sends them to an OpenAI model. - The model uses the querysoql tool to pull recent Notes, the primary Contact, and the Opportunity Owner, then returns a single JSON object with: - a personalized follow-up email for the client, - a short SMS template, - a concise Slack summary for the sales team, - and a ready-to-use Task payload for Salesforce. - n8n parses that JSON, sends the email via SMTP, posts the Slack message to your chosen channel, and creates a Salesforce Task assigned to the Opportunity Owner so every stalled deal has a clear next step. Setup steps Estimated setup time: 30–45 minutes if your Salesforce, OpenAI, SMTP and Slack credentials are ready. 1. Create StageUnchangedDaysc on Opportunity (Salesforce) - Field Type: Formula (Number, 0 decimal places) - Formula: - This field tracks how many days the Opportunity has been in the current stage. 2. Connect credentials in n8n - Salesforce OAuth2 for the Salesforce nodes and the querysoql HTTP Tool. - OpenAI (or compatible) credential for the “Message a model” node. - SMTP credential for the customer email node. - Slack credential for the internal notification node. 3. Configure your follow-up rules - In Edit Fields (Set), set staledays to the threshold that defines a stalled deal (e.g. 7, 14, 30). - In Perform a query, optionally refine the SOQL (record types, owners, minimum amount, etc.) to match your pipeline. - Update the Send Email SMTP Customer node with your real “from” address and tweak the wording if needed. - Point Send Message To Internal Team (Slack) to the right channel or user. 4. Test safely - Turn off the Schedule Trigger and run the workflow manually with a few test Opportunities. - Inspect the AI output in Message a model and Parse JSON to confirm the structure (email, sms, slack, task.apibody). - Check that the email and Slack messages look good and that Salesforce Tasks are created, assigned to the right Owner, and linked to the correct Opportunity. 5. Go live - Re-enable the Schedule Trigger. - Monitor the first few days to confirm that follow-ups, Slack alerts, and Tasks all behave as expected, then let the automation quietly keep your pipeline clean and moving.
Download the workflow JSON file after purchase.
Open n8n → click the menu → Import from File.
Select the downloaded JSON and import.
Set up credentials for each node that requires them.
Click Execute Workflow to test, then activate.
Setup guide included
Purchase to unlock the full step-by-step guide
No reviews yet
Be the first to buy and share your experience.
Leave a review
Sign in to share your experience with this workflow.
Create a free account to purchase workflows.
Need help setting this up?
Book a 3-hour live setup session with an Agility consultant.