AutomationMart
Home/Browse/Automate outbound lead follow-up & qualification
n8n

Automate outbound lead follow-up & qualification

n8nn8n11 modulesv1.0
GmailGoogle SheetsOpenAI

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
Automate outbound lead follow-up & qualification workflow diagram

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.

n8n

How to import this n8n workflow

  1. 1

    Download the workflow JSON file after purchase.

  2. 2

    Open n8n → click the menu → Import from File.

  3. 3

    Select the downloaded JSON and import.

  4. 4

    Set up credentials for each node that requires them.

  5. 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

Every time a new row is added to Google Sheets, Make will automatically create a new entity in Google Cloud Dialogflow. This template uses [this example spreadsheet](https://docs.google.com/spreadsheets/d/1aPTmooD8oediEfOmvAeOnNzh6FNSzHjZgQtM3gMYeIE/edit?usp=sharing).

Free

Generate social videos with AI avatars using VEED, Claude, and OpenAI

Generate social videos with AI avatars using VEED and Claude Overview This n8n workflow automatically generates TikTok/Reels-ready talking head videos from scratch. You provide a topic and intention, and the workflow handles everything: scriptwriting, avatar generation, voiceover creation, and video rendering. Output: Vertical (9:16) AI-generated videos with lip-synced avatars, ready for social media posting. --- What It Does Pipeline Breakdown | Step | Tool | What Happens | |------|------|-----

Free

Extract and process healthcare claims with VLM Run, Google Drive and Sheets

Automatically process healthcare claims into structured Google Sheets entries with VLM Run extraction What this workflow does Monitors Google Drive for new files in a target folder Downloads the file inside n8n for processing Sends the file to VLM Run for AI transcription or analysis Fetches extra details from the healthcare.claims-processing domain as JSON Appends normalized fields to a Google Sheet as a new row Setup Prerequisites: Google account, VLM Run API creden

Free

Send a Mocean SMS from a new email in Gmail

This template periodically checks for new emails in Gmail and uses the retrieved information to send SMSes in Mocean - notifications about new emails to yourself. The template is scheduled to run every 15 minutes. You can change the schedule after you set up the template.

Free

Scrap prices from any page with HTML/CSS, Cloud Vision and MonkeyLearn

This template helps you perform data mining on on a website at regular intervals. First, a screenshot of the url is taken via HTML/CSS. Then, the screenshot's text is recognized with Google Cloud Vision (OCR) and the price is automatically extracted with a MonkeyLearn machine learning model. Eventually, the result is stored in Google Sheets.

Free

Automate cold outreach with email personalization using Gemini and Google Sheets

This n8n template from Intuz provides a complete and automated solution for powerful cold outreach campaigns. It connects a Google Sheet of prospect data with Google Gemini to automatically generate highly personalized emails. By analyzing specific keywords and data points like company name, industry, or job title from your sheet, this automated workflow crafts unique, relevant messages that feel one-to-one, creating a complete system to dramatically improve your engagement and response rates. H

Free

Automated inventory management with Airtable PO creation & supplier emails

In-depth description of this automation: This is a fully automated daily supply chain and procurement workflow that keeps product stock levels healthy and suppliers updated, by automatically generating and emailing purchase orders (POs) and syncing PO statuses in Airtable. --- 📅 Daily triggers Two Schedule Trigger nodes run: One runs at midnight (00:00) to manage low stock and new purchase order creation. Another runs at 1:00 AM to process existing pending POs and em

Free

Generate multiple languange blogpost with OpenAI, support Yoast & Polylang

The blogblizt: polylang workflow streamlines the creation and publication of high-quality blog content using powerful automation with n8n, OpenAI’s GPT and the WordPress API. It enables effortlessly generate SEO-friendly articles complete with metadata and optimized featured images, improving content freshness and search engine visibility. 💡 Why Use blogblizt? Automate content creation to keep your blog fresh and engaging Generate SEO-optimized posts with expert-crafted titles, meta descriptio

Free

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.

Log in to review
Free
No ratings yet

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.

₹2,499/ session
3 hrs · video call
  • Configure live on Google Meet / Zoom
  • Free follow-up if workflow has defects
  • Platform expert assigned to you
Book installation session
Free