Compare proposals and analyze gaps for Salesforce CRM with Groq AI

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](https://n8n.partnerlinks.io/om1efg2qgvwi). - 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