G
GTM Vault
Browse
  • Dashboard
    • Automations
    • Skills
    • Prompts
    • Makers
  • Sign in
All Automations

AI-powered lead research & personalized email generation with Groq & Google Sheets

Automatically researches leads using AI, enriches data with pain points, and generates personalized email drafts in Google Sheets.

workflowlead_generation
ainablerby ainableron n8n
Nodes

22

Triggers

1

Platform

n8n

Tech Stack
Tavily
Tavily
AI Agent
Groq
Groq
Google Sheets
Google Sheets
How It Works

This workflow transforms raw lead data into personalized outreach emails by conducting AI-powered research on each prospect. It fetches leads from Google Sheets, uses Tavily to gather company intelligence, identifies pain points with AI analysis, and generates tailored email drafts that sales teams can review and send.

1

Fetch lead data from Google Sheets

Retrieves new lead information including company name, contact details, and basic data from your Google Sheets database.

2

Research company with Tavily search

Uses Tavily API to gather comprehensive information about the target company including recent news, business challenges, and market position.

3

Analyze pain points with AI Agent

AI Agent processes the research data to identify specific pain points and challenges the prospect company is facing.

4

Generate personalized email with Groq

Groq AI creates a customized introductory email that addresses the identified pain points and positions your solution as relevant.

Attached Files
workflow.json
5

Save draft back to Google Sheets

Updates the original spreadsheet with the research findings, pain points analysis, and the generated email draft for review.

What You'll Need

Tavily ToolGroqGoogle Sheets
  • Google Sheets account with lead data
  • Tavily API key for web research
  • Groq API key for AI text generation
  • Google Sheets API access configured
  • Lead list with company names and contact information

This automation has 5 configurable settings you'll customize during setup.