AI-powered lead research & personalized email generation with Groq & Google Sheets
UnknownUnknown. This template uses community nodes we can't verify statically. Uses community nodes that can't be verified statically (unverified community packages are off by default in 3.0). Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 18 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Groq Chat Model, Google Sheets and Tavily (community).
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Get row(s) in sheet (Google Sheets): uses Google Sheets
- If: checks a condition and branches into true / false
- Loop Over Items (Loop Over Items (Split in Batches)): loops over the items in batches
- Company Research (AI Agent): runs an AI agent, with model: Groq Chat Model; 1 tool (Search Internet)
- updateDescription (Google Sheets): update
- updateStatus (Google Sheets): update
- getTemplate (Google Sheets): uses Google Sheets
- getService (Google Sheets): uses Google Sheets
- AI Sales Assistant (AI Agent): runs an AI agent, with model: Groq Chat Model; 1 tool (Search Internet); output parser: Structured Output Parser
- draftEmail (Google Sheets): update
…plus 2 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
We can't fully verify this one: it relies on 1 community package, and n8n 3.0 turns unverified community packages off by default (N8N_UNVERIFIED_PACKAGES_ENABLED=false).
- Check that @tavily/n8n-nodes-tavily is verified or supports 3.0 (used in Search Internet1, Search Internet2).
Nodes used (9)
- If
n8n-nodes-base.if - Tavily Tool
@tavily/n8n-nodes-tavily.tavilyTool - AI Agent
@n8n/n8n-nodes-langchain.agent - Groq Chat Model
@n8n/n8n-nodes-langchain.lmChatGroq - Google Sheets
n8n-nodes-base.googleSheets - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - Manual Trigger
n8n-nodes-base.manualTrigger - Code
n8n-nodes-base.code - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches
From the author
Overall Description & Potential << What Does This Flow Do? >> Overall, this workflow is an intelligent sales outreach automation engine that transforms raw leads from a form or a list into highly personalized, ready-to-send introductory email…