Quick overview
Quick overview This workflow runs daily to scan open Salesforce opportunities and related tasks, detect overdue or high-priority internal dependencies, generate an AI-written escalation summary with Google Gemini, and then notify stakeholders via Slack and Gmail while updating the opportunity and logging the incident to Google Sheets. How it works Runs every day at 9:00 to start a bottleneck check. Retrieves all open Salesforce opportunities and Salesforce tasks linked to records, then matches tasks to their related opportunities. Flags tasks as bottlenecks when they are overdue or high priority and still open, assigns a dependency type from the task subject (for example legal, proposal, technical, or finance), and calculates a severity level. For each detected bottleneck, sends the opportunity and task context to Google Gemini to produce a JSON summary, escalation reason, recommended next action, owner team, and severity. Sends a formatted bottleneck alert to a Slack channel and a plain-text escalation email via Gmail. Updates the Salesforce opportunity Next Step field with the bottleneck details and appends an audit row to a Google Sheets log. Setup Add Salesforce credentials with permission to query Opportunities and Tasks and to update Opportunities. Add Google Gemini credentials for the chat model used to generate bottleneck summaries. Add a Slack OAuth2 connection and select the channel where bottleneck alerts should be posted. Add a Gmail connection and configure the recipient(s) for escalation emails in the Gmail node. Add Google Sheets credentials and set the target spreadsheet and sheet tab used to append bottleneck audit rows. Additional info How To Customize Nodes Detection Logic (Code Node)** Modify conditions for bottlenecks (e.g., include medium priority or custom SLA rules) Dependency Classification** Update keyword matching logic to suit your business processes AI Prompt** Customize instructions to refine outputs (e.g., tone, structure, or additional fields) Slack Message Format** Adjust formatting or include/exclude fields based on team needs Salesforce Update Field** Modify which field is updated (currently "Next Step") Google Sheets Columns** Add/remove columns based on reporting requirements Add-ons & Enhancements Add Google Tasks for follow-up tracking Introduce retry logic for failed Slack/Gmail sends Add deduplication to avoid repeated alerts Include escalation workflows (e.g., manager alerts) Add dashboards using BI tools connected to Google Sheets Use Case Examples Detect overdue legal reviews blocking deal closure Identify high-priority proposal approvals not completed Track finance approvals delaying revenue recognition Alert teams about technical dependencies in late-stage deals Maintain an audit trail of all escalated bottlenecks There can be many more use cases depending on your internal processes. Troubleshooting Guide | Issue | Possible Cause | Solution | | ----------------------- | -------------------------------- | ----------------------------------------------- | | No data returned | Salesforce query issue | Verify SOQL queries and permissions | | AI output parsing fails | Invalid JSON from AI | Check prompt formatting and enforce strict JSON | | Slack message not sent | Incorrect credentials or channel | Reconnect Slack and verify channel ID | | Email not delivered | Gmail config issue | Check Gmail OAuth and recipient field | | Salesforce update fails | Field length limit | Ensure text is within 255 characters | | Missing bottlenecks | Logic too strict | Adjust detection conditions in Code node | Need Help? If you need assistance setting up this workflow, customizing it for your business or building advanced automation solutions, feel free to reach out. Contact WeblineIndia for: Workflow setup and deployment Custom AI automation solutions Salesforce and CRM integrations Advanced n8n workflow development We are happy to help you scale your automation journey. An n8n automation workflow template by WeblineIndia.
WeblineIndia
web
free
Others in the same category, ranked by how often they are opened.
