{"product_id":"n8n-workflow-detect-salesforce-bottlenecks-with-gemini-slack-gmail","title":"n8n Workflow: Detect Salesforce Bottlenecks with Gemini, Slack \u0026 Gmail","description":"\u003ch3\u003eStop Salesforce deal momentum from stalling—automatically detect bottlenecks, escalate with AI, and notify the right teams\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow runs daily to scan open \u003cstrong\u003eSalesforce opportunities\u003c\/strong\u003e and their related tasks, identify overdue or high-priority dependencies, generate an AI-written escalation summary with \u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e, and alert stakeholders via \u003cstrong\u003eSlack\u003c\/strong\u003e and \u003cstrong\u003eGmail\u003c\/strong\u003e—while updating the opportunity and logging the incident in \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns every day at 9:00\u003c\/strong\u003e to start a bottleneck check.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRetrieves open Salesforce opportunities and linked Salesforce tasks\u003c\/strong\u003e, then matches tasks to their related opportunities.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFlags bottlenecks\u003c\/strong\u003e when tasks are \u003cem\u003eoverdue\u003c\/em\u003e or \u003cem\u003ehigh priority\u003c\/em\u003e and still open.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDerives dependency context\u003c\/strong\u003e from the task subject (e.g., legal, proposal, technical, finance) and calculates a \u003cstrong\u003eseverity level\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eFor each bottleneck, sends opportunity + task context to \u003cstrong\u003eGoogle Gemini\u003c\/strong\u003e to produce a \u003cstrong\u003eJSON summary\u003c\/strong\u003e including escalation reason, recommended next action, owner team, and severity.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNotifies stakeholders\u003c\/strong\u003e:\n    \u003cul\u003e\n      \u003cli\u003ePosts a formatted bottleneck alert to a selected \u003cstrong\u003eSlack channel\u003c\/strong\u003e.\u003c\/li\u003e\n      \u003cli\u003eSends a plain-text escalation email via \u003cstrong\u003eGmail\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUpdates Salesforce\u003c\/strong\u003e: writes bottleneck details to the opportunity \u003cstrong\u003eNext Step\u003c\/strong\u003e field.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLogs activity\u003c\/strong\u003e by appending an audit row to \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eEnsure internal dependencies (legal, finance, technical reviews) don’t silently block deal progress.\u003c\/li\u003e\n  \u003cli\u003eGet daily, actionable escalation messages when Salesforce tasks become overdue or remain high priority.\u003c\/li\u003e\n  \u003cli\u003eStandardize handoffs by automatically generating severity-ranked escalation summaries with Gemini.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations\/credentials\u003c\/strong\u003e: Salesforce (query Opportunities\/Tasks + update Opportunities), Google Gemini (chat model for JSON summaries), Slack OAuth2 (post alerts), Gmail (send escalation emails), Google Sheets (audit log).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWorkflow nodes mentioned\u003c\/strong\u003e: if, set, code, no op, gmail, merge.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003cp\u003e\u003cstrong\u003eCategory:\u003c\/strong\u003e n8n automation workflow • \u003cstrong\u003eStack focus:\u003c\/strong\u003e Salesforce + Gemini + Slack + Gmail for automated bottleneck detection and escalation.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45850779549875,"sku":"N8N-18111","price":62.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/xQCGXGixqdDklOoxZ9e4g_vhp16p2T.png?v=1786871696","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-detect-salesforce-bottlenecks-with-gemini-slack-gmail","provider":"N8N Commerce","version":"1.0","type":"link"}