Personalisierte E-Mail

Name: Personalisierte E-Mail
Rating: 4.5 (10 reviews)
Author: Intuz
Fortgeschritten
Dies ist ein Lead Nurturing, Multimodal AI-Bereich Automatisierungsworkflow mit 8 Nodes. Hauptsächlich werden If, Set, GoogleSheets, ScheduleTrigger, ChainLlm und andere Nodes verwendet. Erstellen Sie personalisierte Vertriebs-E-Mails mit Gemini AI und Google Tabellen
Voraussetzungen
•Google Sheets API-Anmeldedaten
•Google Gemini API Key
Verwendete Nodes (8)

OutputParserStructured
Kategorie

Lead-Pflege
Multimodales KI
Workflow-Vorschau
Visualisierung der Node-Verbindungen, mit Zoom und Pan
Leads aus Tabelle lesen
Daten für Tabelle vorbereiten
Tabelle mit E-Mail aktualisieren
Basic LLM Chain
Google Gemini Chat Model
Structured Output Parser
Schedule Trigger
React Flow
Workflow exportieren
Kopieren Sie die folgende JSON-Konfiguration und importieren Sie sie in n8n
{
  "name": "Personalised Mail",
  "nodes": [
    {
      "id": "c3a221a2-d3e3-47f3-a897-6781a29857a4",
      "name": "Leads aus Tabelle lesen",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -400,
        0
      ],
      "parameters": {
        "options": {},
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "Your_Sheet_GID",
          "cachedResultUrl": "Your_Sheet_URL",
          "cachedResultName": "Your_Sheet_Name"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "YOUR_SPREADSHEET_ID_HERE",
          "cachedResultUrl": "Your_Spreadsheet_URL",
          "cachedResultName": "Your_Spreadsheet_Name"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "Your_Credentials_Id",
          "name": "Google Sheets account"
        }
      },
      "typeVersion": 4
    },
    {
      "id": "23b2b8e8-e26c-4586-9ec1-dba83ab0069c",
      "name": "Daten für Tabelle vorbereiten",
      "type": "n8n-nodes-base.set",
      "position": [
        400,
        0
      ],
      "parameters": {
        "values": {
          "string": [
            {
              "name": "updated_email",
              "value": "={{ $input.item.json.text }}"
            }
          ]
        },
        "options": {}
      },
      "typeVersion": 2
    },
    {
      "id": "7e937d3d-3483-442e-b89c-57ce699609ed",
      "name": "Tabelle mit E-Mail aktualisieren",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        620,
        0
      ],
      "parameters": {
        "columns": {
          "value": {
            "Email": "={{ $('Read Leads from Sheet').item.json.Email }}",
            "subject": "= {{ $json.output.subject }}",
            "email_body": "={{ $json.output.email_body }}"
          },
          "schema": [
            {
              "id": "Name",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Name",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Title",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Title",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Company",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Company",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Location",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Location",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Education",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Education",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "LinkedIn_Connections",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "LinkedIn_Connections",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Industry_Focus",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Industry_Focus",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Key_Expertise",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Key_Expertise",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "LinkedIn_URL",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "LinkedIn_URL",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Email",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "Email",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Company_Type",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Company_Type",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Focus_Areas",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Focus_Areas",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Growth_Stage",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Growth_Stage",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Pain_Points",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Pain_Points",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Location_Opportunities",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Location_Opportunities",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Email_Template",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Email_Template",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "LinkedIn_DM_Template",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "LinkedIn_DM_Template",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Company_Website",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Company_Website",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "email_body",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "email_body",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "subject",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "subject",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "row_number",
              "type": "string",
              "display": true,
              "removed": true,
              "readOnly": true,
              "required": false,
              "displayName": "row_number",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [
            "Email"
          ],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "update",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "Your_Sheet_GID",
          "cachedResultUrl": "Your_Sheet_URL",
          "cachedResultName": "Your_Sheet_Name"
        },
        "documentId": {
          "__rl": true,
          "mode": "id",
          "value": "=1p6vuSjRfTiSUrPa3CR4wQA8c9NyuS18K2UMhP_bWx08"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "Your_Credentials_Id",
          "name": "Google Sheets account"
        }
      },
      "typeVersion": 4
    },
    {
      "id": "9120c44a-92a4-4f06-83a5-045bd7e17a07",
      "name": "Basic LLM Chain",
      "type": "@n8n/n8n-nodes-langchain.chainLlm",
      "position": [
        40,
        0
      ],
      "parameters": {
        "text": "=You are an expert email copywriter for Intuz, a company offering AI Engineering and AI Service solutions.\n\nYour task is to generate the components for a single, concise, professional, and conversational email outreach (100-120 words).\n\n---\n**CONTEXT & DATA**\n*   Prospect Name: {{ $('Read Leads from Sheet').item.json.Name }}\n*   Company Name: {{ $('Read Leads from Sheet').item.json.Company }}\n*   Persona / Title: {{ $('Read Leads from Sheet').item.json.Title }}\n*   CTA Link: [https://calendly.com/YOUR_LINK]\n\n---\n**INSTRUCTIONS**\n*   **Pain Point:** Focus on one of these: slow AI feature rollouts, difficulty integrating AI, scaling challenges, or security concerns.\n*   **Value Proposition:** Highlight how Intuz's AI Engineering services solve that specific pain point (e.g., rapid development, seamless integration, scalable workflows).\n*   **Structure:** The email body must start with a question addressing the pain point, briefly explain the solution, and end with a CTA for a 15-minute call using the provided link.\n*   **Tone:** Conversational, empathetic, and professional.\n*   **Subject Line:** Generate a catchy, question-based subject line (under 8 words) tied to the pain point.\n*   **Personalization:** Use the prospect's data to tailor the message.\n*   **CRITICAL FORMATTING:** Structure the `email_body` into 3 distinct paragraphs. Use the markdown newline character `\\n\\n` to separate each paragraph for clean spacing and readability.\n*   **Constraints:** Keep the body 100-120 words. No salutation (e.g., \"Hi Tobias,\") or sign-off (e.g., \"Best,\") should be included in the email body.\n\n---\n**REQUIRED OUTPUT**\nYou MUST format your response as a valid JSON object containing two keys: \"subject\" and \"email_body\".",
        "batching": {},
        "promptType": "define",
        "hasOutputParser": true
      },
      "typeVersion": 1.7
    },
    {
      "id": "3434b60b-85ea-4221-94c4-3abf64f8ff17",
      "name": "Google Gemini Chat Model",
      "type": "@n8n/n8n-nodes-langchain.lmChatGoogleGemini",
      "position": [
        60,
        220
      ],
      "parameters": {
        "options": {},
        "modelName": "models/gemini-2.5-flash"
      },
      "credentials": {
        "googlePalmApi": {
          "id": "Your_Gemini_API",
          "name": "Your Google Gemini API"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "e62f603b-d063-4f90-9d13-ce599b536bed",
      "name": "Structured Output Parser",
      "type": "@n8n/n8n-nodes-langchain.outputParserStructured",
      "position": [
        180,
        220
      ],
      "parameters": {
        "jsonSchemaExample": "{\n  \"subject\": \"A short, catchy, question-based subject line\",\n  \"email_body\": \"The full email body, 100-120 words, without any salutation or sign-off.\"\n}"
      },
      "typeVersion": 1.3
    },
    {
      "id": "323a2628-a30a-4b20-8a56-2d0677c6c5af",
      "name": "Schedule Trigger",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        -620,
        0
      ],
      "parameters": {
        "rule": {
          "interval": [
            {
              "field": "minutes",
              "minutesInterval": 30
            }
          ]
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "cbca8f8d-959d-45b9-a801-20386034a844",
      "name": "If",
      "type": "n8n-nodes-base.if",
      "position": [
        -180,
        0
      ],
      "parameters": {
        "options": {},
        "conditions": {
          "options": {
            "version": 2,
            "leftValue": "",
            "caseSensitive": true,
            "typeValidation": "strict"
          },
          "combinator": "and",
          "conditions": [
            {
              "id": "0640b75d-662e-4625-a038-92c099b79f25",
              "operator": {
                "type": "string",
                "operation": "empty",
                "singleValue": true
              },
              "leftValue": "={{ $json.email_body }}",
              "rightValue": ""
            },
            {
              "id": "6d30f170-03fd-4e89-9a56-ab87e8c7c01a",
              "operator": {
                "type": "string",
                "operation": "empty",
                "singleValue": true
              },
              "leftValue": "={{ $json.subject }}",
              "rightValue": ""
            }
          ]
        }
      },
      "typeVersion": 2.2
    }
  ],
  "active": true,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "connections": {
    "cbca8f8d-959d-45b9-a801-20386034a844": {
      "main": [
        [
          {
            "node": "9120c44a-92a4-4f06-83a5-045bd7e17a07",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "9120c44a-92a4-4f06-83a5-045bd7e17a07": {
      "main": [
        [
          {
            "node": "23b2b8e8-e26c-4586-9ec1-dba83ab0069c",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "323a2628-a30a-4b20-8a56-2d0677c6c5af": {
      "main": [
        [
          {
            "node": "c3a221a2-d3e3-47f3-a897-6781a29857a4",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "c3a221a2-d3e3-47f3-a897-6781a29857a4": {
      "main": [
        [
          {
            "node": "cbca8f8d-959d-45b9-a801-20386034a844",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "23b2b8e8-e26c-4586-9ec1-dba83ab0069c": {
      "main": [
        [
          {
            "node": "7e937d3d-3483-442e-b89c-57ce699609ed",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "7e937d3d-3483-442e-b89c-57ce699609ed": {
      "main": [
        []
      ]
    },
    "3434b60b-85ea-4221-94c4-3abf64f8ff17": {
      "ai_languageModel": [
        [
          {
            "node": "9120c44a-92a4-4f06-83a5-045bd7e17a07",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "e62f603b-d063-4f90-9d13-ce599b536bed": {
      "ai_outputParser": [
        [
          {
            "node": "9120c44a-92a4-4f06-83a5-045bd7e17a07",
            "type": "ai_outputParser",
            "index": 0
          }
        ]
      ]
    }
  }
}
Häufig gestellte Fragen
Wie verwende ich diesen Workflow?

Kopieren Sie den obigen JSON-Code, erstellen Sie einen neuen Workflow in Ihrer n8n-Instanz und wählen Sie "Aus JSON importieren". Fügen Sie die Konfiguration ein und passen Sie die Anmeldedaten nach Bedarf an.
Für welche Szenarien ist dieser Workflow geeignet?

Fortgeschritten - Lead-Pflege, Multimodales KI
Ist es kostenpflichtig?

Dieser Workflow ist völlig kostenlos. Beachten Sie jedoch, dass Drittanbieterdienste (wie OpenAI API), die im Workflow verwendet werden, möglicherweise kostenpflichtig sind.