Geburtstags-E-Mail

Name: Geburtstags-E-Mail
Rating: 4.5 (10 reviews)
Author: Parth Pansuriya

Fortgeschritten

Dies ist ein Personal Productivity, Multimodal AI-Bereich Automatisierungsworkflow mit 7 Nodes. Hauptsächlich werden Gmail, Filter, GoogleSheets, Agent, ScheduleTrigger und andere Nodes verwendet. Automatisierter Geburtstagsgruß mit Google Sheets, OpenRouter GPT-4o und Gmail

Voraussetzungen

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

Verwendete Nodes (7)

OutputParserStructured

Kategorie

Persönliche Produktivität

Multimodales KI

Workflow-Vorschau

Visualisierung der Node-Verbindungen, mit Zoom und Pan

Zeitplan-Trigger

Tabellenzeile(n) abrufen

Filter

KI-Agent

OpenRouter Chat Model

Nachricht senden

Structured Output Parser

React Flow

Workflow exportieren

Kopieren Sie die folgende JSON-Konfiguration und importieren Sie sie in n8n

{
  "id": "ZQemp67V5rZZ1mML",
  "meta": {
    "instanceId": "3c0cf29d975f43cd1ae675c5b54ec26a950ac622e95b2811d37e4ad94e97a7c9",
    "templateCredsSetupCompleted": true
  },
  "name": "Birthday Email",
  "tags": [],
  "nodes": [
    {
      "id": "230640a2-4c18-4f3e-bc7f-c201effe75ec",
      "name": "Zeitplan-Trigger",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        -320,
        -40
      ],
      "parameters": {
        "rule": {
          "interval": [
            {
              "triggerAtHour": 9
            }
          ]
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "4d24e522-849d-44d5-a9f1-ee8fcabc73c2",
      "name": "Tabellenzeile(n) abrufen",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -100,
        -40
      ],
      "parameters": {
        "options": {},
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1fTGWkzIMdq1G3v2R3tRsRWIgEByPBeKsKXIJTcsxWwk/edit#gid=0",
          "cachedResultName": "Sheet1"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1fTGWkzIMdq1G3v2R3tRsRWIgEByPBeKsKXIJTcsxWwk",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1fTGWkzIMdq1G3v2R3tRsRWIgEByPBeKsKXIJTcsxWwk/edit?usp=drivesdk",
          "cachedResultName": "Birthday"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "dZOb628RKGGKfM5Y",
          "name": "Google Sheets account"
        }
      },
      "typeVersion": 4.6
    },
    {
      "id": "c385dff5-57ad-424d-8579-ee4916024f7c",
      "name": "Filter",
      "type": "n8n-nodes-base.filter",
      "position": [
        120,
        -40
      ],
      "parameters": {
        "options": {},
        "conditions": {
          "options": {
            "version": 2,
            "leftValue": "",
            "caseSensitive": true,
            "typeValidation": "strict"
          },
          "combinator": "and",
          "conditions": [
            {
              "id": "f264376f-683f-40e4-bdc2-05ced56f3b3b",
              "operator": {
                "type": "dateTime",
                "operation": "equals"
              },
              "leftValue": "={{ $json.DOB.split('/').slice(0,2).join('-')}}\n",
              "rightValue": "={{ $now.toFormat(\"dd-MM\") }}"
            }
          ]
        }
      },
      "typeVersion": 2.2
    },
    {
      "id": "ea549cc4-e261-4a76-b17e-f70e85604b4e",
      "name": "KI-Agent",
      "type": "@n8n/n8n-nodes-langchain.agent",
      "position": [
        340,
        -40
      ],
      "parameters": {
        "text": "=use below name for birthday wishes.\n\nname:{{ $json.name }}\ndob:{{ $json.DOB }}\n\nwrite email according to you and best regards by parth.",
        "options": {
          "systemMessage": "You are an assistant that writes warm and personalized birthday emails. Use the user’s name to begin the email. Keep it short, friendly, and positive. Add one emoji. End with best wishes and the sender’s name.\n\n"
        },
        "promptType": "define",
        "hasOutputParser": true
      },
      "typeVersion": 2
    },
    {
      "id": "97c2ee5a-1379-4c3e-af3e-fc0f4e2b7340",
      "name": "OpenRouter Chat Model",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenRouter",
      "position": [
        340,
        160
      ],
      "parameters": {
        "model": "openai/gpt-4o-mini",
        "options": {}
      },
      "credentials": {
        "openRouterApi": {
          "id": "3HWEqzb7DMBfwJtm",
          "name": "OpenRouter account"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "73d4c61e-90bb-498c-b3bb-f0cff5852261",
      "name": "Nachricht senden",
      "type": "n8n-nodes-base.gmail",
      "position": [
        700,
        -40
      ],
      "webhookId": "bbab1b21-b192-4909-91a6-b0d4832ea688",
      "parameters": {
        "sendTo": "={{ $('Filter').item.json.EMail }}",
        "message": "={{ $json.output.body }}",
        "options": {
          "appendAttribution": false
        },
        "subject": "={{ $json.output.subject }}",
        "emailType": "text"
      },
      "credentials": {
        "gmailOAuth2": {
          "id": "3nL9vfgky2oj8US7",
          "name": "Gmail account"
        }
      },
      "typeVersion": 2.1
    },
    {
      "id": "08230bd2-a4e5-46ee-9577-fa78cd01f925",
      "name": "Structured Output Parser",
      "type": "@n8n/n8n-nodes-langchain.outputParserStructured",
      "position": [
        500,
        160
      ],
      "parameters": {
        "jsonSchemaExample": "{\n\"subject\": \"Happy Birthday, Keyur! 🎉\",\n\"body\" :\"Dear Keyur,\\n\\nHappy Birthday! I hope your special day ... \\nParth\"\n\n\n}"
      },
      "typeVersion": 1.3
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "8317f9c1-21c4-4fee-8236-c9dd54bcbb04",
  "connections": {
    "c385dff5-57ad-424d-8579-ee4916024f7c": {
      "main": [
        [
          {
            "node": "ea549cc4-e261-4a76-b17e-f70e85604b4e",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "ea549cc4-e261-4a76-b17e-f70e85604b4e": {
      "main": [
        [
          {
            "node": "73d4c61e-90bb-498c-b3bb-f0cff5852261",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "230640a2-4c18-4f3e-bc7f-c201effe75ec": {
      "main": [
        [
          {
            "node": "4d24e522-849d-44d5-a9f1-ee8fcabc73c2",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "4d24e522-849d-44d5-a9f1-ee8fcabc73c2": {
      "main": [
        [
          {
            "node": "c385dff5-57ad-424d-8579-ee4916024f7c",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "97c2ee5a-1379-4c3e-af3e-fc0f4e2b7340": {
      "ai_languageModel": [
        [
          {
            "node": "ea549cc4-e261-4a76-b17e-f70e85604b4e",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "08230bd2-a4e5-46ee-9577-fa78cd01f925": {
      "ai_outputParser": [
        [
          {
            "node": "ea549cc4-e261-4a76-b17e-f70e85604b4e",
            "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 - Persönliche Produktivität, 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.