Quick overview
Quick overview This workflow triggers on Salesforce opportunity creation or updates, pulls recent account opportunity history and competitor intel from Google Sheets, uses Google Gemini to generate competitive analysis and a counter-strategy, calculates a competitive risk score, updates the Salesforce opportunity with notes and status, and emails the results via Gmail. How it works Triggers when a Salesforce opportunity is created or updated, then processes each opportunity in turn. Loads the full opportunity details from Salesforce and continues only if a primary competitor is set and the opportunity has not already been marked as “Analysis Complete.” Queries Salesforce for the account’s last 10 opportunities and fetches matching competitor intelligence from a Google Sheets “Competitive Intelligence Database.” Summarizes the account’s win/loss history and compiles the current deal details, competitor intel, and historical context into a single AI input payload. Uses Google Gemini to analyze the current active deal’s competitive factors and generate an actionable counter-strategy and next-step plan. Calculates a competitive risk score based on deal size, sales stage, competitor name, and prior win/loss signals, then formats strategy notes and status. Updates the Salesforce opportunity’s competitive strategy and intelligence status fields and sends a Gmail notification email to the sales team. Setup Connect Salesforce credentials and ensure your Opportunity object has the custom fields Primary_Competitor__c, Competitive_Strategy_Notes__c, and Competitor_Intelligence_Status__c. Connect Google Sheets credentials and update the spreadsheet document ID, sheet name, and column mappings used to look up competitor intel by “Competitor Name.” Connect Google Gemini (API key/credentials) and confirm the selected model is available in your environment. Connect Gmail credentials and set the recipient(s) and any sender/permission requirements for sending notification emails. Adjust the risk-scoring rules (deal thresholds, sales stages, and competitor list) to match your sales process and competitive landscape. Additional info How To Customize Nodes AI Prompts Modify prompts in: Competitive Analysis (Current Deal) Counter Strategy Generator Customize tone, depth, or output format Google Sheets Mapping Add more columns (pricing, strengths, weaknesses) Update mapping in AI Input Payload Risk Logic Edit scoring logic in Competitive Risk Score node Add/remove conditions or adjust scoring weights Email Content Customize subject and message in Send Analysis Email Add-Ons (Enhancements) Slack or Microsoft Teams notifications Dashboard integration (Power BI / Tableau) Auto-create follow-up tasks in Salesforce Add win/loss prediction model Multi-competitor comparison logic Store analysis logs in database Use Case Examples Enterprise Deal Strategy Analyze million-dollar deals and prepare executive-level strategy Competitive Sales Enablement Equip reps with real-time talking points before meetings Account-Based Selling Use historical account insights to improve win probability Pipeline Risk Monitoring Identify high-risk deals early and escalate Sales Coaching Help junior reps with structured AI-generated guidance There can be many more use cases depending on your business needs. Troubleshooting Guide | Issue | Possible Cause | Solution | |------|---------------|----------| | Workflow not triggering | Salesforce trigger not configured | Check OAuth connection and trigger setup | | No analysis generated | Competitor field empty | Ensure Primary_Competitor__c is filled | | Workflow skips opportunity | Already marked as "Analysis Complete" | Reset field or modify IF condition | | Missing competitor data | Google Sheets mismatch | Ensure competitor name matches exactly | | Email not sent | Recipient not configured | Add email in Gmail node | | AI output empty | API or prompt issue | Verify Gemini API credentials and prompts | | Incorrect risk score | Logic mismatch | Review code node conditions | | Salesforce update fails | Missing custom fields | Create required fields in Salesforce | Need Help? If you need assistance with: Setting up this workflow in your environment Customizing AI prompts or risk scoring Extending with add-ons (Slack, dashboards, alerts) Building intelligent automation workflows Feel free to reach out to WeblineIndia, our n8n workflow developers can help you implement, customize and scale automation tailored to your business needs. An n8n automation workflow template by WeblineIndia.
WeblineIndia
web
free
Others in the same category, ranked by how often they are opened.
