AI Cold Email Outreach Machine | n8n GPT-4 Personalized Email Bot
    100%
    CRM Integration
    0(0 reviews)
    0 downloads

    AI Cold Email Outreach Machine | n8n GPT-4 Personalized Email Bot

    NM

    Curated by n8n Markets team

    Last updated: April 19, 2026

    Bismillahir Rahmanir Rahim Send 100% unique, AI-personalized cold emails at scale. Using GPT-4o-mini, this n8n bot reads your lead list and crafts high-conversion emails that land in the inbox. Perfect for agencies and freelancers. The AI Cold Email Outreach Machine is a fully automated n8n workflow that reads your prospect list from Google Sheets, uses GPT-4o-mini to write a unique, personalised cold email for each lead, sends it via your Gmail account, and marks the lead as "Sent" — all on a 24-hour schedule without any manual intervention. 1.1 What the workflow does ⦁ Reads every row in your Google Sheet where Status = Pending ⦁ Skips rows with blank email addresses automatically ⦁ Calls OpenAI to write a 3-sentence, personalised cold email per lead ⦁ Sends the email from your connected Gmail account ⦁ Waits 30 seconds between sends to protect your sender reputation ⦁ Marks each lead as "Sent ✅" and records the subject line and send date 1.2 Node-by-node flow [Daily Trigger] → [Read Pending Leads] → [Skip Empty Emails] → [GPT-4 Write Email] → [Parse AI Response] → [Send via Gmail] → [Wait 30s] → [Mark as Sent] Node Type Purpose Daily Trigger Schedule Trigger Fires every 24 hours automatically Read Pending Leads Google Sheets Reads rows where Status = "Pending" Skip Empty Emails Filter Drops rows with no email address GPT-4 Write Email OpenAI Generates personalised 3-sentence email Parse AI Response Code (JS) Parses JSON, validates email body, extracts row number Send via Gmail Gmail Sends the email from your Gmail account Wait 30s Wait Anti-spam delay between sends Mark as Sent Google Sheets Updates Status, logs subject + date 1.3 Technical requirements Requirement Details n8n Self-hosted or n8n Cloud (any plan) OpenAI account API key with GPT-4o-mini access — platform.openai.com Gmail account Google account with OAuth2 authorised in n8n Google Sheets Sheet with columns: Name | Company | Email | Industry | Status Operating cost Approx. $0.001/email. $5 credit = ~5,000 emails 2. Before You Begin 2.1 Accounts to create 1. Create an OpenAI account at platform.openai.com and generate an API key under API Keys. Save the key securely — you will paste it into n8n shortly. 2. Ensure you have a Gmail account (Google Workspace or personal) that you want to send from. 3. Create or identify the Google Sheet you will use for leads. 2.2 Credentials to prepare IMPORTANT: Prepare these before importing the workflow OpenAI API key — from platform.openai.com/api-keys Gmail account credentials — you will authorise via OAuth (no password needed) Google Sheets — you will authorise via OAuth using the same Google account as Gmail 3. Google Sheet Setup The workflow reads from and writes to a single Google Sheet. The sheet structure is fixed — column names must match exactly. 3.1 Create the Leads tab 1. Open Google Sheets and create a new spreadsheet, or open an existing one. 2. Rename the first tab (bottom tab bar) to exactly: Leads Case-sensitive. "leads" or "LEADS" will not work. 3. In Row 1, enter these exact headers, one per column: Column A Column B Column C Column D Column E Name Company Email Industry Status IMPORTANT: Column headers are case-sensitive The workflow filter looks for Status = "Pending" — wrong capitalisation means 0 leads are read. Do not add extra columns before Column A or the row_number mapping will break. 3.2 Add your leads 1. Fill in rows starting from Row 2. Each row = one lead. 2. Set Status = Pending for every lead you want emailed on the next run. 3. Leave the Email column blank for any lead you want to skip — the filter node handles this automatically. 3.3 Find your Sheet ID 1. Open your Google Sheet in the browser. 2. Copy the long ID from the URL: URL structure https://docs.google.com/spreadsheets/d/ [THIS_IS_YOUR_SHEET_ID] /edit 1. Save this ID — you will paste it into two nodes during setup. 4. Import & Configure in n8n 4.1 Import the workflow 1. In n8n, click + New Workflow. 2. Click the three-dot menu (top right) → Import from File. 3. Select the file: 01_cold_email_machine_FIXED.json 4. The workflow canvas will open with all 8 nodes visible. 4.2 Connect Google Sheets (both nodes) 1. Click the node: Read Pending Leads 2. In the Credential to connect field, click Create New. 3. Select Google Sheets OAuth2 API → sign in with the Google account that owns the sheet. 4. After authorising, paste your Sheet ID into the Document ID field, replacing: PASTE_YOUR_SHEET_ID_HERE 5. Repeat steps 1–4 for the node: Mark as Sent in Sheet (same Sheet ID, same credential). IMPORTANT: Sheet ID must be replaced in 2 nodes Both "Read Pending Leads" and "Mark as Sent in Sheet" nodes have the PASTE_YOUR_SHEET_ID_HERE placeholder. If you replace only one, emails will send but the status will never update — leads will be re-emailed every 24 hours. 4.3 Connect OpenAI 1. Click the node: GPT-4 Write Email 2. In the Credential field, click Create New → OpenAI. 3. Paste your OpenAI API key into the API Key field → Save. 4.4 Connect Gmail 1. Click the node: Send via Gmail 2. In the Credential field, click Create New → Gmail OAuth2 API. 3. Sign in with the Gmail account you want to send from → Allow. 4.5 Add your email signature 1. Click the node: Send via Gmail 2. In the Message field, find and replace all 5 placeholders: Placeholder Replace with YOUR_FULL_NAME e.g. Ahmed Khan YOUR_JOB_TITLE e.g. Automation Consultant YOUR_COMPANY_NAME e.g. FlowStack Agency YOUR_WEBSITE e.g. www.flowstack.io YOUR_PHONE_NUMBER e.g. +92 300 1234567 1. Also replace YOUR_EMAIL@yourdomain.com in the Reply-To field with your actual email. INFO: Test with one lead first Before activating the workflow, manually execute it with just one "Pending" lead in the sheet. In n8n, click Execute Workflow (play button). Check your inbox and the sheet before adding your full list. 5. Pre-Launch Checklist Complete every item below before clicking Activate. Print or tick off as you go. 5.1 Google Sheet ⦁ Sheet has a tab named exactly "Leads" (capital L) ⦁ Row 1 headers: Name | Company | Email | Industry | Status — exact spelling ⦁ At least one row has Status = Pending (capital P) ⦁ Sheet ID copied from the URL 5.2 n8n credentials ⦁ Google Sheets OAuth2 connected and authorised ⦁ OpenAI API key entered and saved — key has credit balance ⦁ Gmail OAuth2 connected and authorised 5.3 Node configuration ⦁ Sheet ID replaced in Read Pending Leads node ⦁ Sheet ID replaced in Mark as Sent in Sheet node ⦁ All 5 signature placeholders replaced in Send via Gmail node ⦁ YOUR_EMAIL@yourdomain.com replaced in Reply-To field 5.4 Test run ⦁ Manual test executed with 1 lead — email received in inbox ⦁ Sheet row updated to "Sent ✅" after test run ⦁ Workflow Activated (green toggle in top right of canvas) 6. Day-to-Day Operation 6.1 Adding new leads Simply add new rows to your Leads sheet with Status = Pending. The next scheduled run (within 24 hours) will pick them up automatically. You do not need to restart or reconfigure anything. 6.2 Monitoring executions 1. In n8n, click Executions in the left sidebar. 2. Each daily run appears as a row. Green = success, Red = error. 3. Click any execution row to see the output of each node — including the email subject and body written by GPT. 6.3 Pausing the workflow To pause sending, click the Active toggle on the workflow canvas to deactivate it. Leads remain in Pending status and will resume on next activation. 6.4 Adjusting send frequency 1. Click the Daily Trigger node. 2. Change the hoursInterval value. Default is 24 (once per day). 3. Set to 48 for every 2 days, or 12 for twice daily. IMPORTANT: Gmail daily send limits Personal Gmail: 500 emails/day. Google Workspace: 2,000 emails/day. If you have 600 leads, spread them across 2 days or upgrade to Workspace. 7. Troubleshooting Error / Symptom Likely Cause Fix No emails sent, no errors shown No rows have Status = "Pending" Check sheet — Status must be exactly "Pending" (capital P). Check you are on the Leads tab. 401 error on OpenAI node API key invalid or no credit balance Regenerate key at platform.openai.com. Add credit at platform.openai.com/usage. Gmail node fails with 403 OAuth token expired or revoked Click Gmail node → Credential → Reconnect → re-authorise with Google. "Row number is missing" warning in logs Sheet was re-imported, stripping row metadata Recreate the Leads tab fresh. The workflow will append a warning row — safe to delete. Emails sent but Status not updating Sheet ID missing or wrong in Mark as Sent node Open the Mark as Sent node → paste the correct Sheet ID. Blank email body sent OpenAI returned empty response The workflow now throws an error instead of sending. Check OpenAI quota. Retry. Same leads emailed twice Status column not updating to "Sent ✅" See "Status not updating" row above. Also check Sheet tab name is exactly "Leads". Email goes to spam New sending domain, no warmup Warm up your Gmail address first. Increase wait time to 60s in the Wait node. 8. Customisation Guide 8.1 Change the GPT model Click the GPT-4 Write Email node → change the Model field. Options: gpt-4o-mini (default, cheapest), gpt-4o (better quality, ~10× cost), gpt-3.5-turbo (fastest, lower quality). 8.2 Modify the email prompt Click the GPT-4 Write Email node → edit the user content message. You can change the number of sentences, tone, length, or add your own context. Keep the JSON output instruction at the bottom intact, or update the Parse node to match. 8.3 Change send frequency Click the Daily Trigger node → change hoursInterval. The current setting is 24 hours. 8.4 Add CC or BCC Click the Send via Gmail node → expand Additional Options → add CC or BCC email addresses. 8.5 Add more columns to the sheet You can add extra columns to your sheet (e.g. "Phone", "LinkedIn URL") for your own reference. The workflow only reads Name, Company, Email, Industry, and Status — extra columns are ignored. 8.6 Increase anti-spam delay Click the Wait 30s node → change the amount field. 60 seconds is recommended for large lists (500+ leads). Note: 500 leads × 60s = 8.3 hours runtime per daily execution

    What's Included

    • ZIP

    Requirements

    Version v1.1.0 (Fixed) Trigger Scheduled — every 24 hours Integrations Google Sheets • OpenAI GPT-4o-mini • Gmail Cost to run ~$0.001 per email (approx. $5 per 5,000 emails) Difficulty Beginner — no coding required Avg setup time 15–20 minutes

    How to Use

    Version v1.1.0 (Fixed) Trigger Scheduled — every 24 hours Integrations Google Sheets • OpenAI GPT-4o-mini • Gmail Cost to run ~$0.001 per email (approx. $5 per 5,000 emails) Difficulty Beginner — no coding required Avg setup time 15–20 minutes

    How to import this template into n8n

    1. Download the workflow JSON file from this page.
    2. In n8n, open Workflows, create a new workflow and choose Import from File.
    3. Open each node that shows a warning and connect your own credentials.
    4. Run the workflow once manually to check the output before you activate it.
    Included in Pro
    • Importable n8n workflow JSON file
    • Download with Builder Pro or Agency Unlimited
    • Built for n8n v1.0+
    • Setup time: 15 minutes

    Included in Builder Pro — $19/mo, 4,177 premium workflows

    Before you activate

    Templates are reviewed before they are listed. Test with your own credentials and data before running it in production.

    Updated Apr 2026
    v1.0.0
    SSL
    Secure
    GDPR

    100% Secure Checkout

    Refund requests within 7 days of a new subscription

    Reviews

    0

    No reviews yet

    See all 0 reviews ↓
    —

    0 reviews

    5★
    0
    4★
    0
    3★
    0
    2★
    0
    1★
    0

    No reviews yet.

    Questions & Answers

    0

    Log in to ask a question.

    No questions yet. Be the first to ask!

    People Also Bought