Salesforce Opportunity Deal Desk Automation with n8n, Sheets & Gemini

Auto-generate competitive strategy for every Salesforce opportunity—using n8n, Google Sheets, and Google Gemini

When 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.

What this workflow does

• Triggers on change in Salesforce: Starts when a Salesforce opportunity is created or updated, then processes each opportunity in turn.
• Conditional execution: Loads full opportunity details and continues only if a primary competitor is set and the opportunity is not already marked as “Analysis Complete”.
• Pulls history + competitor intel: Queries Salesforce for the account’s last 10 opportunities, then retrieves matching competitor intelligence from a Google Sheets “Competitive Intelligence Database”.
• Builds an AI input payload: Summarizes win/loss history and compiles current deal details + competitor intel into a single payload.
• Generates counter-strategy with Google Gemini: Produces competitive factors, an actionable counter-strategy, and next-step guidance.
• Calculates a competitive risk score: Scores the deal using deal size, sales stage, competitor name, and prior win/loss signals—then formats strategy notes and status.
• Writes back to Salesforce + notifies: Updates the opportunity’s competitive strategy and intelligence status fields and sends a Gmail notification to the sales team.

Use cases

• Sales teams want consistent, AI-assisted competitive positioning across every inbound and updated Salesforce deal.
• RevOps and SaaS operators need automated win/loss context review tied directly to opportunity records.
• Automation engineers want a practical n8n example combining Salesforce data, Google Sheets intelligence, and Gemini-generated playbooks.

Technical details

• Integrations: Salesforce, Google Sheets, Google Gemini, Gmail
• n8n nodes used: if, set, code, wait, gmail, merge
• Core data sources: Account opportunity history (last 10) + competitor intel from the Google Sheets “Competitive Intelligence Database”