💬 AI-powered automated outreach with scheduling, Gemini, Gmail & Google Sheets

⚡ 3,289 views · 💬 Lead Nurturing & AI Sales Agents

💡 Pro Tip — HTTP Request scraping tends to break when sites update their markup. If you’re scraping a major platform, check if ScraperNode covers it — it has maintained scrapers for LinkedIn, Instagram, TikTok, YouTube, and 20+ other platforms that return structured data.

Description

AI-Powered Automated Outreach Scheduling with Gemini, Gmail & Google Sheets

Automate your lead generation and outreach process seamlessly using AI, Gmail, and Google Sheets—all within n8n. No complicated setup—just import, activate, and start reaching prospects with personalized messages generated by Google Gemini’s AI model.

Quick Setup

1. Import the Workflow Download and import the provided workflow into your n8n instance.

2. Connect Your Accounts

   • Authenticate your Google Sheets account.
   • Connect your Gmail account for sending emails.

3. Prepare the Spreadsheet Use this template to set up your leads and tracking sheet.

4. Configure the Gemini API

   • Obtain your Gemini API key. Here
   • Add it to the Gemini API credentials within n8n.

5. Set Scheduling Preferences Customize the Schedule Trigger node to control when the workflow runs.

6. Edit Email Prompts Update the initial and follow-up email prompts to match your outreach tone and goals.

7. Set Rate Limits Configure the rate limiting settings to comply with Gmail sending limits and avoid spam filters.

8. Activate the Workflow Enable the workflow to begin automated outreach to your leads.

9. Track and Manage Leads Monitor responses and update lead statuses directly in your Google Sheet.

How It Works

• Schedule Trigger: Automatically starts outreach based on your defined schedule
• Google Sheets Integration: Fetches leads and updates their status after outreach
• Email Validation: Checks if lead emails are valid before sending
• Website Scraper: Gathers info from lead websites to personalize messages
• Google Gemini AI: Generates tailored cold outreach messages optimized for high response
• Gmail Node: Sends personalized emails directly from your Gmail account

Core Features

• Pull leads automatically from Google Sheets
• Validate emails to avoid bounces
• Scrape lead websites for custom messaging context
• Generate AI-crafted outreach emails with dynamic personalization
• Send emails on schedule without manual intervention
• Update lead status to track outreach progress

AI Integration

• Uses Google Gemini AI to create professional, friendly, and engaging outreach emails
• Dynamic prompt templates tailored to each lead’s company and website content
• Structured JSON output to easily map subject, greeting, and body content

💡 Usage Examples

• B2B cold outreach campaigns with personalized emails
• Automated follow-ups based on lead engagement
• Lead nurturing with context-aware messaging
• Sales prospecting workflows integrated into your CRM

✨ Benefits

• Save hours by automating personalized outreach
• Increase response rates with AI-optimized messaging
• Keep lead data organized and updated in Google Sheets
• Fully scalable and customizable n8n workflow
• Minimal setup, ready to run out-of-the-box

🔗 Nodes Used

Google Sheets, HTTP Request, Gmail, Schedule Trigger, Basic LLM Chain, Chat Trigger

📥 Import

Download workflow.json and import into n8n: Workflow menu → Import from File

📖 Importing guide · 🔑 Credential setup