生日邮件
中级
这是一个Personal Productivity, Multimodal AI领域的自动化工作流，包含 7 个节点。主要使用 Gmail, Filter, GoogleSheets, Agent, ScheduleTrigger 等节点。 使用Google Sheets、OpenRouter GPT-4o和Gmail的自动化生日邮件
前置要求
- •Google 账号和 Gmail API 凭证
- •Google Sheets API 凭证
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"id": "ZQemp67V5rZZ1mML",
"meta": {
"instanceId": "3c0cf29d975f43cd1ae675c5b54ec26a950ac622e95b2811d37e4ad94e97a7c9",
"templateCredsSetupCompleted": true
},
"name": "生日邮件",
"tags": [],
"nodes": [
{
"id": "230640a2-4c18-4f3e-bc7f-c201effe75ec",
"name": "定时触发器",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
-320,
-40
],
"parameters": {
"rule": {
"interval": [
{
"triggerAtHour": 9
}
]
}
},
"typeVersion": 1.2
},
{
"id": "4d24e522-849d-44d5-a9f1-ee8fcabc73c2",
"name": "获取表格中的行",
"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": "筛选",
"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": "AI 代理",
"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聊天模型",
"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": "发送消息",
"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": "结构化输出解析器",
"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": {
"Filter": {
"main": [
[
{
"node": "AI Agent",
"type": "main",
"index": 0
}
]
]
},
"AI Agent": {
"main": [
[
{
"node": "Send a message",
"type": "main",
"index": 0
}
]
]
},
"Schedule Trigger": {
"main": [
[
{
"node": "Get row(s) in sheet",
"type": "main",
"index": 0
}
]
]
},
"Get row(s) in sheet": {
"main": [
[
{
"node": "Filter",
"type": "main",
"index": 0
}
]
]
},
"OpenRouter Chat Model": {
"ai_languageModel": [
[
{
"node": "AI Agent",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Structured Output Parser": {
"ai_outputParser": [
[
{
"node": "AI Agent",
"type": "ai_outputParser",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
中级 - 个人效率, 多模态 AI
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
来自多个招聘网站的求职自动化
使用 5 个招聘平台和 AI 简历生成器自动化求职与申请
If
Set
Code
+14
34 节点Gerald Denor
个人效率
邮件摘要
通过 Gmail 和 OpenRouter 的 GPT-3.5 生成自动化每日邮件摘要
Code
Gmail
Aggregate
+4
8 节点Parth Pansuriya
个人效率
从 Stripe 支付自动交付模板给客户
使用Stripe、GPT-4o和Gmail的自动化模板交付系统
If
Code
Gmail
+12
44 节点Rahul Joshi
客户关系管理
LinkedIn和X病毒内容自动引擎
使用AI生成和发布自动创建LinkedIn和X的病毒内容
If
Set
Wait
+26
156 节点Diptamoy Barman
内容创作
使用Gemini、Slack和Notion从新闻简报创建AI情报摘要
使用Gemini、Slack和Notion从新闻简报创建AI情报摘要
Set
Code
Gmail
+12
19 节点Harry Siggins
杂项
每日生日庆祝（代码节点最终版本）
基于NASA图片、GPT-4、Gmail和Slack的自动化太空主题生日邮件
If
Code
Gmail
+7
17 节点Yanagi Chinatsu
个人效率
工作流信息
难度等级
中级
节点数量7
分类2
节点类型7
作者
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.
外部链接
在 n8n.io 查看 →
分享此工作流