Google 日历到 Sheets 模板 v1.0
高级
这是一个IT Ops领域的自动化工作流，包含 20 个节点。主要使用 If, Set, Code, Wait, Switch 等节点。 自动将 Google 日历事件同步到 Google Sheets 跟踪器
前置要求
- •可能需要目标 API 的认证凭证
- •Google Sheets API 凭证
分类
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"id": "tpJVuoH0Z7kyiXZH",
"meta": {
"instanceId": "3f5dc502ba8ad809ce92e2700eacbfc6e18a9b581bf97a1f829d453fba1ca472",
"templateCredsSetupCompleted": true
},
"name": "google-calendar-shees-template-v1.0",
"tags": [],
"nodes": [
{
"id": "e7d2f6c5-9d54-496b-83ff-1d22e6782c43",
"name": "计划触发器1",
"type": "n8n-nodes-base.scheduleTrigger",
"notes": "Every 1 min",
"position": [
4040,
1320
],
"parameters": {},
"notesInFlow": true,
"typeVersion": 1.2
},
{
"id": "834ec869-a81e-4d28-b9d5-9dc81d4cece6",
"name": "获取事件1",
"type": "n8n-nodes-base.googleCalendar",
"notes": "Get events",
"position": [
4460,
1320
],
"parameters": {},
"notesInFlow": true,
"typeVersion": 1.3
},
{
"id": "5ee267ed-5b2a-4bd3-a4e6-f8d101433892",
"name": "检查空事件1",
"type": "n8n-nodes-base.if",
"position": [
4700,
1320
],
"parameters": {},
"typeVersion": 2.2,
"alwaysOutputData": true
},
{
"id": "404884b7-8b8d-405d-a6dd-27217f2c6ac4",
"name": "遍历事件与行1",
"type": "n8n-nodes-base.splitInBatches",
"notes": "Loop over",
"position": [
5160,
1340
],
"parameters": {},
"typeVersion": 3
},
{
"id": "9355e33a-109c-41d2-abec-559ebbf97758",
"name": "获取行1",
"type": "n8n-nodes-base.googleSheets",
"notes": "Get rows",
"onError": "continueRegularOutput",
"position": [
5420,
1440
],
"parameters": {},
"executeOnce": true,
"notesInFlow": true,
"retryOnFail": false,
"typeVersion": 4.6,
"alwaysOutputData": true
},
{
"id": "d57d6abc-af73-41b7-8e3d-c4346d934171",
"name": "匹配事件与行1",
"type": "n8n-nodes-base.code",
"notes": "Check event against sheet",
"position": [
5800,
1320
],
"parameters": {},
"notesInFlow": true,
"typeVersion": 2,
"alwaysOutputData": false
},
{
"id": "d587e1c9-b04d-417f-b155-847df5ac83cb",
"name": "检查匹配1",
"type": "n8n-nodes-base.if",
"notes": "true -> update; false -> add to sheet",
"position": [
6040,
1320
],
"parameters": {},
"notesInFlow": true,
"typeVersion": 2.2
},
{
"id": "48c435fb-df81-44a4-ad55-8cf7db844b76",
"name": "更新表格1",
"type": "n8n-nodes-base.googleSheets",
"notes": "Update rows in sheet",
"position": [
6340,
1300
],
"parameters": {},
"notesInFlow": true,
"typeVersion": 4.6
},
{
"id": "04e8f9f2-0c1c-4a2b-83a6-5bf9a9d14943",
"name": "便签9",
"type": "n8n-nodes-base.stickyNote",
"position": [
4320,
1500
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "fcc2f4e1-06bc-4c4a-99b9-1efd869644d5",
"name": "便签10",
"type": "n8n-nodes-base.stickyNote",
"position": [
4320,
1220
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "66e8c77d-d12b-41ae-a631-bf603687562e",
"name": "便签11",
"type": "n8n-nodes-base.stickyNote",
"position": [
3960,
1260
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "f978e8f1-0f29-44c3-8e99-4422b5dba01c",
"name": "便签12",
"type": "n8n-nodes-base.stickyNote",
"position": [
3960,
1500
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "c4929ab1-873d-41d5-8a0d-ff4cc96c2d90",
"name": "便签13",
"type": "n8n-nodes-base.stickyNote",
"position": [
5040,
1220
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "fdf237ab-5851-472f-92e5-11fa41f53555",
"name": "便签14",
"type": "n8n-nodes-base.stickyNote",
"position": [
5040,
1680
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "21ee9327-52b6-48b0-b756-ca125c6ed697",
"name": "便签15",
"type": "n8n-nodes-base.stickyNote",
"position": [
5700,
1220
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "fa732d6e-36a9-4604-90ef-38bc467c6d5a",
"name": "便签16",
"type": "n8n-nodes-base.stickyNote",
"position": [
5700,
1680
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "ff657f6f-9da2-4c1a-8fc6-89dd8a6c8efa",
"name": "添加到表格1",
"type": "n8n-nodes-base.googleSheets",
"notes": "Add rows to sheet",
"position": [
6340,
1480
],
"parameters": {},
"notesInFlow": true,
"typeVersion": 4.6
},
{
"id": "b3c2f7df-409a-4699-a48b-9a1bf1c227fb",
"name": "便签17",
"type": "n8n-nodes-base.stickyNote",
"position": [
3940,
1040
],
"parameters": {
"content": ""
},
"typeVersion": 1
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "1a845fb1-74c7-4d0f-9c1b-a11d7174fd55",
"connections": {
"Get Rows1": {
"main": [
[
{
"node": "Loop Over Events & Rows1",
"type": "main",
"index": 0
}
]
]
},
"Get Events1": {
"main": [
[
{
"node": "Check for Empty Events1",
"type": "main",
"index": 0
}
]
]
},
"Check for Match1": {
"main": [
[
{
"node": "Update Sheet1",
"type": "main",
"index": 0
}
],
[
{
"node": "Add to Sheet1",
"type": "main",
"index": 0
}
]
]
},
"Schedule Trigger1": {
"main": [
[
{
"node": "Get Events1",
"type": "main",
"index": 0
}
]
]
},
"Match Events vs Rows1": {
"main": [
[
{
"node": "Check for Match1",
"type": "main",
"index": 0
}
]
]
},
"Check for Empty Events1": {
"main": [
[],
[
{
"node": "Loop Over Events & Rows1",
"type": "main",
"index": 0
}
]
]
},
"Loop Over Events & Rows1": {
"main": [
[
{
"node": "Match Events vs Rows1",
"type": "main",
"index": 0
}
],
[
{
"node": "Get Rows1",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
高级 - IT 运维
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
↔️ Airtable批量处理
Airtable批量更新/插入行（发送更快+节省API调用请求）
If
Set
Code
+12
35 节点Simon Mayerhofer
IT 运维
Facebook页面评论管理机器人：回复、删除、封禁和通知
AI驱动的Facebook评论管理：自动回复、删除、封禁和通知
If
Set
Code
+18
59 节点SpaGreen Creative
社交媒体
API架构提取器
API架构提取器
If
Set
Code
+22
88 节点Polina Medvedieva
工程
潜在客户开发与邮件工作流
使用Google Maps、SendGrid和AI自动化B2B潜在客户开发与邮件营销
If
Set
Code
+21
141 节点Ezema Kingsley Chibuzo
潜在客户开发
Gemini_NanoBanana_模板
使用 Fal.ai 模型（nano-banana、WAN2.2、Veo3）从 Google Sheets 生成 UGC 广告
If
Set
Code
+13
36 节点Jaruphat J.
内容创作
（Duc）深度研究市场模板
集成PerplexityAI研究和OpenAI内容的多层级WordPress博客生成器
If
Set
Xml
+28
132 节点Daniel Ng
人工智能
