Emails d'anniversaire
Ceci est unPersonal Productivity, Multimodal AIworkflow d'automatisation du domainecontenant 7 nœuds.Utilise principalement des nœuds comme Gmail, Filter, GoogleSheets, Agent, ScheduleTrigger. Emails d'anniversaire automatisés, en utilisant Google Sheets, OpenRouter GPT-4o et Gmail
- •Compte Google et informations d'identification Gmail API
- •Informations d'identification Google Sheets API
{
"id": "ZQemp67V5rZZ1mML",
"meta": {
"instanceId": "3c0cf29d975f43cd1ae675c5b54ec26a950ac622e95b2811d37e4ad94e97a7c9",
"templateCredsSetupCompleted": true
},
"name": "Birthday Email",
"tags": [],
"nodes": [
{
"id": "230640a2-4c18-4f3e-bc7f-c201effe75ec",
"name": "Déclencheur programmé",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
-320,
-40
],
"parameters": {
"rule": {
"interval": [
{
"triggerAtHour": 9
}
]
}
},
"typeVersion": 1.2
},
{
"id": "4d24e522-849d-44d5-a9f1-ee8fcabc73c2",
"name": "Obtenir une/des ligne(s) dans la feuille",
"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": "Filtre",
"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": "Agent 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": "Modèle 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": "Envoyer un message",
"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": "Analyseur de sortie structurée",
"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
}
]
]
}
}
}Comment utiliser ce workflow ?
Copiez le code de configuration JSON ci-dessus, créez un nouveau workflow dans votre instance n8n et sélectionnez "Importer depuis le JSON", collez la configuration et modifiez les paramètres d'authentification selon vos besoins.
Dans quelles scénarios ce workflow est-il adapté ?
Intermédiaire - Productivité personnelle, IA Multimodale
Est-ce payant ?
Ce workflow est entièrement gratuit et peut être utilisé directement. Veuillez noter que les services tiers utilisés dans le workflow (comme l'API OpenAI) peuvent nécessiter un paiement de votre part.
Workflows recommandés
Parth Pansuriya
@parthpansuriyaI build smart and scalable automation workflows using n8n to simplify tasks, connect apps, and boost productivity. From WhatsApp bots to AI-powered systems, I create seamless automations tailored for business and creators.
Partager ce workflow