{"product_id":"salesforce-opportunity-deal-desk-automation-with-n8n-sheets-gemini","title":"Salesforce Opportunity Deal Desk Automation with n8n, Sheets \u0026 Gemini","description":"\u003ch3\u003eAuto-generate competitive strategy for every Salesforce opportunity—using n8n, Google Sheets, and Google Gemini\u003c\/h3\u003e\n\u003cp\u003eWhen a Salesforce opportunity is created or updated, this n8n workflow automatically pulls relevant historical win\/loss context and competitor intel, runs an AI-driven competitive analysis with Google Gemini, calculates a competitive risk score, updates the opportunity in Salesforce, and emails the sales team via Gmail.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eTriggers on change in Salesforce:\u003c\/strong\u003e Starts when a Salesforce opportunity is created or updated, then processes each opportunity in turn.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eConditional execution:\u003c\/strong\u003e Loads full opportunity details and continues only if a \u003cem\u003eprimary competitor\u003c\/em\u003e is set and the opportunity is not already marked as \u003cstrong\u003e“Analysis Complete”\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePulls history + competitor intel:\u003c\/strong\u003e Queries Salesforce for the account’s last \u003cstrong\u003e10 opportunities\u003c\/strong\u003e, then retrieves matching competitor intelligence from a Google Sheets \u003cstrong\u003e“Competitive Intelligence Database”\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eBuilds an AI input payload:\u003c\/strong\u003e Summarizes win\/loss history and compiles current deal details + competitor intel into a single payload.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGenerates counter-strategy with Google Gemini:\u003c\/strong\u003e Produces competitive factors, an actionable counter-strategy, and next-step guidance.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCalculates a competitive risk score:\u003c\/strong\u003e Scores the deal using deal size, sales stage, competitor name, and prior win\/loss signals—then formats strategy notes and status.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWrites back to Salesforce + notifies:\u003c\/strong\u003e Updates the opportunity’s competitive strategy and intelligence status fields and sends a Gmail notification to the sales team.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eSales teams want consistent, AI-assisted competitive positioning across every inbound and updated Salesforce deal.\u003c\/li\u003e\n  \u003cli\u003eRevOps and SaaS operators need automated win\/loss context review tied directly to opportunity records.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers want a practical n8n example combining Salesforce data, Google Sheets intelligence, and Gemini-generated playbooks.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations:\u003c\/strong\u003e Salesforce, Google Sheets, Google Gemini, Gmail\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes used:\u003c\/strong\u003e if, set, code, wait, gmail, merge\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCore data sources:\u003c\/strong\u003e Account opportunity history (last 10) + competitor intel from the Google Sheets “Competitive Intelligence Database”\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45824219709619,"sku":"N8N-18141","price":72.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/ZRRPiafjeDD3V4lhZT_H__vExtf8KQ.png?v=1786612948","url":"https:\/\/buyflowscripts.com\/products\/salesforce-opportunity-deal-desk-automation-with-n8n-sheets-gemini","provider":"N8N Commerce","version":"1.0","type":"link"}