Cold Email Outreach with Gmail and Google Sheets, personalized by analyzing business website

This workflow automates personalized cold email outreach by fetching lead data from a Google Sheet, analyzing the prospect's business website, crafting a tailored message using AI, sending the email via Gmail, and updating the sheet to track who has been contacted.

Features

• Automated Scheduling – Runs at a specified time via the Schedule Trigger node.
• Google Sheets Integration – Fetches leads from a Google Sheet that have been pre-processed and are marked for outreach.
• AI-Powered Personalization – Uses an AI Agent powered by a Large Language Model (e.g., GPT-5) to analyze the lead's website and write a unique, value-driven email pitch.
• Gmail Outreach – Sends the personalized email directly to the lead.
• Status Tracker – Updates the Outreach Status in the Google Sheet for each lead after an email is sent to prevent duplicates and maintain a clear record.

Requirements

• Google Sheets credential
• Gmail credential
• AI/LLM service credential (e.g., Google Gemini, OpenAI)
• Access to an n8n deployed instance

Setup Instructions

1. Connect AccountsAuthenticate your Google Sheets, Gmail, and AI/LLM accounts via OAuth2 in your n8n credentials settings.
2. Prepare Your Google SheetYour Google Sheet must contain the following columns:
   • Title
   • Website
   • Email
   • Industry
   • Outreach Status (The workflow will only process rows marked Pending in this column)
3. Customize the Workflow
   • Open the Edit Fields node to set your person name and company for the email signature.
   • The core logic is within the AI Agent node. The prompt is pre-configured to act as an email outreach specialist. You can adjust the prompt to change the agent's persona or refine its analysis and writing style.
4. Schedule the WorkflowEdit the Schedule Trigger node to set your preferred time for the workflow to run.

Customization Tips

• Refine the AI Prompt: Modify the prompt in the AI Agent node to change the email's tone, focus on different business aspects, or adjust the call-to-action.
• Add More Fields: Add more columns to your Google Sheet (e.g., Contact Person) and reference them in the AI prompt for even deeper personalization.
• Batch Size: Adjust the batch size in the Loop Over Items node to control how many emails are processed in each run, which can help manage rate limits.

Google Sheet Template

You can copy this sample Google Sheet to get started.

Need a lead generation pipeline to feed this workflow? Check out this n8n workflow that automates Google Maps lead generation without any paid tools.