Automate outbound lead follow-up & qualification
How it works This workflow pulls pending leads from Google Sheets on a scheduled trigger and processes each record individually. For every lead, an AI agent generates a structured subject and HTML body based on predefined rules. A tracking ID is then created and injected into the outgoing email before sending via Gmail. Once sent, Gmail metadata is retrieved and forwarded to your tracking API to initiate a follow-up sequence, and the corresponding lead entry in Google Sheets is updated. Step-by-
At a glance
Automate outbound lead follow-up & qualification is a ready-made n8n workflow you import as a workflow JSON file — no build required. It connects Gmail, Google Sheets, OpenAI. It's free to download. Follow the 5-step import below to go live in minutes.
- Platform
- n8n
- Connects
- Gmail, Google Sheets, OpenAI
- Modules
- 11
- Price
- Free
- Version
- v1.0

About this workflow
How it works This workflow pulls pending leads from Google Sheets on a scheduled trigger and processes each record individually. For every lead, an AI agent generates a structured subject and HTML body based on predefined rules. A tracking ID is then created and injected into the outgoing email before sending via Gmail. Once sent, Gmail metadata is retrieved and forwarded to your tracking API to initiate a follow-up sequence, and the corresponding lead entry in Google Sheets is updated. Step-by-step - Lead intake - Schedule Trigger – Runs daily and initiates lead retrieval. - Get row(s) in sheet – Fetches only rows marked with “Pending”. - Loop Over Items – Iterates through each lead entry. - Email generation - AI Agent – Generates subject and HTML body using provided lead fields. - OpenAI Chat Model – Executes the LLM instructions powering the email creation. - Structured Output Parser – Validates that the AI returns compliant JSON. - Tracking setup - Generates Tracking ID – Calls your tracking API and receives a unique tracking identifier. - The tracking ID is embedded into the email through a tracking pixel. - Email dispatch - Send a message – Sends the personalized email from Gmail using the AI-generated subject and body. - Metadata retrieval - Fetches Email Data – Retrieves the sent email’s messageId, threadId, and related metadata. - Sequence initiation - Starts Sequence – Posts metadata and tracking ID to your tracking API to activate the automated follow-up sequence. - Lead status update - Append or update row in sheet – Marks the processed lead as “Done” and updates Google Sheets. Why use this? - Automates outbound lead processing without manual input or oversight. - Delivers consistent, structured, AI-generated email outreach. - Ensures every email is tracked with unique identifiers for engagement analytics. - Pushes metadata to your tracking system for reliable follow-up sequences. - Updates your Google Sheets lead pipeline automatically to prevent duplicate outreach.
How to import this n8n workflow
- 1
Download the workflow JSON file after purchase.
- 2
Open n8n → click the menu → Import from File.
- 3
Select the downloaded JSON and import.
- 4
Set up credentials for each node that requires them.
- 5
Click Execute Workflow to test, then activate.
Setup guide
Setup guide included
Purchase to unlock the full step-by-step guide
Related N8n workflows
Create Dialogflow entities from new Google Sheets rows
Generate social videos with AI avatars using VEED, Claude, and OpenAI
Extract and process healthcare claims with VLM Run, Google Drive and Sheets
Send a Mocean SMS from a new email in Gmail
Scrap prices from any page with HTML/CSS, Cloud Vision and MonkeyLearn
Automate cold outreach with email personalization using Gemini and Google Sheets
Automated inventory management with Airtable PO creation & supplier emails
Generate multiple languange blogpost with OpenAI, support Yoast & Polylang
Reviews
No reviews yet
Be the first to buy and share your experience.
Leave a review
Sign in to share your experience with this workflow.
Create a free account to purchase workflows.
- JSON blueprint — instant download
- Setup guide PDF included
- 5 downloads · valid 30 days
- Works with n8n
Need help setting this up?
Book a 3-hour live setup session with an Agility consultant.
- Configure live on Google Meet / Zoom
- Free follow-up if workflow has defects
- Platform expert assigned to you