FindPrompts
n8nSales & CRMAdvanced5 steps

Cold Outreach Personalizer

Iterates a list of prospects in Google Sheets, researches each from their website, and writes a tailored first-line and email with GPT before drafting it. Scales personalized outreach without the manual grind.

Google SheetsHTTPOpenAI

How it works

  1. 1Trigger: manual or scheduled run over the prospect sheet
  2. 2Read prospects from Google Sheets
  3. 3Fetch each prospect's website for context
  4. 4Write a personalized email with GPT
  5. 5Save the drafted email back to the sheet

Setup

  • Keep name, company, website and email columns in Prospects.
  • Connect Google Sheets and OpenAI credentials.
  • Respect anti-spam laws and only email opted-in contacts where required.
  • Add a Gmail node to send approved drafts.

Workflow JSON

{
  "name": "Cold Outreach Personalizer",
  "nodes": [
    {
      "id": "co01aa",
      "name": "Manual Trigger",
      "type": "n8n-nodes-base.manualTrigger",
      "typeVersion": 1,
      "position": [
        180,
        300
      ],
      "parameters": {}
    },
    {
      "id": "co02bb",
      "name": "Read Prospects",
      "type": "n8n-nodes-base.googleSheets",
      "typeVersion": 4.4,
      "position": [
        380,
        300
      ],
      "parameters": {
        "operation": "read",
        "documentId": "YOUR_SHEET_ID",
        "sheetName": "Prospects"
      }
    },
    {
      "id": "co03cc",
      "name": "Fetch Website",
      "type": "n8n-nodes-base.httpRequest",
      "typeVersion": 4.2,
      "position": [
        580,
        300
      ],
      "parameters": {
        "url": "={{ $json.website }}",
        "method": "GET",
        "options": {
          "response": {
            "response": {
              "responseFormat": "text"
            }
          }
        }
      }
    },
    {
      "id": "co04dd",
      "name": "Write Email",
      "type": "@n8n/n8n-nodes-langchain.openAi",
      "typeVersion": 1.4,
      "position": [
        780,
        300
      ],
      "parameters": {
        "modelId": "gpt-4o",
        "messages": {
          "values": [
            {
              "role": "system",
              "content": "Write a short, specific cold email with a personalized first line referencing their site."
            },
            {
              "role": "user",
              "content": "Prospect: {{ $('Read Prospects').item.json.name }} at {{ $('Read Prospects').item.json.company }}\nSite content: {{ $json.data }}"
            }
          ]
        }
      }
    },
    {
      "id": "co05ee",
      "name": "Save Draft",
      "type": "n8n-nodes-base.googleSheets",
      "typeVersion": 4.4,
      "position": [
        980,
        300
      ],
      "parameters": {
        "operation": "appendOrUpdate",
        "documentId": "YOUR_SHEET_ID",
        "sheetName": "Prospects",
        "columns": {
          "mappingMode": "defineBelow",
          "value": {
            "email": "={{ $('Read Prospects').item.json.email }}",
            "draft": "={{ $json.message.content }}"
          }
        }
      }
    }
  ],
  "connections": {
    "Manual Trigger": {
      "main": [
        [
          {
            "node": "Read Prospects",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Read Prospects": {
      "main": [
        [
          {
            "node": "Fetch Website",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Fetch Website": {
      "main": [
        [
          {
            "node": "Write Email",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Write Email": {
      "main": [
        [
          {
            "node": "Save Draft",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  },
  "active": false,
  "settings": {},
  "meta": {}
}

Command Palette

Search for a command to run...