Hyper-personalisierte E-Mail-Kampagnen mit KI, Gmail und Google Sheets

• •Google-Konto + Gmail API-Anmeldedaten
• •Möglicherweise sind Ziel-API-Anmeldedaten erforderlich
• •Google Sheets API-Anmeldedaten
• •OpenAI API Key

{
  "id": "LCSqIlPZdq3OmgH0",
  "meta": {
    "instanceId": "1a54c41d9050a8f1fa6f74ca858828ad9fb97b9fafa3e9760e576171c531a787"
  },
  "name": "Hyper-Personalize Email Outreach with AI, Gmail & Google Sheets",
  "tags": [],
  "nodes": [
    {
      "id": "af621613-d8c3-411e-8f5b-26e08eb27133",
      "name": "Zeile(n) in Sheet abrufen",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        780,
        920
      ],
      "parameters": {
        "options": {},
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "{YOUR_SHEET_ID}",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/{YOUR_GOOGLE_SHEET_ID}/edit#gid=0",
          "cachedResultName": "{YOUR_SHEET_NAME}"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "{YOUR_GOOGLE_DOCUMENT_ID}",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/{YOUR_GOOGLE_DOCUMENT_ID}/edit?usp=drivesdk",
          "cachedResultName": "n8nEmail"
        }
      },
      "typeVersion": 4.6
    },
    {
      "id": "cf8bc124-04fd-4930-9040-6fc6ee6f25c4",
      "name": "Bei Klick auf 'Workflow ausführen'",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
        240,
        920
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "613fd1d4-ec8a-40be-9f31-ef64483acf87",
      "name": "Personalisierte E-Mails senden",
      "type": "n8n-nodes-base.gmail",
      "position": [
        2700,
        920
      ],
      "webhookId": "{YOUR_WEBHOOK_ID}",
      "parameters": {
        "sendTo": "={{ $('Get row(s) in sheet').item.json['Email ID'] }}",
        "message": "={{ $json.message.content }}",
        "options": {
          "appendAttribution": false
        },
        "subject": "=Re:{{ $('Get row(s) in sheet').item.json.Intent }}"
      },
      "typeVersion": 2.1
    },
    {
      "id": "a40af7f9-b6f3-400e-ab4e-dd775003b733",
      "name": "Notiz",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        60,
        620
      ],
      "parameters": {
        "color": 5,
        "width": 440,
        "height": 280,
        "content": "### Step 1: Kickoff the Conversation! 🟢📬\n\nClick **“Execute Workflow”** to start the automation.\n\nWhat happens next?\n\n- 📄 It reads data from the sheet (Name, Email, Intent, and Message).\n- 🚀 Triggers the workflow to process each row individually.\n\nThis starts the process of sending personalized email to the end users\n"
      },
      "typeVersion": 1
    },
    {
      "id": "b6a44211-9973-426f-970e-7cf92ba068cf",
      "name": "Notiz1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        620,
        1080
      ],
      "parameters": {
        "color": 3,
        "width": 380,
        "height": 480,
        "content": "### Step 2: Sheet Scanner Activated! 📄🔍\n\nThis node connects to your **Google Sheet** and reads all the rows in it.\n\nConfigure your **document** and specific **sheet** here\n\nWhat it fetches:\n\n- 🧑‍💼 First Name  \n- 📧 Email ID  \n- 🧠 Intent  \n- 💬 Why They Sent the Email\n\nThis node is crucial to fetch the details for the ***automated*** e-mail process \n\nEach row represents a unique lead or contact, ready to be processed and responded to. It’s your automation’s inbox—neatly structured and scalable.\n"
      },
      "typeVersion": 1
    },
    {
      "id": "742daf1e-e03e-4aa5-a01f-6d7a89e562e9",
      "name": "Notiz2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1900,
        1120
      ],
      "parameters": {
        "color": 4,
        "width": 420,
        "height": 360,
        "content": "### Step 4: Smart Email Writer ✍️🤖\n\nThis node uses **OpenAI** to craft a personalized email reply for each contact.\n\nUsing:\n\n- 🧠 **Intent** (e.g., Demo Request, Partnership Inquiry)\n- 💬 **Why They Sent the Email**\n\nIt generates a thoughtful, relevant, and human-like response tailored to each person’s message.\n\nNo templates. Just context-aware communication—written like a professional.\n"
      },
      "typeVersion": 1
    },
    {
      "id": "41dad360-10ee-40f4-9e9b-1f2d490d2545",
      "name": "Notiz3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        2520,
        500
      ],
      "parameters": {
        "color": 6,
        "width": 380,
        "height": 400,
        "content": "### Step 5: Hitting Send ✉️📨\n\nThis node uses the **Gmail integration** to send the personalized email generated in the previous step.\n\nWhat it does:\n\n- ✅ Sends the message to the contact’s **Email ID**.\n- 💬 Includes the personalized content created by OpenAI.\n- 📅 Ensures timely, automated follow-up—without manual effort.\n\nThis node completes the automation process by sending the personalized emails to the end users.\n"
      },
      "typeVersion": 1
    },
    {
      "id": "cfb4be86-d24c-4eb5-ab7e-649c851bbadc",
      "name": "Model anfragen",
      "type": "@n8n/n8n-nodes-langchain.openAi",
      "position": [
        1920,
        920
      ],
      "parameters": {
        "modelId": {
          "__rl": true,
          "mode": "list",
          "value": "{YOUR_OPENAI_MODEL}",
          "cachedResultName": "{YOUR_OPENAI_MODEL_NAME}"
        },
        "options": {},
        "messages": {
          "values": [
            {
              "content": "=Write a professional and friendly email reply to {{ $('Get row(s) in sheet').item.json['First Name'] }} . Their intent is \"{{ $('Get row(s) in sheet').item.json.Intent }}\". They wrote: \"{{ $('Get row(s) in sheet').item.json['Why They Sent Email'] }}\". Make the response specific to their message and helpful.No need to add the subject line. Generate in HTML formatting.\nThe footer signature should be of the following format\nThanks,\n{{ $json.sendAs[0].displayName }}\n"
            }
          ]
        }
      },
      "typeVersion": 1.8
    },
    {
      "id": "e2b7d857-9ebb-4bff-914c-c7c8c4c87de2",
      "name": "HTTP Request",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        1320,
        920
      ],
      "parameters": {
        "url": "https://gmail.googleapis.com/gmail/v1/users/me/settings/sendAs",
        "options": {},
        "authentication": "predefinedCredentialType",
        "nodeCredentialType": "gmailOAuth2"
      },
      "typeVersion": 4.2,
      "alwaysOutputData": true
    },
    {
      "id": "c9140451-b3db-433e-9fc4-9c7ff088c455",
      "name": "Notiz4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1100,
        560
      ],
      "parameters": {
        "width": 420,
        "height": 340,
        "content": "### Step 3: Signature Sync 🖋️📛\n\nThis node connects to your **Gmail account** to fetch your display name.\n\nWhy this matters:\n\n- ✅ Ensures your name appears correctly in the email signature.\n- 📬 Maintains professionalism and brand consistency.\n- 🤝 Adds a personal touch to every automated reply.\n\nThis node ensures the email signature has your name on it instead of vague details\n"
      },
      "typeVersion": 1
    },
    {
      "id": "da2db045-a86c-4735-bc81-b5d69df1b28a",
      "name": "Notiz5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        20,
        0
      ],
      "parameters": {
        "color": 4,
        "width": 480,
        "height": 520,
        "content": "## 🛠️ Prerequisites\n\nBefore running this workflow, make sure the following integrations are set up:\n\n1. **Google Account Setup**  \n   - Connect your Google account using **Client Credentials**.  \n   - Enable the following services:  \n     - 📄 Google Sheets \n     - 📂 Google Drive   \n     - 📧 Gmail \n\n2. **OpenAI Integration**  \n   - Add and configure your **OpenAI API Key**.  \n   - Required for generating context-aware, personalized email replies.\n\n\nThis will ensure the smooth execution of your personalised email sending workflow\n"
      },
      "typeVersion": 1
    },
    {
      "id": "50b85307-3566-4b05-b7a7-459864f53362",
      "name": "Notiz6",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        2740,
        1120
      ],
      "parameters": {
        "color": 6,
        "width": 420,
        "content": "### Support\n\nFor further support, or to develop and custom workflow, reach out to:\n\n getstarted@intuz.com"
      },
      "typeVersion": 1
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "6da9d4a4-381a-4ecf-bb5d-d92075e7be16",
  "connections": {
    "e2b7d857-9ebb-4bff-914c-c7c8c4c87de2": {
      "main": [
        [
          {
            "node": "cfb4be86-d24c-4eb5-ab7e-649c851bbadc",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "cfb4be86-d24c-4eb5-ab7e-649c851bbadc": {
      "main": [
        [
          {
            "node": "613fd1d4-ec8a-40be-9f31-ef64483acf87",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "af621613-d8c3-411e-8f5b-26e08eb27133": {
      "main": [
        [
          {
            "node": "e2b7d857-9ebb-4bff-914c-c7c8c4c87de2",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "cf8bc124-04fd-4930-9040-6fc6ee6f25c4": {
      "main": [
        [
          {
            "node": "af621613-d8c3-411e-8f5b-26e08eb27133",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}