B2B lead follow-up automation with Gemini AI, Gmail and Google Sheets

Overview This n8n workflow template automates your B2B marketing follow-up process. It tracks which introductory emails have received a reply, identifies leads who haven't responded within a set time, uses Gemini AI to draft a personalized, casual reminder, sends the follow-up as a reply on the original thread, and updates your lead tracker in Google Sheets.

Best if used with preivously created workflow that sends an automated introductory email with templatized subject.

Requirements To use this workflow, you need the following accounts and credentials:

Gmail Account: To check for replies and send the reminder emails.

Google Sheets Account: To manage your lead tracking spreadsheet (the workflow uses a sheet with ID). Below are the Sheet columns First Name Last Name Email ID Company Name Company Information (optional) Designation (optional) Message - the main form enquiry Location (optional) Status (auto) Intro email Date (auto) Reminder 1 needed? (auto) Reminder 1 Email Date (auto)

Google Gemini (PaLM) API Key: For the AI Agent node to generate the personalized email content.

How It Works This automation is broken down into three main stages:

Stage 1: Check for Replies and Update Tracker This stage excludes leads who have already replied to your introductory email and updates the status in your tracker.