Correo de cumpleaños

• •Cuenta de Google y credenciales de API de Gmail
• •Credenciales de API de Google Sheets

{
  "id": "ZQemp67V5rZZ1mML",
  "meta": {
    "instanceId": "3c0cf29d975f43cd1ae675c5b54ec26a950ac622e95b2811d37e4ad94e97a7c9",
    "templateCredsSetupCompleted": true
  },
  "name": "Birthday Email",
  "tags": [],
  "nodes": [
    {
      "id": "230640a2-4c18-4f3e-bc7f-c201effe75ec",
      "name": "Disparador Programado",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        -320,
        -40
      ],
      "parameters": {
        "rule": {
          "interval": [
            {
              "triggerAtHour": 9
            }
          ]
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "4d24e522-849d-44d5-a9f1-ee8fcabc73c2",
      "name": "Obtener fila(s) en hoja",
      "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": "Filtro",
      "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": "Agentee de IA",
      "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": "Modelo de Chat OpenRouter",
      "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": "Enviar un mensaje",
      "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": "Analizador de Salida Estructurada",
      "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": "Agente de IA",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Agente de IA": {
      "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": "Agente de IA",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "08230bd2-a4e5-46ee-9577-fa78cd01f925": {
      "ai_outputParser": [
        [
          {
            "node": "Agente de IA",
            "type": "ai_outputParser",
            "index": 0
          }
        ]
      ]
    }
  }
}