{"product_id":"salesforce-white-space-finder-with-gemini-gmail-n8n","title":"Salesforce White Space Finder with Gemini \u0026 Gmail | n8n","description":"\u003ch3\u003eFind Salesforce “White Space” Weekly—Powered by Gemini \u0026amp; Gmail (n8n)\u003c\/h3\u003e\n\u003cp\u003eThis 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.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns on a schedule:\u003c\/strong\u003e Executes every Monday at 06:00 using an n8n schedule trigger.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eTargets the right accounts:\u003c\/strong\u003e Pulls Salesforce Accounts where \u003cem\u003eAnnualRevenue \u0026gt; 100,000\u003c\/em\u003e, processing them in batches.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eBuilds the product coverage view:\u003c\/strong\u003e For each account, queries Salesforce \u003cem\u003eClosed Won Opportunity Line Items\u003c\/em\u003e and fetches the full ERP product catalog over HTTP.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCalculates white space:\u003c\/strong\u003e Determines which catalog items are not yet purchased and creates an account context summary.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePrevents duplicate outreach:\u003c\/strong\u003e Checks a Google Sheets “memory” tab to skip accounts already processed within the current ISO week.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUses Google Gemini for recommendations:\u003c\/strong\u003e Sends the context + white space list to Gemini, expecting a JSON response with the \u003cstrong\u003etop 3 expansion opportunities\u003c\/strong\u003e, a suggested Salesforce Task, and an \u003cstrong\u003eHTML email\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eActs on the AI output:\u003c\/strong\u003e 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.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eRevOps teams seeking \u003cstrong\u003ecross-sell opportunity detection\u003c\/strong\u003e across Salesforce enterprise accounts.\u003c\/li\u003e\n  \u003cli\u003eSaaS operators automating weekly outbound research based on \u003cstrong\u003eClosed Won\u003c\/strong\u003e product history.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers building an \u003cstrong\u003eAI-assisted Salesforce workflow\u003c\/strong\u003e with controlled memory to avoid repeat emails.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes\/tools:\u003c\/strong\u003e Schedule trigger, \u003cstrong\u003eif\u003c\/strong\u003e, \u003cstrong\u003eset\u003c\/strong\u003e, \u003cstrong\u003ecode\u003c\/strong\u003e, \u003cstrong\u003ewait\u003c\/strong\u003e, \u003cstrong\u003egmail\u003c\/strong\u003e, and \u003cstrong\u003emerge\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations:\u003c\/strong\u003e Salesforce (OAuth + Closed Won Opportunity Line Items with \u003cem\u003eProduct2.Name\u003c\/em\u003e), Google Gemini (JSON generation), Gmail (HTML email), Google Sheets (ISO-week memory + logging), ERP catalog via \u003cstrong\u003eHTTP endpoint\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSetup requirement:\u003c\/strong\u003e Replace the template ERP catalog HTTP endpoint (demo uses \u003cem\u003edummyjson.com\u003c\/em\u003e) with your real ERP product catalog URL.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45850764214451,"sku":"N8N-18113","price":5.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/x4yoqPhQ29VyNhIuE0LEC_cUM5SLre.png?v=1786871652","url":"https:\/\/buyflowscripts.com\/products\/salesforce-white-space-finder-with-gemini-gmail-n8n","provider":"N8N Commerce","version":"1.0","type":"link"}