Salesforce White Space Finder with Gemini & Gmail | n8n

Find Salesforce “White Space” Weekly—Powered by Gemini & Gmail (n8n)

This n8n workflow automatically scans Salesforce enterprise accounts every Monday, identifies product gaps (“white space”) by comparing Closed Won offerings to your ERP catalog, then uses Google Gemini to generate the top expansion opportunities and sends a follow-up email via Gmail—with results logged to Google Sheets.

What this workflow does

• Runs on a schedule: Executes every Monday at 06:00 using an n8n schedule trigger.
• Targets the right accounts: Pulls Salesforce Accounts where AnnualRevenue > 100,000, processing them in batches.
• Builds the product coverage view: For each account, queries Salesforce Closed Won Opportunity Line Items and fetches the full ERP product catalog over HTTP.
• Calculates white space: Determines which catalog items are not yet purchased and creates an account context summary.
• Prevents duplicate outreach: Checks a Google Sheets “memory” tab to skip accounts already processed within the current ISO week.
• Uses Google Gemini for recommendations: Sends the context + white space list to Gemini, expecting a JSON response with the top 3 expansion opportunities, a suggested Salesforce Task, and an HTML email.
• Acts on the AI output: If parsing succeeds, creates a Salesforce Task, emails the account owner via Gmail, and appends the outcome to Google Sheets. If parsing fails, it logs the parse error and continues.

Use cases

• RevOps teams seeking cross-sell opportunity detection across Salesforce enterprise accounts.
• SaaS operators automating weekly outbound research based on Closed Won product history.
• Automation engineers building an AI-assisted Salesforce workflow with controlled memory to avoid repeat emails.

Technical details

• n8n nodes/tools: Schedule trigger, if, set, code, wait, gmail, and merge.
• Integrations: Salesforce (OAuth + Closed Won Opportunity Line Items with Product2.Name), Google Gemini (JSON generation), Gmail (HTML email), Google Sheets (ISO-week memory + logging), ERP catalog via HTTP endpoint.
• Setup requirement: Replace the template ERP catalog HTTP endpoint (demo uses dummyjson.com) with your real ERP product catalog URL.