AI Proposal Comparison & Gap Analysis Workflow for Salesforce CRM

This workflow automatically analyzes newly uploaded proposals by comparing them with past winning proposals using AI. It extracts proposal content, identifies the client, fetches reference data from Google Sheets and generates actionable insights. These insights are saved in Salesforce and shared on Slack for team visibility.

Quick Implementation Steps

• Connect Google Drive, Google Sheets, Salesforce, Slack and Groq AI credentials in your n8n account.
• Set your Google Drive folder to monitor proposal uploads.
• Ensure your Google Sheet contains winning proposals with status = Won.
• Activate the workflow.
• Upload a proposal file to trigger analysis automatically.

What It Does

This workflow automates the process of analyzing business proposals by leveraging AI and historical data. When a new proposal file is uploaded to a specific Google Drive folder, the workflow downloads and extracts its content. It then identifies the client name using a simple pattern from the text. At the same time, the workflow fetches past winning proposals from a Google Sheets database filtered by status. Both the current and past proposals are combined and sent to an AI model for comparison. The AI generates concise insights highlighting missing elements, weak positioning, pricing gaps and improvement suggestions. Finally, the insights are formatted and stored in Salesforce as an Opportunity record. A notification is sent to Slack, ensuring the team is informed and can act quickly to improve proposal quality.

Who It's For

• Sales teams managing multiple proposals
• Business development professionals
• Proposal review and strategy teams
• Organizations using Salesforce CRM
• Teams looking to improve win rates using AI

Requirements

• n8n account (self-hosted or cloud)
• Google Drive account (with folder for proposals)
• Google Sheets account (with winning proposals data)
• Salesforce account (Opportunity access enabled)
• Slack workspace (channel for notifications)
• Groq API credentials (for AI model access)

How It Works & Set Up

1. Setup Google Drive Trigger

• Configure New Proposal Upload Trigger
• Select the folder where proposals will be uploaded
• Event: fileCreated

2. Download and Extract Proposal

• Use Download Proposal node to fetch file
• Use Read Proposal Text node to extract content

3. Extract Client Information

• Use Extract Client Info (Code node)
• Extract clientName using regex from text
• Store full proposal as currentProposal

4. Fetch Winning Proposals

• Configure Get Winning Proposal Data (Knowledge Base)
• Connect Google Sheet
• Filter where status = Won

5. Combine Data

• Use Combine Proposal Data (Merge node)
• Combine current proposal and past proposal

6. AI Analysis

• Use AI Proposal Gap Analyzer
• Provide prompt to compare proposals
• Generate structured insights (8–10 bullet points)

7. Format Output

• Use Format Analysis Output
• Map clientName and analysisSummary

8. Save to Salesforce

• Use Save Insights to Salesforce
• Create Opportunity
• Add insights in description

9. Prepare Final Output

• Use Prepare Final Output (Merge node)

10. Add Delay (Optional Control)

• Use Wait for Save node (2 seconds delay)

11. Send Slack Notification

• Use Send Notification to Slack
• Send formatted message with insights

How To Customize Nodes

• Extract Client Info: Modify regex if proposal format changes
• Google Sheets Node: Change filter or add more columns
• AI Prompt: Customize output format or analysis depth
• Salesforce Node: Change stage, fields or object type
• Slack Node: Update message format or channel
• Wait Node: Adjust delay time if needed

Add-ons

• Add email notification (Gmail node)
• Store results in Google Sheets for history
• Add error handling with IF node
• Add multiple proposal comparison logic
• Integrate dashboard (Notion, Airtable, etc.)

Use Case Examples

• Improving proposal quality before client submission
• Training new sales team members using past wins
• Automating proposal review workflows
• Identifying common gaps in losing proposals
• Tracking proposal insights in CRM
  There can be many more use cases depending on how you extend this workflow.

Troubleshooting Guide

Need Help?

If you need assistance setting up this workflow, customizing nodes or adding advanced features, we’re here to help. Whether it's integrating additional tools, improving AI analysis or building custom automation workflows tailored to your business needs, feel free to reach out to our n8n developers at WeblineIndia. Get expert help to scale your automation and build powerful AI-driven workflows efficiently.