Identify enterprise white space opportunities with Salesforce, Gemini and Gmail
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 19 nodes and runs on a schedule (cron 0 6 * * 1). Along the way it connects Salesforce, Google Sheets, Google Gemini Chat Model and Gmail. It also calls dummyjson.com over HTTP.
How it runs
Trigger: On a schedule (cron 0 6 * * 1).
- SF - Get Enterprise Accounts (Salesforce): get many (account)
- SplitInBatches (Loop Over Items (Split in Batches)): loops over the items in batches
- SF SOQL - Get Closed Won Products (Salesforce): work with search
- HTTP - ERP Product Catalog (HTTP Request): calls dummyjson.com
- Aggregate SF Products (Code): runs custom JavaScript code
- Google Sheets: uses Google Sheets
- Filter Fresh Accounts (Code): runs custom JavaScript code
- Wait: waits 10 seconds
- Basic LLM Chain: sends a prompt to an LLM, with model: Google Gemini Chat Model
- Parse JSON - LLM Response (Code): runs custom JavaScript code
…plus 7 more steps. See the full node list below.
Services it uses
HTTP calls to: dummyjson.com
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (13)
- Salesforce
n8n-nodes-base.salesforce - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - HTTP Request
n8n-nodes-base.httpRequest - Code
n8n-nodes-base.code - Google Sheets
n8n-nodes-base.googleSheets - Wait
n8n-nodes-base.wait - Basic LLM Chain
@n8n/n8n-nodes-langchain.chainLlm - Google Gemini Chat Model
@n8n/n8n-nodes-langchain.lmChatGoogleGemini - If
n8n-nodes-base.if - Gmail
n8n-nodes-base.gmail - Merge
n8n-nodes-base.merge - Edit Fields (Set)
n8n-nodes-base.set - Schedule Trigger
n8n-nodes-base.scheduleTrigger
From the author
Quick Overview This workflow runs weekly to find cross-sell white space in Salesforce enterprise accounts by comparing Closed Won products to an ERP product catalog, then uses Google Gemini to generate the top opportunities, creates a follow-up Salesforce…