Automatisiertes E-Mail-Klassifizierungs- und Antwortsystem mit Gmail, GPT und Tabellen

• •Google-Konto + Gmail API-Anmeldedaten
• •Google Sheets API-Anmeldedaten
• •OpenAI API Key

{
  "meta": {
    "instanceId": "e2e2c9bc62a9282c580eaa52732abefcb4fb323e22933a39566356c65407044d",
    "templateCredsSetupCompleted": true
  },
  "nodes": [
    {
      "id": "a75f0c4e-9b1e-4f76-81a7-903707c0548a",
      "name": "Gmail Trigger",
      "type": "n8n-nodes-base.gmailTrigger",
      "position": [
        -1376,
        528
      ],
      "parameters": {
        "simple": false,
        "filters": {
          "labelIds": [
            "INBOX"
          ],
          "readStatus": "unread"
        },
        "options": {},
        "pollTimes": {
          "item": [
            {
              "mode": "everyMinute"
            }
          ]
        }
      },
      "credentials": {
        "gmailOAuth2": {
          "id": "cWqq2EMH5CzPA1AE",
          "name": "Gmail account"
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "53354083-ac12-458b-a234-773b6ba38b7e",
      "name": "Notizzettel2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -704,
        464
      ],
      "parameters": {
        "color": 5,
        "width": 512,
        "height": 224,
        "content": "## Label Mail"
      },
      "typeVersion": 1
    },
    {
      "id": "7e47b472-0331-4bc5-bba8-bda3f42b4e9e",
      "name": "Notizzettel3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -704,
        720
      ],
      "parameters": {
        "color": 5,
        "width": 512,
        "height": 224,
        "content": "## Label Mail"
      },
      "typeVersion": 1
    },
    {
      "id": "b0c7e415-5528-4387-a029-60486c04b92e",
      "name": "Notizzettel4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -704,
        976
      ],
      "parameters": {
        "color": 5,
        "width": 512,
        "height": 224,
        "content": "## Label Mail"
      },
      "typeVersion": 1
    },
    {
      "id": "da115060-3031-4b1c-8a10-5b0e79334817",
      "name": "Beschwerden-Label",
      "type": "n8n-nodes-base.gmail",
      "position": [
        -608,
        528
      ],
      "webhookId": "fff737dc-0d9b-4611-acb0-de62ede274ea",
      "parameters": {
        "labelIds": [
          "Label_2738167986001899947"
        ],
        "messageId": "={{ $('Gmail Trigger').item.json.id }}",
        "operation": "addLabels"
      },
      "credentials": {
        "gmailOAuth2": {
          "id": "cWqq2EMH5CzPA1AE",
          "name": "Gmail account"
        }
      },
      "typeVersion": 2.1
    },
    {
      "id": "189ecb15-a0dd-427a-9985-f234bcc45ca8",
      "name": "Info-Label",
      "type": "n8n-nodes-base.gmail",
      "position": [
        -608,
        784
      ],
      "webhookId": "8d689704-d3bb-40cb-9fd4-75c4f8bafe2a",
      "parameters": {
        "labelIds": [
          "Label_8719801794646735130"
        ],
        "messageId": "={{ $('Gmail Trigger').item.json.id }}",
        "operation": "addLabels"
      },
      "credentials": {
        "gmailOAuth2": {
          "id": "cWqq2EMH5CzPA1AE",
          "name": "Gmail account"
        }
      },
      "typeVersion": 2.1
    },
    {
      "id": "18a8ab55-c133-4477-92ef-3e8c32ef97c4",
      "name": "Anderes-Label",
      "type": "n8n-nodes-base.gmail",
      "position": [
        -608,
        1040
      ],
      "webhookId": "6e72bf33-af69-4da5-a7b9-c7d6e9634a96",
      "parameters": {
        "labelIds": [
          "UNREAD"
        ],
        "messageId": "={{ $('Gmail Trigger').item.json.id }}",
        "operation": "addLabels"
      },
      "credentials": {
        "gmailOAuth2": {
          "id": "cWqq2EMH5CzPA1AE",
          "name": "Gmail account"
        }
      },
      "typeVersion": 2.1
    },
    {
      "id": "346a2604-416c-4064-9cb1-173d81cd961d",
      "name": "E-Mail-Klassifizierer",
      "type": "@n8n/n8n-nodes-langchain.textClassifier",
      "position": [
        -1184,
        480
      ],
      "parameters": {
        "options": {
          "fallback": "other"
        },
        "inputText": "=Subject: {{ $('Gmail Trigger').item.json.subject }}\nText: {{ $('Gmail Trigger').item.json.text }}",
        "categories": {
          "categories": [
            {
              "category": "support",
              "description": "Emails requesting help, troubleshooting, or guidance regarding products or services. Includes technical issues, user problems, or requests for assistance."
            },
            {
              "category": "sales",
              "description": "Emails expressing interest in products or services, requests for quotes, proposals, or meetings with the sales team. Potential client inquiries fall here."
            },
            {
              "category": "complaints",
              "description": "Emails expressing dissatisfaction, reporting errors, or filing complaints. Includes customer grievances or urgent service issues."
            },
            {
              "category": "information",
              "description": "Emails seeking general information, clarifications, or communication that doesn’t fit Support, Sales, or Complaints."
            }
          ]
        }
      },
      "typeVersion": 1.1
    },
    {
      "id": "bcf2a2b4-2f78-47f3-bd1d-500f3eff0851",
      "name": "Set 2",
      "type": "n8n-nodes-base.set",
      "position": [
        -400,
        528
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "id": "b47eaf61-7201-45b5-993a-cbcfaa5765f7",
              "name": "Decision",
              "type": "string",
              "value": "Compliants"
            }
          ]
        }
      },
      "typeVersion": 3.4
    },
    {
      "id": "f26299b0-795b-46c7-b255-0588a9976f50",
      "name": "Set 3",
      "type": "n8n-nodes-base.set",
      "position": [
        -400,
        784
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "id": "b47eaf61-7201-45b5-993a-cbcfaa5765f7",
              "name": "Decision",
              "type": "string",
              "value": "Info"
            }
          ]
        }
      },
      "typeVersion": 3.4
    },
    {
      "id": "7f458771-5e7f-4fcb-be7d-da4349bda1e6",
      "name": "Set 4",
      "type": "n8n-nodes-base.set",
      "position": [
        -400,
        1040
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "id": "b47eaf61-7201-45b5-993a-cbcfaa5765f7",
              "name": "Decision",
              "type": "string",
              "value": "Other"
            }
          ]
        }
      },
      "typeVersion": 3.4
    },
    {
      "id": "cf5a3309-f478-418a-9ff3-d8dfb7cc3c8c",
      "name": "Notizzettel7",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -464,
        480
      ],
      "parameters": {
        "color": 4,
        "height": 192,
        "content": "## Set the decision"
      },
      "typeVersion": 1
    },
    {
      "id": "6262ee85-fef2-4c99-ac5a-c57b0e5e4fff",
      "name": "Notizzettel8",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -464,
        736
      ],
      "parameters": {
        "color": 4,
        "height": 192,
        "content": "## Set the decision"
      },
      "typeVersion": 1
    },
    {
      "id": "e2abc12a-b6ad-4f15-abc7-13735439ab90",
      "name": "Notizzettel9",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -464,
        992
      ],
      "parameters": {
        "color": 4,
        "height": 192,
        "content": "## Set the decision"
      },
      "typeVersion": 1
    },
    {
      "id": "41e62dfb-3838-499c-984c-e0057030ab4f",
      "name": "Google Sheets2",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        192,
        784
      ],
      "parameters": {
        "columns": {
          "value": {
            "Decision": "={{ $json.Decision }}",
            "Original Email": "=Subject: {{ $('Gmail Trigger').item.json.headers.subject }}\nBody: {{ $('Gmail Trigger').item.json.text }}"
          },
          "schema": [
            {
              "id": "Original Email",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "Original Email",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Decision",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "Decision",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Output Email",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Output Email",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "append",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1SutRXvFjLnnbnakCTNN0O4LqsG-y5nPGDXmipk3EAzE/edit#gid=0",
          "cachedResultName": "Hoja 1"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1SutRXvFjLnnbnakCTNN0O4LqsG-y5nPGDXmipk3EAzE",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1SutRXvFjLnnbnakCTNN0O4LqsG-y5nPGDXmipk3EAzE/edit?usp=drivesdk",
          "cachedResultName": "Log Email Automation"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "gEJv4DaO8m5nfe0p",
          "name": "Google Sheets account"
        }
      },
      "typeVersion": 4.6
    },
    {
      "id": "cc204b45-f8bb-4f07-98f7-52e55f6e79c2",
      "name": "Google Sheets",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        480,
        -48
      ],
      "parameters": {
        "columns": {
          "value": {
            "Decision": "={{ $json.Decision }}",
            "Output Email": "=Subject: {{ $json.Subject_email }}\nBody: {{ $json.Body_email }}",
            "Original Email": "=Subject: {{ $('Gmail Trigger').item.json.headers.subject }}\nBody: {{ $('Gmail Trigger').item.json.text }}"
          },
          "schema": [
            {
              "id": "Original Email",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "Original Email",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Decision",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "Decision",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Output Email",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "Output Email",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "append",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1SutRXvFjLnnbnakCTNN0O4LqsG-y5nPGDXmipk3EAzE/edit#gid=0",
          "cachedResultName": "Hoja 1"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1SutRXvFjLnnbnakCTNN0O4LqsG-y5nPGDXmipk3EAzE",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1SutRXvFjLnnbnakCTNN0O4LqsG-y5nPGDXmipk3EAzE/edit?usp=drivesdk",
          "cachedResultName": "Log Email Automation"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "gEJv4DaO8m5nfe0p",
          "name": "Google Sheets account"
        }
      },
      "typeVersion": 4.6
    },
    {
      "id": "a4f688e0-5cdb-4454-a344-159add0f83af",
      "name": "Keine Operation, nichts tun",
      "type": "n8n-nodes-base.noOp",
      "position": [
        -48,
        784
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "3210d7da-9a37-47d2-b66f-28f16b9998b2",
      "name": "Keine Operation, nichts tun1",
      "type": "n8n-nodes-base.noOp",
      "position": [
        288,
        -48
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "0a55cbc0-ef79-496f-af1d-d420761a17cb",
      "name": "Notizzettel10",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -704,
        48
      ],
      "parameters": {
        "color": 5,
        "width": 884,
        "height": 392,
        "content": "## Automatic Response Sales"
      },
      "typeVersion": 1
    },
    {
      "id": "67177cb9-e14b-438b-91b0-af64395dde65",
      "name": "Notizzettel11",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -704,
        -352
      ],
      "parameters": {
        "color": 5,
        "width": 884,
        "height": 376,
        "content": "## Automatic Response Support"
      },
      "typeVersion": 1
    },
    {
      "id": "635385df-9465-42ee-8e86-8996d1fe33d2",
      "name": "Notizzettel12",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -128,
        64
      ],
      "parameters": {
        "color": 4,
        "height": 240,
        "content": "## Set the decision"
      },
      "typeVersion": 1
    },
    {
      "id": "bb0f23e1-caa2-4a3c-843d-c753d05af101",
      "name": "Notizzettel13",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -128,
        -336
      ],
      "parameters": {
        "color": 4,
        "height": 240,
        "content": "## Set the decision"
      },
      "typeVersion": 1
    },
    {
      "id": "e81d3f4d-b225-478e-9f85-0ed9064dcad1",
      "name": "Label zu Thread hinzufügen",
      "type": "n8n-nodes-base.gmail",
      "position": [
        -288,
        288
      ],
      "webhookId": "387c376b-2719-444a-89c3-c0e3473586c1",
      "parameters": {
        "labelIds": [
          "Label_3720213495654917937"
        ],
        "resource": "thread",
        "threadId": "={{ $('Gmail Trigger').item.json.threadId }}",
        "operation": "addLabels"
      },
      "credentials": {
        "gmailOAuth2": {
          "id": "cWqq2EMH5CzPA1AE",
          "name": "Gmail account"
        }
      },
      "typeVersion": 2.1
    },
    {
      "id": "8b549ecf-6957-4789-9353-379f3fb35b38",
      "name": "Entwurf erstellen: Vertrieb",
      "type": "n8n-nodes-base.gmail",
      "position": [
        -288,
        128
      ],
      "webhookId": "f5d02136-1293-468a-8fcf-b7ada04051a8",
      "parameters": {
        "message": "={{ $json.message.content.Body }}",
        "options": {
          "sendTo": "={{ $('Gmail Trigger').item.json.from.value[0].address }}",
          "threadId": "={{ $('Gmail Trigger').item.json.threadId }}"
        },
        "subject": "={{ $json.message.content.Subject }}",
        "resource": "draft"
      },
      "credentials": {
        "gmailOAuth2": {
          "id": "cWqq2EMH5CzPA1AE",
          "name": "Gmail account"
        }
      },
      "typeVersion": 2.1
    },
    {
      "id": "1aec5594-f0a0-41e0-af09-63fbfafc4f1e",
      "name": "Label zu Thread hinzufügen1",
      "type": "n8n-nodes-base.gmail",
      "position": [
        -288,
        -128
      ],
      "webhookId": "a772d53d-e42c-4b5f-bf56-7f7156a75130",
      "parameters": {
        "labelIds": [
          "Label_7294717935753585870"
        ],
        "resource": "thread",
        "threadId": "={{ $('Gmail Trigger').item.json.threadId }}",
        "operation": "addLabels"
      },
      "credentials": {
        "gmailOAuth2": {
          "id": "cWqq2EMH5CzPA1AE",
          "name": "Gmail account"
        }
      },
      "typeVersion": 2.1
    },
    {
      "id": "ebfc12bd-f8bb-4590-b25f-09ab4e9a1fd5",
      "name": "Entwurf erstellen: Support",
      "type": "n8n-nodes-base.gmail",
      "position": [
        -288,
        -288
      ],
      "webhookId": "f5d02136-1293-468a-8fcf-b7ada04051a8",
      "parameters": {
        "message": "={{ $json.message.content.Body }}",
        "options": {
          "sendTo": "={{ $('Gmail Trigger').item.json.from.value[0].address }}",
          "threadId": "={{ $('Gmail Trigger').item.json.threadId }}"
        },
        "subject": "={{ $json.message.content.Subject }}",
        "resource": "draft"
      },
      "credentials": {
        "gmailOAuth2": {
          "id": "cWqq2EMH5CzPA1AE",
          "name": "Gmail account"
        }
      },
      "typeVersion": 2.1
    },
    {
      "id": "bb8c3533-c0a8-47d1-bf4d-834daaa778d3",
      "name": "OpenAI Chat Model",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
      "position": [
        -1184,
        736
      ],
      "parameters": {
        "model": {
          "__rl": true,
          "mode": "id",
          "value": "gpt-4.1-mini"
        },
        "options": {}
      },
      "credentials": {
        "openAiApi": {
          "id": "3yvFVeLWONpgXkMW",
          "name": "OpenRouter Account"
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "91a3f31d-aa81-4df0-967b-b594bcf49513",
      "name": "Nachricht an Modell: Support",
      "type": "@n8n/n8n-nodes-langchain.openAi",
      "position": [
        -608,
        -208
      ],
      "parameters": {
        "modelId": {
          "__rl": true,
          "mode": "id",
          "value": "gpt-4.1-mini"
        },
        "options": {},
        "messages": {
          "values": [
            {
              "content": "=Hemos recibido el siguiente mensaje de {{ $('Gmail Trigger').item.json.headers.from.replace(/^From:\\s*/, '').match(/^(.*?)(?=\\s*<)/)[1] }}:\n\n\"{{ $('Gmail Trigger').item.json.text }}\"\n\nRedacta una respuesta profesional en función del mensaje y esta información.\n"
            },
            {
              "role": "assistant",
              "content": "=You are an AI assistant for a professional company. \nGenerate a polite and concise email reply to a support request. \nThe output must always be in valid JSON with two fields: Subject and Body.\n\nRules:\n- Subject: short and professional, e.g. \"We received your request\".\n- Body: acknowledge receipt, mention that support will contact them shortly, under 80 words.\n- Keep tone professional and friendly.\n- Personalize with the sender's name if available.\n- Do not add anything outside the JSON.\n\nExamples of proper JSON outputs:\n{\n  \"Subject\": \"We received your request\",\n  \"Body\": \"Hi John, thank you for reaching out. Our support team will review your issue and contact you shortly.\"\n}\n{\n  \"Subject\": \"Support request received\",\n  \"Body\": \"Hello Sarah, we’ve received your message. A specialist will contact you soon to assist you.\"\n}\n"
            }
          ]
        },
        "jsonOutput": true
      },
      "credentials": {
        "openAiApi": {
          "id": "3yvFVeLWONpgXkMW",
          "name": "OpenRouter Account"
        }
      },
      "executeOnce": false,
      "retryOnFail": true,
      "typeVersion": 1.8
    },
    {
      "id": "bf409083-7bd8-42ff-a88a-7d0f7f73da69",
      "name": "Nachricht an Modell: Vertrieb",
      "type": "@n8n/n8n-nodes-langchain.openAi",
      "position": [
        -624,
        208
      ],
      "parameters": {
        "modelId": {
          "__rl": true,
          "mode": "id",
          "value": "gpt-4.1-mini"
        },
        "options": {},
        "messages": {
          "values": [
            {
              "content": "=Hemos recibido el siguiente mensaje de {{ $('Gmail Trigger').item.json.headers.from.replace(/^From:\\s*/, '').match(/^(.*?)(?=\\s*<)/)[1] }}:\n\n\"{{ $('Gmail Trigger').item.json.text }}\"\n\nRedacta una respuesta profesional en función del mensaje y esta información.\n"
            },
            {
              "role": "assistant",
              "content": "=You are an AI assistant for a professional company. \nGenerate a polite and concise email reply to a sales inquiry. \nThe output must always be in valid JSON with two fields: Subject and Body.\n\nRules:\n- Subject: short and professional, e.g. \"Thank you for your interest\".\n- Body: thank them for their interest, mention the sales team will get back shortly, under 80 words.\n- Keep tone professional and friendly.\n- Personalize with the sender's name if available.\n- Do not add anything outside the JSON.\n\nExamples of proper JSON outputs:\n{\n  \"Subject\": \"Thank you for your interest\",\n  \"Body\": \"Hi Anna, thank you for your interest in our services. Our sales team will contact you shortly to discuss your needs.\"\n}\n{\n  \"Subject\": \"We appreciate your inquiry\",\n  \"Body\": \"Hello Peter, we appreciate your message. A member of our sales team will reach out soon with more details.\"\n}\n\n"
            }
          ]
        },
        "jsonOutput": true
      },
      "credentials": {
        "openAiApi": {
          "id": "3yvFVeLWONpgXkMW",
          "name": "OpenRouter Account"
        }
      },
      "retryOnFail": true,
      "typeVersion": 1.8
    },
    {
      "id": "639b1fb2-53c4-4231-9347-bc481fc0fc31",
      "name": "Notizzettel",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -704,
        1232
      ],
      "parameters": {
        "color": 3,
        "width": 512,
        "height": 224,
        "content": "## You can add as much as you need"
      },
      "typeVersion": 1
    },
    {
      "id": "84f2f08a-7ff3-4ed1-916e-939ca497a944",
      "name": "Zeile in Tabelle anhängen",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -1168,
        1072
      ],
      "parameters": {
        "columns": {
          "value": {
            "Time": "={{ $now.format('dd-MM-yyyy hh:mm:ss') }}",
            "Workflow ID": "={{ $workflow.id }}",
            "Execution ID": "={{ $execution.id }}",
            "Error Message": "={{ $json.execution.error.message }}",
            "Node with Error": "={{ $json.execution.lastNodeExecuted }}"
          },
          "schema": [
            {
              "id": "Node with Error",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "Node with Error",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Error Message",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "Error Message",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Time",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "Time",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Execution ID",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "Execution ID",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Workflow ID",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "Workflow ID",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [
            "Error"
          ],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "append",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": 390118099,
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1SutRXvFjLnnbnakCTNN0O4LqsG-y5nPGDXmipk3EAzE/edit#gid=390118099",
          "cachedResultName": "Errors"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1SutRXvFjLnnbnakCTNN0O4LqsG-y5nPGDXmipk3EAzE",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1SutRXvFjLnnbnakCTNN0O4LqsG-y5nPGDXmipk3EAzE/edit?usp=drivesdk",
          "cachedResultName": "Log Email Automation"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "gEJv4DaO8m5nfe0p",
          "name": "Google Sheets account"
        }
      },
      "typeVersion": 4.7
    },
    {
      "id": "6b9fa983-ec6c-4a7c-bda7-e922ad9ae19c",
      "name": "Fehler-Trigger",
      "type": "n8n-nodes-base.errorTrigger",
      "position": [
        -1344,
        1072
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "114acc6a-897b-4c73-a596-76f089e93cd0",
      "name": "Set",
      "type": "n8n-nodes-base.set",
      "position": [
        -64,
        -288
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "id": "b47eaf61-7201-45b5-993a-cbcfaa5765f7",
              "name": "Decision",
              "type": "string",
              "value": "Sales"
            },
            {
              "id": "35d39d93-dbfa-43ec-8100-6df72a2874db",
              "name": "Subject_email",
              "type": "string",
              "value": "={{ $('Message a model: Support').item.json.message.content.Subject }}"
            },
            {
              "id": "ed3606d1-16ca-4089-8398-df6490e9e8ad",
              "name": "Body_email",
              "type": "string",
              "value": "={{ $('Message a model: Support').item.json.message.content.Body }}"
            }
          ]
        }
      },
      "typeVersion": 3.4
    },
    {
      "id": "32f8f930-2db3-4d3f-9134-11d40cd2f655",
      "name": "Set 1",
      "type": "n8n-nodes-base.set",
      "position": [
        -64,
        128
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "id": "b47eaf61-7201-45b5-993a-cbcfaa5765f7",
              "name": "Decision",
              "type": "string",
              "value": "Sales"
            },
            {
              "id": "35d39d93-dbfa-43ec-8100-6df72a2874db",
              "name": "Subject_email",
              "type": "string",
              "value": "={{ $('Message a model: Sales').item.json.message.content.Subject }}"
            },
            {
              "id": "ed3606d1-16ca-4089-8398-df6490e9e8ad",
              "name": "Body_email",
              "type": "string",
              "value": "={{ $('Message a model: Sales').item.json.message.content.Body }}"
            }
          ]
        }
      },
      "typeVersion": 3.4
    },
    {
      "id": "28a2c29e-c959-4a2e-ae80-5afec769d8cd",
      "name": "Notizzettel1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -2176,
        48
      ],
      "parameters": {
        "color": 3,
        "width": 688,
        "height": 1328,
        "content": "# Email Automation Workflow\n\n## Overview\n### Automates email classification in Gmail and generates drafts using OpenAI and Google Sheets. Emails are categorized as Support, Sales, Complaints, Information, or Other, labeled accordingly, draft responses are created, and logs and errors are recorded.\n\n---\n\n## Quick Start\n\n1. **Gmail Trigger**  \n   - Detects new emails every minute.\n\n2. **Email Classification**  \n   - Categories: `support`, `sales`, `complaints`, `information`, `other`...\n\n3. **Actions by Category**  \n   - **Support / Sales:** generates Gmail draft with Subject and Body.  \n   - **Complaints / Information / Other:** applies label to the email.\n\n4. **Google Sheets Logging**  \n   - **Logs:** `Original Email`, `Decision`, `Output Email`.  \n   - **Errors:** `Node with Error`, `Error Message`, `Time`, `Execution ID`, `Workflow ID`.  \n   - Make sure nodes reference the correct `documentId` and `sheetName`.\n\n5. **Error Handling**  \n   - `Error Trigger` automatically records workflow errors in the Errors sheet.\n\n---\n\n## Quick Start Checklist\n\n- [ ] Configure Gmail OAuth2 credentials.  \n- [ ] Set up OpenAI credentials for Support and Sales nodes.  \n- [ ] Create Google Sheets with `Logs` and `Errors` sheets and the correct columns.  \n- [ ] Verify `documentId` and `sheetName` in all Sheets nodes.  \n- [ ] Check classification and labeling nodes.  \n- [ ] Test with a sample email to confirm draft creation and logging.\n---\n\nReady to activate: add credentials, check sheet IDs, and test with a sample email.\n"
      },
      "typeVersion": 1
    }
  ],
  "pinData": {},
  "connections": {
    "114acc6a-897b-4c73-a596-76f089e93cd0": {
      "main": [
        [
          {
            "node": "3210d7da-9a37-47d2-b66f-28f16b9998b2",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "32f8f930-2db3-4d3f-9134-11d40cd2f655": {
      "main": [
        [
          {
            "node": "3210d7da-9a37-47d2-b66f-28f16b9998b2",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "bcf2a2b4-2f78-47f3-bd1d-500f3eff0851": {
      "main": [
        [
          {
            "node": "a4f688e0-5cdb-4454-a344-159add0f83af",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "f26299b0-795b-46c7-b255-0588a9976f50": {
      "main": [
        [
          {
            "node": "a4f688e0-5cdb-4454-a344-159add0f83af",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "7f458771-5e7f-4fcb-be7d-da4349bda1e6": {
      "main": [
        [
          {
            "node": "a4f688e0-5cdb-4454-a344-159add0f83af",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "189ecb15-a0dd-427a-9985-f234bcc45ca8": {
      "main": [
        [
          {
            "node": "f26299b0-795b-46c7-b255-0588a9976f50",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "18a8ab55-c133-4477-92ef-3e8c32ef97c4": {
      "main": [
        [
          {
            "node": "7f458771-5e7f-4fcb-be7d-da4349bda1e6",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "6b9fa983-ec6c-4a7c-bda7-e922ad9ae19c": {
      "main": [
        [
          {
            "node": "84f2f08a-7ff3-4ed1-916e-939ca497a944",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "a75f0c4e-9b1e-4f76-81a7-903707c0548a": {
      "main": [
        [
          {
            "node": "346a2604-416c-4064-9cb1-173d81cd961d",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "346a2604-416c-4064-9cb1-173d81cd961d": {
      "main": [
        [
          {
            "node": "91a3f31d-aa81-4df0-967b-b594bcf49513",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "bf409083-7bd8-42ff-a88a-7d0f7f73da69",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "da115060-3031-4b1c-8a10-5b0e79334817",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "189ecb15-a0dd-427a-9985-f234bcc45ca8",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "18a8ab55-c133-4477-92ef-3e8c32ef97c4",
            "type": "main",
            "index": 0
          }
        ],
        [],
        [],
        []
      ]
    },
    "da115060-3031-4b1c-8a10-5b0e79334817": {
      "main": [
        [
          {
            "node": "bcf2a2b4-2f78-47f3-bd1d-500f3eff0851",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "bb8c3533-c0a8-47d1-bf4d-834daaa778d3": {
      "ai_languageModel": [
        [
          {
            "node": "346a2604-416c-4064-9cb1-173d81cd961d",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "e81d3f4d-b225-478e-9f85-0ed9064dcad1": {
      "main": [
        []
      ]
    },
    "8b549ecf-6957-4789-9353-379f3fb35b38": {
      "main": [
        [
          {
            "node": "32f8f930-2db3-4d3f-9134-11d40cd2f655",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "bf409083-7bd8-42ff-a88a-7d0f7f73da69": {
      "main": [
        [
          {
            "node": "8b549ecf-6957-4789-9353-379f3fb35b38",
            "type": "main",
            "index": 0
          },
          {
            "node": "e81d3f4d-b225-478e-9f85-0ed9064dcad1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "ebfc12bd-f8bb-4590-b25f-09ab4e9a1fd5": {
      "main": [
        [
          {
            "node": "114acc6a-897b-4c73-a596-76f089e93cd0",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "91a3f31d-aa81-4df0-967b-b594bcf49513": {
      "main": [
        [
          {
            "node": "1aec5594-f0a0-41e0-af09-63fbfafc4f1e",
            "type": "main",
            "index": 0
          },
          {
            "node": "ebfc12bd-f8bb-4590-b25f-09ab4e9a1fd5",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "a4f688e0-5cdb-4454-a344-159add0f83af": {
      "main": [
        [
          {
            "node": "41e62dfb-3838-499c-984c-e0057030ab4f",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "3210d7da-9a37-47d2-b66f-28f16b9998b2": {
      "main": [
        [
          {
            "node": "cc204b45-f8bb-4f07-98f7-52e55f6e79c2",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}