Generate product-aware B2B leads and outreach emails with Gemini, Pinecone and Gmail

by Mushood Hanif · 212 views · created 2026-01-30 · Lead Generation, AI RAG

What this workflow does

This AI workflow has 59 nodes and runs manually, when you click “Execute workflow” (plus 3 other triggers). Along the way it connects Pinecone Vector Store, Google Drive, Google Sheets and Embeddings Google Gemini and 5 more. It also calls google.serper.dev over HTTP.

How it runs

Trigger: Manually, when you click “Execute workflow” (plus 3 other triggers).

1. Search files and folders (Google Drive): work with file folder
2. Lead Criteria Agent (AI Agent): runs an AI agent, with model: Gemini; 1 tool (KB - Lead Criteria); output parser: Parser
3. Get Companies (Postgres): select
4. Get Leads (Postgres): select
5. Loop Over Items (Loop Over Items (Split in Batches)): loops over the items in batches
6. Extract Queries (Code): runs custom JavaScript code
7. Loop Over Companies (Loop Over Items (Split in Batches)): loops over the items in batches
8. Loop Over Leads (Loop Over Items (Split in Batches)): loops over the items in batches
9. nonDownloadableFile (If): checks a condition and branches into true / false
10. Loop Over Queries (Loop Over Items (Split in Batches)): loops over the items in batches

…plus 29 more steps. See the full node list below.

Services it uses

Pinecone Vector StoreGoogle DriveGoogle SheetsEmbeddings Google GeminiGoogle Gemini Chat ModelPostgresHunterHTTP RequestGmail

HTTP calls to: google.serper.dev

Before you upgrade to n8n 3.0

Nodes used (22)

• Pinecone Vector Store@n8n/n8n-nodes-langchain.vectorStorePinecone
• Default Data Loader@n8n/n8n-nodes-langchain.documentDefaultDataLoader
• Recursive Character Text Splitter@n8n/n8n-nodes-langchain.textSplitterRecursiveCharacterTextSplitter
• Google Driven8n-nodes-base.googleDrive
• Crypton8n-nodes-base.crypto
• Switchn8n-nodes-base.switch
• Loop Over Items (Split in Batches)n8n-nodes-base.splitInBatches
• Google Sheetsn8n-nodes-base.googleSheets
• Ifn8n-nodes-base.if
• Embeddings Google Gemini@n8n/n8n-nodes-langchain.embeddingsGoogleGemini
• Manual Triggern8n-nodes-base.manualTrigger
• Schedule Triggern8n-nodes-base.scheduleTrigger
• Structured Output Parser@n8n/n8n-nodes-langchain.outputParserStructured
• AI Agent@n8n/n8n-nodes-langchain.agent
• Google Gemini Chat Model@n8n/n8n-nodes-langchain.lmChatGoogleGemini
• Coden8n-nodes-base.code
• HTTP Requestn8n-nodes-base.httpRequest
• Postgresn8n-nodes-base.postgres
• Huntern8n-nodes-base.hunter
• Waitn8n-nodes-base.wait
• Http Request Tooln8n-nodes-base.httpRequestTool
• Gmailn8n-nodes-base.gmail

From the author

How can you find your target market if you don't know what your product is. This simple philosophy changes the way we think about automated sales agents. Context changes everything. In this 4-part workflow, we start by creating a knowledge base that will act…

View the original on n8n.io → Check your own copy