具有多日历路由的双向 ClickUp 任务与 Google 日历同步
高级
这是一个Project Management, Multimodal AI领域的自动化工作流，包含 69 个节点。主要使用 If, Set, Merge, Switch, ClickUp 等节点。 具有多日历路由的双向 ClickUp 任务与 Google 日历同步
前置要求
- •Google Sheets API 凭证
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"meta": {
"instanceId": "6d95cfcfdb5941832863c02ceb9fcbd0e7cde6400b76244f830811247606f9a4",
"templateCredsSetupCompleted": true
},
"nodes": [
{
"id": "20ed9153-7d1e-4ee6-b143-7b3a6d19a1a9",
"name": "配置",
"type": "n8n-nodes-base.set",
"position": [
-2928,
-1232
],
"parameters": {
"values": {
"string": [
{
"name": "calendarId_personal",
"value": "REPLACE_WITH_CALENDAR_ID_PERSONAL"
},
{
"name": "calendarId_faculdade",
"value": "REPLACE_WITH_CALENDAR_ID_FACULDADE"
},
{
"name": "calendarId_tech",
"value": "REPLACE_WITH_CALENDAR_ID_TECH"
},
{
"name": "calendarId_internship",
"value": "REPLACE_WITH_CALENDAR_ID_INTERNSHIP"
},
{
"name": "sheetId",
"value": "REPLACE_WITH_GOOGLE_SHEET_ID"
},
{
"name": "sheetTabName",
"value": "Sheet1"
},
{
"name": "clickupTeamId",
"value": "REPLACE_WITH_CLICKUP_TEAM_ID"
}
]
},
"options": {}
},
"typeVersion": 2
},
{
"id": "cd38f33f-558e-44d0-b24a-29a43ca8b154",
"name": "模板说明",
"type": "n8n-nodes-base.stickyNote",
"position": [
-2848,
-2736
],
"parameters": {
"color": "yellow",
"width": 736,
"height": 352,
"content": "## 模板说明"
},
"typeVersion": 1
},
{
"id": "84da75ab-7ee8-4d52-9e0d-44dc34169966",
"name": "条件判断",
"type": "n8n-nodes-base.if",
"position": [
-960,
-608
],
"parameters": {
"options": {},
"conditions": {
"options": {
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "f08129c7-f807-4915-9012-020c59db3629",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $('ClickUp1').item.json.name }}",
"rightValue": "={{ $json.summary }}"
}
]
}
},
"typeVersion": 2
},
{
"id": "9b41f66e-cc7d-483a-b745-c7c9a27c4c9e",
"name": "编辑字段",
"type": "n8n-nodes-base.set",
"position": [
-1584,
-848
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "b4829e73-6371-4b21-a3ce-20ea12ef9af6",
"name": "=calendarId",
"type": "string",
"value": "={ $('Configuration').item.json.calendarId_personal }"
}
]
}
},
"typeVersion": 3.3
},
{
"id": "ecbda93c-aafb-4296-b509-e631f95426e7",
"name": "编辑字段1",
"type": "n8n-nodes-base.set",
"position": [
-1584,
-688
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "c4fef53c-c53b-459a-b146-ad830be3e64e",
"name": "=calendarId",
"type": "string",
"value": "={ $('Configuration').item.json.calendarId_faculdade }"
}
]
}
},
"typeVersion": 3.3
},
{
"id": "4d69f341-76ae-48d7-9102-b632e891b4c3",
"name": "编辑字段2",
"type": "n8n-nodes-base.set",
"position": [
-1584,
-528
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "65a4f977-cf4f-40a0-9ad8-ef43f4624f30",
"name": "=calendarId",
"type": "string",
"value": "={ $('Configuration').item.json.calendarId_tech }"
}
]
}
},
"typeVersion": 3.3
},
{
"id": "d2015b06-e8a1-4102-b69a-a0b81b037d59",
"name": "编辑字段3",
"type": "n8n-nodes-base.set",
"position": [
-1584,
-368
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "f5b6173d-9d8c-4580-9afd-cbdabf4d167b",
"name": "=calendarId",
"type": "string",
"value": "={ $('Configuration').item.json.calendarId_internship }"
}
]
}
},
"typeVersion": 3.3
},
{
"id": "36a6d773-4c41-4ed3-8e8c-b3ae391d781d",
"name": "Google Calendar9",
"type": "n8n-nodes-base.googleCalendar",
"position": [
-1168,
-608
],
"parameters": {
"limit": 3,
"options": {
"query": "={{ $('ClickUp1').item.json.name }}",
"updatedMin": "={{ $now.minus(5, 'minutes') }}",
"showDeleted": "=false"
},
"calendar": {
"__rl": true,
"mode": "id",
"value": "={{ $json.calendarId }}"
},
"operation": "getAll"
},
"typeVersion": 1.1,
"alwaysOutputData": true
},
{
"id": "d001b4f7-d57b-42e3-9b56-ba50d8cc14cf",
"name": "Google Calendar10",
"type": "n8n-nodes-base.googleCalendar",
"position": [
-704,
-560
],
"parameters": {
"end": "={{ DateTime.fromMillis(Number($('ClickUp1').item.json.due_date)).format(\"yyyy-MM-dd HH:mm:ss\") }}",
"start": "={{ DateTime.fromMillis(Number($('ClickUp1').item.json.start_date)).format(\"yyyy-MM-dd HH:mm:ss\") }}",
"calendar": {
"__rl": true,
"mode": "id",
"value": "={{ $('Edit Fields4').item.json.calendarId }}"
},
"additionalFields": {
"color": "8",
"summary": "={{ $('ClickUp1').item.json.name }}",
"description": "={{ $('ClickUp1').item.json.description }}"
}
},
"typeVersion": 1.1
},
{
"id": "4fe511d7-bc1f-48db-b5cb-87b20084b9d7",
"name": "编辑字段4",
"type": "n8n-nodes-base.set",
"position": [
-1344,
-608
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "d9632eeb-f464-40ac-a4de-d539783f1812",
"name": "=calendarId",
"type": "string",
"value": "={{ $json.calendarId }}"
}
]
}
},
"typeVersion": 3.3
},
{
"id": "b2fa5a19-d39f-4dca-ae22-1dfcf250428f",
"name": "Google Sheets",
"type": "n8n-nodes-base.googleSheets",
"position": [
-448,
-560
],
"parameters": {
"columns": {
"value": {
"eventName": "={{ $json.summary }}",
"clickupTaskId": "={{ $('ClickUp1').item.json.id }}",
"calendarEventId": "={{ $json.id }}"
},
"schema": [
{
"id": "clickupTaskId",
"type": "string",
"display": true,
"required": false,
"displayName": "clickupTaskId",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "calendarEventId",
"type": "string",
"display": true,
"required": false,
"displayName": "calendarEventId",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "eventName",
"type": "string",
"display": true,
"required": false,
"displayName": "eventName",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": []
},
"options": {},
"operation": "append",
"sheetName": "={{ $('Configuration').item.json.sheetTabName }}",
"documentId": {
"__rl": true,
"mode": "id",
"value": "={{ $('Configuration').item.json.sheetId }}"
}
},
"typeVersion": 4.3
},
{
"id": "b02fb4a7-8837-4400-837f-3f7c417f3c15",
"name": "编辑字段6",
"type": "n8n-nodes-base.set",
"position": [
-1520,
48
],
"parameters": {
"options": {}
},
"typeVersion": 3.3
},
{
"id": "4348308e-562b-40bb-a937-8770c8183063",
"name": "Google Sheets2",
"type": "n8n-nodes-base.googleSheets",
"position": [
-2256,
16
],
"parameters": {
"options": {},
"filtersUI": {
"values": [
{
"lookupValue": "={{ $json.task_id }}",
"lookupColumn": "clickupTaskId"
}
]
},
"sheetName": "={{ $('Configuration').item.json.sheetTabName }}",
"documentId": {
"__rl": true,
"mode": "id",
"value": "={{ $('Configuration').item.json.sheetId }}"
}
},
"typeVersion": 4.3
},
{
"id": "3a56d432-9dce-4090-8e17-df85c0423a1a",
"name": "Google Calendar11",
"type": "n8n-nodes-base.googleCalendar",
"onError": "continueErrorOutput",
"position": [
-1776,
-208
],
"parameters": {
"eventId": "={{ $json.calendarEventId }}",
"options": {},
"calendar": {
"__rl": true,
"mode": "id",
"value": "={ $('Configuration').item.json.calendarId_personal }"
},
"operation": "delete"
},
"typeVersion": 1.1
},
{
"id": "a848b922-d921-42cd-a853-f591b6ef7d7a",
"name": "Google Calendar12",
"type": "n8n-nodes-base.googleCalendar",
"onError": "continueErrorOutput",
"position": [
-1776,
-32
],
"parameters": {
"eventId": "={{ $json.calendarEventId }}",
"options": {},
"calendar": {
"__rl": true,
"mode": "id",
"value": "={ $('Configuration').item.json.calendarId_faculdade }"
},
"operation": "delete"
},
"typeVersion": 1.1
},
{
"id": "c7793651-a774-489d-8452-bb3ad630c409",
"name": "Google Calendar13",
"type": "n8n-nodes-base.googleCalendar",
"onError": "continueErrorOutput",
"position": [
-1776,
160
],
"parameters": {
"eventId": "={{ $json.calendarEventId }}",
"options": {},
"calendar": {
"__rl": true,
"mode": "id",
"value": "={ $('Configuration').item.json.calendarId_tech }"
},
"operation": "delete"
},
"typeVersion": 1.1
},
{
"id": "36491add-4ccd-4a8a-8847-554439dc143a",
"name": "Google Calendar14",
"type": "n8n-nodes-base.googleCalendar",
"onError": "continueErrorOutput",
"position": [
-1776,
336
],
"parameters": {
"eventId": "={{ $json.calendarEventId }}",
"options": {},
"calendar": {
"__rl": true,
"mode": "id",
"value": "={ $('Configuration').item.json.calendarId_internship }"
},
"operation": "delete"
},
"typeVersion": 1.1
},
{
"id": "f0468290-d7f2-4b9d-936f-d5d5e533400d",
"name": "ClickUp 触发器",
"type": "n8n-nodes-base.clickUpTrigger",
"position": [
-2768,
-1008
],
"webhookId": "e14c8e52-4dec-4602-b524-57c922b0b859",
"parameters": {
"team": "9013192347",
"events": [
"taskCreated",
"taskDeleted",
"taskUpdated",
"taskDueDateUpdated"
],
"filters": {},
"authentication": "oAuth2"
},
"typeVersion": 1
},
{
"id": "f0a156da-d954-47b2-adbf-c45f1bd75716",
"name": "Google Sheets1",
"type": "n8n-nodes-base.googleSheets",
"position": [
-1280,
48
],
"parameters": {
"operation": "delete",
"sheetName": "={{ $('Configuration').item.json.sheetTabName }}",
"documentId": {
"__rl": true,
"mode": "id",
"value": "={{ $('Configuration').item.json.sheetId }}"
},
"startIndex": "={{ $('Google Sheets2').item.json.row_number }}"
},
"typeVersion": 4.3
},
{
"id": "e607d795-8cd1-4c86-ab4f-69da009e29ad",
"name": "Google Calendar15",
"type": "n8n-nodes-base.googleCalendar",
"position": [
-544,
-1728
],
"parameters": {
"eventId": "={{ $json.id }}",
"calendar": {
"__rl": true,
"mode": "id",
"value": "={{ $json.organizer.email }}"
},
"operation": "update",
"updateFields": {
"end": "={{ DateTime.fromMillis(Number($('ClickUp').item.json.due_date)).format(\"yyyy-MM-dd HH:mm:ss\") }}",
"color": "11",
"start": "={{ DateTime.fromMillis(Number($('ClickUp').item.json.start_date)).format(\"yyyy-MM-dd HH:mm:ss\") }}",
"summary": "={{ $('ClickUp').item.json.name }}",
"description": "={{ $('ClickUp').item.json.description }}"
}
},
"typeVersion": 1.1
},
{
"id": "a9aa8212-0843-4faf-bcff-ae10df26fcf1",
"name": "Google Calendar16",
"type": "n8n-nodes-base.googleCalendar",
"position": [
-544,
-2048
],
"parameters": {
"eventId": "={{ $json.id }}",
"calendar": {
"__rl": true,
"mode": "id",
"value": "={{ $json.organizer.email }}"
},
"operation": "update",
"updateFields": {
"end": "={{ DateTime.fromMillis(Number($('ClickUp').item.json.due_date)).format(\"yyyy-MM-dd HH:mm:ss\") }}",
"color": "6",
"start": "={{ DateTime.fromMillis(Number($('ClickUp').item.json.start_date)).format(\"yyyy-MM-dd HH:mm:ss\") }}",
"summary": "={{ $('ClickUp').item.json.name }}",
"description": "={{ $('ClickUp').item.json.description }}"
}
},
"typeVersion": 1.1
},
{
"id": "02545491-50a9-4cf8-87f6-6857c28015ef",
"name": "Google Calendar17",
"type": "n8n-nodes-base.googleCalendar",
"position": [
-544,
-2368
],
"parameters": {
"eventId": "={{ $json.id }}",
"calendar": {
"__rl": true,
"mode": "id",
"value": "={{ $json.organizer.email }}"
},
"operation": "update",
"updateFields": {
"end": "={{ DateTime.fromMillis(Number($('ClickUp').item.json.due_date)).format(\"yyyy-MM-dd HH:mm:ss\") }}",
"color": "8",
"start": "={{ DateTime.fromMillis(Number($('ClickUp').item.json.start_date)).format(\"yyyy-MM-dd HH:mm:ss\") }}",
"summary": "={{ $('ClickUp').item.json.name }}",
"description": "={{ $('ClickUp').item.json.description }}"
}
},
"typeVersion": 1.1
},
{
"id": "fc5239a0-8724-44ba-9cb6-610c5fccccdc",
"name": "Google Calendar18",
"type": "n8n-nodes-base.googleCalendar",
"position": [
-544,
-1408
],
"parameters": {
"eventId": "={{ $json.id }}",
"calendar": {
"__rl": true,
"mode": "id",
"value": "={{ $json.organizer.email }}"
},
"operation": "update",
"updateFields": {
"end": "={{ DateTime.fromMillis(Number($('ClickUp').item.json.due_date)).format(\"yyyy-MM-dd HH:mm:ss\") }}",
"color": "8",
"start": "={{ DateTime.fromMillis(Number($('ClickUp').item.json.start_date)).format(\"yyyy-MM-dd HH:mm:ss\") }}",
"summary": "={{ $('ClickUp').item.json.name }}",
"description": "={{ $('ClickUp').item.json.description }}"
}
},
"typeVersion": 1.1
},
{
"id": "4170edaa-e3a8-4384-83fd-46e3c9e4c0ba",
"name": "Google Calendar19",
"type": "n8n-nodes-base.googleCalendar",
"position": [
-544,
-1088
],
"parameters": {
"eventId": "={{ $json.id }}",
"calendar": {
"__rl": true,
"mode": "id",
"value": "={{ $json.organizer.email }}"
},
"operation": "update",
"updateFields": {
"end": "={{ DateTime.fromMillis(Number($('ClickUp').item.json.due_date)).format(\"yyyy-MM-dd HH:mm:ss\") }}",
"color": "10",
"start": "={{ DateTime.fromMillis(Number($('ClickUp').item.json.start_date)).format(\"yyyy-MM-dd HH:mm:ss\") }}",
"summary": "={{ $('ClickUp').item.json.name }}",
"description": "={{ $('ClickUp').item.json.description }}"
}
},
"typeVersion": 1.1
},
{
"id": "5f041605-4e26-481f-a49c-3cff35e2d951",
"name": "Google Sheets3",
"type": "n8n-nodes-base.googleSheets",
"position": [
-80,
-1808
],
"parameters": {
"columns": {
"value": {
"eventName": "={{ $json.summary }}",
"clickupTaskId": "={{ $('ClickUp').item.json.id }}"
},
"schema": [
{
"id": "clickupTaskId",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "clickupTaskId",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "calendarEventId",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "calendarEventId",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "eventName",
"type": "string",
"display": true,
"required": false,
"displayName": "eventName",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"clickupTaskId"
]
},
"options": {},
"operation": "update",
"sheetName": "={{ $('Configuration').item.json.sheetTabName }}",
"documentId": {
"__rl": true,
"mode": "id",
"value": "={{ $('Configuration').item.json.sheetId }}"
}
},
"typeVersion": 4.3
},
{
"id": "da7f0537-12b8-41c5-b773-0c2c64386f0f",
"name": "Google Sheets4",
"type": "n8n-nodes-base.googleSheets",
"position": [
-1792,
-1584
],
"parameters": {
"options": {},
"filtersUI": {
"values": [
{
"lookupValue": "={{ $json.id }}",
"lookupColumn": "clickupTaskId"
}
]
},
"sheetName": "={{ $('Configuration').item.json.sheetTabName }}",
"documentId": {
"__rl": true,
"mode": "id",
"value": "={{ $('Configuration').item.json.sheetId }}"
}
},
"typeVersion": 4.3,
"alwaysOutputData": true
},
{
"id": "18931529-3468-4cdf-b963-5dfedd2bcbe3",
"name": "Google Sheets5",
"type": "n8n-nodes-base.googleSheets",
"position": [
-1792,
-1408
],
"parameters": {
"options": {},
"filtersUI": {
"values": [
{
"lookupValue": "={{ $json.id }}",
"lookupColumn": "clickupTaskId"
}
]
},
"sheetName": "={{ $('Configuration').item.json.sheetTabName }}",
"documentId": {
"__rl": true,
"mode": "id",
"value": "={{ $('Configuration').item.json.sheetId }}"
}
},
"typeVersion": 4.3,
"alwaysOutputData": true
},
{
"id": "9d475773-2b7e-44cc-9a98-867bdbea1c1e",
"name": "Google Sheets6",
"type": "n8n-nodes-base.googleSheets",
"position": [
-1792,
-1200
],
"parameters": {
"options": {},
"filtersUI": {
"values": [
{
"lookupValue": "={{ $json.id }}",
"lookupColumn": "clickupTaskId"
}
]
},
"sheetName": "={{ $('Configuration').item.json.sheetTabName }}",
"documentId": {
"__rl": true,
"mode": "id",
"value": "={{ $('Configuration').item.json.sheetId }}"
}
},
"typeVersion": 4.3,
"alwaysOutputData": true
},
{
"id": "55537f6d-2eea-4948-b471-832aea85403e",
"name": "Google Sheets7",
"type": "n8n-nodes-base.googleSheets",
"position": [
-1792,
-1024
],
"parameters": {
"options": {},
"filtersUI": {
"values": [
{
"lookupValue": "={{ $json.id }}",
"lookupColumn": "clickupTaskId"
}
]
},
"sheetName": "={{ $('Configuration').item.json.sheetTabName }}",
"documentId": {
"__rl": true,
"mode": "id",
"value": "={{ $('Configuration').item.json.sheetId }}"
}
},
"typeVersion": 4.3,
"alwaysOutputData": true
},
{
"id": "59ec74c7-8378-4483-b497-740fee0c9dda",
"name": "if_allDayEvent3",
"type": "n8n-nodes-base.if",
"position": [
-1008,
-2448
],
"parameters": {
"options": {},
"conditions": {
"options": {
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "57af3729-0eaf-4cec-b9aa-de39b74ecc40",
"operator": {
"type": "string",
"operation": "notEmpty",
"singleValue": true
},
"leftValue": "={{ $json.end.date }}",
"rightValue": ""
}
]
}
},
"typeVersion": 2
},
{
"id": "7a099478-1839-4103-b59b-0db36522ed9b",
"name": "if_allDayEvent",
"type": "n8n-nodes-base.if",
"position": [
-1008,
-2128
],
"parameters": {
"options": {},
"conditions": {
"options": {
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "57af3729-0eaf-4cec-b9aa-de39b74ecc40",
"operator": {
"type": "string",
"operation": "notEmpty",
"singleValue": true
},
"leftValue": "={{ $json.end.date }}",
"rightValue": ""
}
]
}
},
"typeVersion": 2
},
{
"id": "ae5b688f-3e55-42c9-90d9-ef2f57527d88",
"name": "if_allDayEvent1",
"type": "n8n-nodes-base.if",
"position": [
-1008,
-1808
],
"parameters": {
"options": {},
"conditions": {
"options": {
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "57af3729-0eaf-4cec-b9aa-de39b74ecc40",
"operator": {
"type": "string",
"operation": "notEmpty",
"singleValue": true
},
"leftValue": "={{ $json.end.date }}",
"rightValue": ""
}
]
}
},
"typeVersion": 2
},
{
"id": "f9628a67-5773-42f6-acfc-77c852fa27bd",
"name": "if_allDayEvent2",
"type": "n8n-nodes-base.if",
"position": [
-1008,
-1488
],
"parameters": {
"options": {},
"conditions": {
"options": {
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "57af3729-0eaf-4cec-b9aa-de39b74ecc40",
"operator": {
"type": "string",
"operation": "notEmpty",
"singleValue": true
},
"leftValue": "={{ $json.end.date }}",
"rightValue": ""
}
]
}
},
"typeVersion": 2
},
{
"id": "753fd2d6-46ca-4da9-a223-681052acc0a5",
"name": "if_allDayEvent4",
"type": "n8n-nodes-base.if",
"position": [
-1008,
-1168
],
"parameters": {
"options": {},
"conditions": {
"options": {
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "57af3729-0eaf-4cec-b9aa-de39b74ecc40",
"operator": {
"type": "string",
"operation": "notEmpty",
"singleValue": true
},
"leftValue": "={{ $json.end.date }}",
"rightValue": ""
}
]
}
},
"typeVersion": 2
},
{
"id": "03421bcc-6cc3-4022-b121-68beeda69d35",
"name": "Google Calendar",
"type": "n8n-nodes-base.googleCalendar",
"position": [
-544,
-2528
],
"parameters": {
"eventId": "={{ $json.id }}",
"calendar": {
"__rl": true,
"mode": "id",
"value": "={{ $json.organizer.email }}"
},
"operation": "update",
"updateFields": {
"end": "={{ DateTime.fromMillis(Number($('ClickUp').item.json.due_date)).plus(1,'day').format(\"yyyy-MM-dd\") }}",
"color": "8",
"start": "={{ DateTime.fromMillis(Number($('ClickUp').item.json.start_date)).format(\"yyyy-MM-dd\") }}",
"allday": "yes",
"summary": "={{ $('ClickUp').item.json.name }}",
"description": "={{ $('ClickUp').item.json.description }}"
}
},
"typeVersion": 1.1
},
{
"id": "8a0487f6-9bf8-4e1f-bc6c-958fc20405e7",
"name": "Google Calendar20",
"type": "n8n-nodes-base.googleCalendar",
"position": [
-544,
-2208
],
"parameters": {
"eventId": "={{ $json.id }}",
"calendar": {
"__rl": true,
"mode": "id",
"value": "={{ $json.organizer.email }}"
},
"operation": "update",
"updateFields": {
"end": "={{ DateTime.fromMillis(Number($('ClickUp').item.json.due_date)).plus(1,'day').format(\"yyyy-MM-dd\") }}",
"color": "6",
"start": "={{ DateTime.fromMillis(Number($('ClickUp').item.json.start_date)).format(\"yyyy-MM-dd\") }}",
"allday": "yes",
"summary": "={{ $('ClickUp').item.json.name }}",
"description": "={{ $('ClickUp').item.json.description }}"
}
},
"typeVersion": 1.1
},
{
"id": "af75f001-83c1-4c18-8f05-4720224a4a48",
"name": "Google Calendar21",
"type": "n8n-nodes-base.googleCalendar",
"position": [
-544,
-1888
],
"parameters": {
"eventId": "={{ $json.id }}",
"calendar": {
"__rl": true,
"mode": "id",
"value": "={{ $json.organizer.email }}"
},
"operation": "update",
"updateFields": {
"end": "={{ DateTime.fromMillis(Number($('ClickUp').item.json.due_date)).plus(1,'day').format(\"yyyy-MM-dd\") }}",
"color": "11",
"start": "={{ DateTime.fromMillis(Number($('ClickUp').item.json.start_date)).format(\"yyyy-MM-dd\") }}",
"allday": "yes",
"summary": "={{ $('ClickUp').item.json.name }}",
"description": "={{ $('ClickUp').item.json.description }}"
}
},
"typeVersion": 1.1
},
{
"id": "985124f8-099f-4b80-8b28-595249fe9af6",
"name": "Google Calendar22",
"type": "n8n-nodes-base.googleCalendar",
"position": [
-544,
-1568
],
"parameters": {
"eventId": "={{ $json.id }}",
"calendar": {
"__rl": true,
"mode": "id",
"value": "={{ $json.organizer.email }}"
},
"operation": "update",
"updateFields": {
"end": "={{ DateTime.fromMillis(Number($('ClickUp').item.json.due_date)).plus(1,'day').format(\"yyyy-MM-dd\") }}",
"color": "8",
"start": "={{ DateTime.fromMillis(Number($('ClickUp').item.json.start_date)).format(\"yyyy-MM-dd\") }}",
"allday": "yes",
"summary": "={{ $('ClickUp').item.json.name }}",
"description": "={{ $('ClickUp').item.json.description }}"
}
},
"typeVersion": 1.1
},
{
"id": "714ce512-19eb-4be4-90bc-4a44a6701a6a",
"name": "Google Calendar23",
"type": "n8n-nodes-base.googleCalendar",
"position": [
-544,
-1248
],
"parameters": {
"eventId": "={{ $json.id }}",
"calendar": {
"__rl": true,
"mode": "id",
"value": "={{ $json.organizer.email }}"
},
"operation": "update",
"updateFields": {
"end": "={{ DateTime.fromMillis(Number($('ClickUp').item.json.due_date)).plus(1,'day').format(\"yyyy-MM-dd\") }}",
"color": "10",
"start": "={{ DateTime.fromMillis(Number($('ClickUp').item.json.start_date)).format(\"yyyy-MM-dd\") }}",
"allday": "yes",
"summary": "={{ $('ClickUp').item.json.name }}",
"description": "={{ $('ClickUp').item.json.description }}"
}
},
"typeVersion": 1.1
},
{
"id": "3e4fec34-4062-4888-82a9-f413e0c1b30f",
"name": "If17",
"type": "n8n-nodes-base.if",
"position": [
-768,
-1728
],
"parameters": {
"options": {},
"conditions": {
"options": {
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "f08129c7-f807-4915-9012-020c59db3629",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $('Switch').item.json.colorId }}",
"rightValue": "=11"
},
{
"id": "f4816249-1454-4086-bed7-c7b74098b706",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $('ClickUp').item.json.name }}",
"rightValue": "={{ $json.summary }}"
},
{
"id": "a8e8d896-7b88-45b2-8763-5f65f34ebf64",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $('ClickUp').item.json.description }}",
"rightValue": "={{ $if($('Switch').item.json.description === undefined, \"\", $('Switch').item.json.description) }}"
},
{
"id": "55f6a009-6627-4bbf-8135-042518f59f27",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $('ClickUp').item.json.start_date.toInt().toDateTime().format(\"yyyy-MM-dd HH:mm:ss\") }}",
"rightValue": "={{ $json.start.dateTime.toDateTime().format(\"yyyy-MM-dd HH:mm:ss\") }}"
},
{
"id": "37ec2dae-3270-4e32-9d15-7e30d79fd562",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $('ClickUp').item.json.due_date.toInt().toDateTime().format(\"yyyy-MM-dd HH:mm:ss\") }}",
"rightValue": "={{ $json.end.dateTime.toDateTime().format(\"yyyy-MM-dd HH:mm:ss\") }}"
}
]
}
},
"typeVersion": 2
},
{
"id": "81c9ec23-d280-4219-b670-176d24a88505",
"name": "If18",
"type": "n8n-nodes-base.if",
"position": [
-768,
-2048
],
"parameters": {
"options": {},
"conditions": {
"options": {
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "f08129c7-f807-4915-9012-020c59db3629",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $('Switch').item.json.colorId }}",
"rightValue": "=6"
},
{
"id": "f4816249-1454-4086-bed7-c7b74098b706",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $('ClickUp').item.json.name }}",
"rightValue": "={{ $json.summary }}"
},
{
"id": "a8e8d896-7b88-45b2-8763-5f65f34ebf64",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $('ClickUp').item.json.description }}",
"rightValue": "={{ $if($('Switch').item.json.description === undefined, \"\", $('Switch').item.json.description) }}"
},
{
"id": "55f6a009-6627-4bbf-8135-042518f59f27",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $('ClickUp').item.json.start_date.toInt().toDateTime().format(\"yyyy-MM-dd HH:mm:ss\") }}",
"rightValue": "={{ $json.start.dateTime.toDateTime().format(\"yyyy-MM-dd HH:mm:ss\") }}"
},
{
"id": "37ec2dae-3270-4e32-9d15-7e30d79fd562",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $('ClickUp').item.json.due_date.toInt().toDateTime().format(\"yyyy-MM-dd HH:mm:ss\") }}",
"rightValue": "={{ $json.end.dateTime.toDateTime().format(\"yyyy-MM-dd HH:mm:ss\") }}"
}
]
}
},
"typeVersion": 2
},
{
"id": "30d0e026-2976-4ca8-bc44-178276bf6e16",
"name": "If19",
"type": "n8n-nodes-base.if",
"position": [
-768,
-2368
],
"parameters": {
"options": {},
"conditions": {
"options": {
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "f08129c7-f807-4915-9012-020c59db3629",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $('Switch').item.json.colorId }}",
"rightValue": "=8"
},
{
"id": "f4816249-1454-4086-bed7-c7b74098b706",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $('ClickUp').item.json.name }}",
"rightValue": "={{ $json.summary }}"
},
{
"id": "a8e8d896-7b88-45b2-8763-5f65f34ebf64",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $('ClickUp').item.json.description }}",
"rightValue": "={{ $if($('Switch').item.json.description === undefined, \"\", $('Switch').item.json.description) }}"
},
{
"id": "55f6a009-6627-4bbf-8135-042518f59f27",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $('ClickUp').item.json.start_date.toInt().toDateTime().format(\"yyyy-MM-dd HH:mm:ss\") }}",
"rightValue": "={{ $json.start.dateTime.toDateTime().format(\"yyyy-MM-dd HH:mm:ss\") }}"
},
{
"id": "37ec2dae-3270-4e32-9d15-7e30d79fd562",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $('ClickUp').item.json.due_date.toInt().toDateTime().format(\"yyyy-MM-dd HH:mm:ss\") }}",
"rightValue": "={{ $json.end.dateTime.toDateTime().format(\"yyyy-MM-dd HH:mm:ss\") }}"
}
]
}
},
"typeVersion": 2
},
{
"id": "1f9d7f56-5c03-4645-ba15-ca477efd9ed8",
"name": "If20",
"type": "n8n-nodes-base.if",
"position": [
-768,
-1408
],
"parameters": {
"options": {},
"conditions": {
"options": {
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "f08129c7-f807-4915-9012-020c59db3629",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $('Switch').item.json.colorId }}",
"rightValue": "=8"
},
{
"id": "f4816249-1454-4086-bed7-c7b74098b706",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $('ClickUp').item.json.name }}",
"rightValue": "={{ $json.summary }}"
},
{
"id": "a8e8d896-7b88-45b2-8763-5f65f34ebf64",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $('ClickUp').item.json.description }}",
"rightValue": "={{ $if($('Switch').item.json.description === undefined, \"\", $('Switch').item.json.description) }}"
},
{
"id": "55f6a009-6627-4bbf-8135-042518f59f27",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $('ClickUp').item.json.start_date.toInt().toDateTime().format(\"yyyy-MM-dd HH:mm:ss\") }}",
"rightValue": "={{ $json.start.dateTime.toDateTime().format(\"yyyy-MM-dd HH:mm:ss\") }}"
},
{
"id": "37ec2dae-3270-4e32-9d15-7e30d79fd562",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $('ClickUp').item.json.due_date.toInt().toDateTime().format(\"yyyy-MM-dd HH:mm:ss\") }}",
"rightValue": "={{ $json.end.dateTime.toDateTime().format(\"yyyy-MM-dd HH:mm:ss\") }}"
}
]
}
},
"typeVersion": 2
},
{
"id": "d61b6aa7-5a15-431c-9223-4e3effd6ef67",
"name": "If21",
"type": "n8n-nodes-base.if",
"position": [
-768,
-1088
],
"parameters": {
"options": {},
"conditions": {
"options": {
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "f08129c7-f807-4915-9012-020c59db3629",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $('Switch').item.json.colorId }}",
"rightValue": "=10"
},
{
"id": "f4816249-1454-4086-bed7-c7b74098b706",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $('ClickUp').item.json.name }}",
"rightValue": "={{ $json.summary }}"
},
{
"id": "a8e8d896-7b88-45b2-8763-5f65f34ebf64",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $('ClickUp').item.json.description }}",
"rightValue": "={{ $if($('Switch').item.json.description === undefined, \"\", $('Switch').item.json.description) }}"
},
{
"id": "55f6a009-6627-4bbf-8135-042518f59f27",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $('ClickUp').item.json.start_date.toInt().toDateTime().format(\"yyyy-MM-dd HH:mm:ss\") }}",
"rightValue": "={{ $json.start.dateTime.toDateTime().format(\"yyyy-MM-dd HH:mm:ss\") }}"
},
{
"id": "37ec2dae-3270-4e32-9d15-7e30d79fd562",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $('ClickUp').item.json.due_date.toInt().toDateTime().format(\"yyyy-MM-dd HH:mm:ss\") }}",
"rightValue": "={{ $json.end.dateTime.toDateTime().format(\"yyyy-MM-dd HH:mm:ss\") }}"
}
]
}
},
"typeVersion": 2
},
{
"id": "392ef462-910f-4569-90fa-159fced22a9b",
"name": "If22",
"type": "n8n-nodes-base.if",
"position": [
-768,
-2528
],
"parameters": {
"options": {},
"conditions": {
"options": {
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "f4816249-1454-4086-bed7-c7b74098b706",
"operator": {
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $('Switch').item.json.colorId }}",
"rightValue": "=8"
},
{
"id": "55f6a009-6627-4bbf-8135-042518f59f27",
"operator": {
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $('ClickUp').item.json.name }}",
"rightValue": "={{ $json.summary }}"
},
{
"id": "37ec2dae-3270-4e32-9d15-7e30d79fd562",
"operator": {
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $('ClickUp').item.json.description }}",
"rightValue": "={{ $if($('Switch').item.json.description === undefined, \"\", $('Switch').item.json.description) }}"
},
{
"id": "088e8216-a429-4f96-b55d-722d67dc55e1",
"operator": {
"type": "dateTime",
"operation": "equals"
},
"leftValue": "={{ $('ClickUp').item.json.start_date.toInt().toDateTime().format(\"yyyy-MM-dd\") }}",
"rightValue": "={{ $('Switch').item.json.start.date.toDateTime().format(\"yyyy-MM-dd\") }}"
},
{
"id": "48305bac-512f-451d-9972-5514c8ff6b35",
"operator": {
"type": "dateTime",
"operation": "equals"
},
"leftValue": "={{ $('ClickUp').item.json.due_date.toInt().toDateTime().format(\"yyyy-MM-dd\") }}",
"rightValue": "={{ $('Switch').item.json.end.date.toDateTime().minus(1,'day').format(\"yyyy-MM-dd\") }}"
}
]
}
},
"typeVersion": 2
},
{
"id": "03a454cb-6c2f-4d32-b1d9-a765ddfa9323",
"name": "If23",
"type": "n8n-nodes-base.if",
"position": [
-768,
-2208
],
"parameters": {
"options": {},
"conditions": {
"options": {
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "f08129c7-f807-4915-9012-020c59db3629",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $('Switch').item.json.colorId }}",
"rightValue": "=6"
},
{
"id": "f4816249-1454-4086-bed7-c7b74098b706",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $('ClickUp').item.json.name }}",
"rightValue": "={{ $json.summary }}"
},
{
"id": "a8e8d896-7b88-45b2-8763-5f65f34ebf64",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $('ClickUp').item.json.description }}",
"rightValue": "={{ $if($('Switch').item.json.description === undefined, \"\", $('Switch').item.json.description) }}"
},
{
"id": "55f6a009-6627-4bbf-8135-042518f59f27",
"operator": {
"type": "dateTime",
"operation": "equals"
},
"leftValue": "={{ $('ClickUp').item.json.start_date.toInt().toDateTime().format(\"yyyy-MM-dd\") }}",
"rightValue": "={{ $('Switch').item.json.start.date.toDateTime().format(\"yyyy-MM-dd\") }}"
},
{
"id": "37ec2dae-3270-4e32-9d15-7e30d79fd562",
"operator": {
"type": "dateTime",
"operation": "equals"
},
"leftValue": "={{ $('ClickUp').item.json.due_date.toInt().toDateTime().format(\"yyyy-MM-dd\") }}",
"rightValue": "={{ $('Switch').item.json.end.date.toDateTime().minus(1,'day').format(\"yyyy-MM-dd\") }}"
}
]
}
},
"typeVersion": 2
},
{
"id": "12f4cf8f-a067-4efc-ac4e-0e5719e754b5",
"name": "If24",
"type": "n8n-nodes-base.if",
"position": [
-768,
-1888
],
"parameters": {
"options": {},
"conditions": {
"options": {
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "f08129c7-f807-4915-9012-020c59db3629",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $('Switch').item.json.colorId }}",
"rightValue": "=11"
},
{
"id": "f4816249-1454-4086-bed7-c7b74098b706",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $('ClickUp').item.json.name }}",
"rightValue": "={{ $json.summary }}"
},
{
"id": "a8e8d896-7b88-45b2-8763-5f65f34ebf64",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $('ClickUp').item.json.description }}",
"rightValue": "={{ $if($('Switch').item.json.description === undefined, \"\", $('Switch').item.json.description) }}"
},
{
"id": "55f6a009-6627-4bbf-8135-042518f59f27",
"operator": {
"type": "dateTime",
"operation": "equals"
},
"leftValue": "={{ $('ClickUp').item.json.start_date.toInt().toDateTime().format(\"yyyy-MM-dd\") }}",
"rightValue": "={{ $('Switch').item.json.start.date.toDateTime().format(\"yyyy-MM-dd\") }}"
},
{
"id": "37ec2dae-3270-4e32-9d15-7e30d79fd562",
"operator": {
"type": "dateTime",
"operation": "equals"
},
"leftValue": "={{ $('ClickUp').item.json.due_date.toInt().toDateTime().format(\"yyyy-MM-dd\") }}",
"rightValue": "={{ $('Switch').item.json.end.date.toDateTime().minus(1,'day').format(\"yyyy-MM-dd\") }}"
}
]
}
},
"typeVersion": 2
},
{
"id": "d260c7c7-5ca8-4abc-b803-0a88ba091c28",
"name": "If25",
"type": "n8n-nodes-base.if",
"position": [
-768,
-1568
],
"parameters": {
"options": {},
"conditions": {
"options": {
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "f08129c7-f807-4915-9012-020c59db3629",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $('Switch').item.json.colorId }}",
"rightValue": "=8"
},
{
"id": "f4816249-1454-4086-bed7-c7b74098b706",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $('ClickUp').item.json.name }}",
"rightValue": "={{ $json.summary }}"
},
{
"id": "a8e8d896-7b88-45b2-8763-5f65f34ebf64",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $('ClickUp').item.json.description }}",
"rightValue": "={{ $if($('Switch').item.json.description === undefined, \"\", $('Switch').item.json.description) }}"
},
{
"id": "55f6a009-6627-4bbf-8135-042518f59f27",
"operator": {
"type": "dateTime",
"operation": "equals"
},
"leftValue": "={{ $('ClickUp').item.json.start_date.toInt().toDateTime().format(\"yyyy-MM-dd\") }}",
"rightValue": "={{ $('Switch').item.json.start.date.toDateTime().format(\"yyyy-MM-dd\") }}"
},
{
"id": "37ec2dae-3270-4e32-9d15-7e30d79fd562",
"operator": {
"type": "dateTime",
"operation": "equals"
},
"leftValue": "={{ $('ClickUp').item.json.due_date.toInt().toDateTime().format(\"yyyy-MM-dd\") }}",
"rightValue": "={{ $('Switch').item.json.end.date.toDateTime().minus(1,'day').format(\"yyyy-MM-dd\") }}"
}
]
}
},
"typeVersion": 2
},
{
"id": "41f14ab6-30cc-40d8-87c6-494562efcde2",
"name": "If26",
"type": "n8n-nodes-base.if",
"position": [
-768,
-1248
],
"parameters": {
"options": {},
"conditions": {
"options": {
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "f08129c7-f807-4915-9012-020c59db3629",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $('Switch').item.json.colorId }}",
"rightValue": "=10"
},
{
"id": "f4816249-1454-4086-bed7-c7b74098b706",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $('ClickUp').item.json.name }}",
"rightValue": "={{ $json.summary }}"
},
{
"id": "a8e8d896-7b88-45b2-8763-5f65f34ebf64",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $('ClickUp').item.json.description }}",
"rightValue": "={{ $if($('Switch').item.json.description === undefined, \"\", $('Switch').item.json.description) }}"
},
{
"id": "55f6a009-6627-4bbf-8135-042518f59f27",
"operator": {
"type": "dateTime",
"operation": "equals"
},
"leftValue": "={{ $('ClickUp').item.json.start_date.toInt().toDateTime().format(\"yyyy-MM-dd\") }}",
"rightValue": "={{ $('Switch').item.json.start.date.toDateTime().format(\"yyyy-MM-dd\") }}"
},
{
"id": "37ec2dae-3270-4e32-9d15-7e30d79fd562",
"operator": {
"type": "dateTime",
"operation": "equals"
},
"leftValue": "={{ $('ClickUp').item.json.due_date.toInt().toDateTime().format(\"yyyy-MM-dd\") }}",
"rightValue": "={{ $('Switch').item.json.end.date.toDateTime().minus(1,'day').format(\"yyyy-MM-dd\") }}"
}
]
}
},
"typeVersion": 2
},
{
"id": "04bf4a02-3028-46f0-ac40-aa8d9032fe0a",
"name": "Switch2",
"type": "n8n-nodes-base.switch",
"position": [
-1808,
-624
],
"parameters": {
"rules": {
"values": [
{
"outputKey": "Tarefas Pessoais",
"conditions": {
"options": {
"leftValue": "",
"caseSensitive": false,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"operator": {
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.list.name }}",
"rightValue": "Tarefas Pessoais"
}
]
},
"renameOutput": true
},
{
"outputKey": "Matérias em curso",
"conditions": {
"options": {
"leftValue": "",
"caseSensitive": false,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "7835e859-2a90-4930-ad26-9c480475ae29",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.list.name }}",
"rightValue": "Matérias em curso"
}
]
},
"renameOutput": true
},
{
"outputKey": "Cursos de tecnologia",
"conditions": {
"options": {
"leftValue": "",
"caseSensitive": false,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "5926dba3-301f-46f8-8bf9-52d451d20470",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.list.name }}",
"rightValue": "Cursos de tecnologia"
}
]
},
"renameOutput": true
},
{
"outputKey": "Estágio",
"conditions": {
"options": {
"leftValue": "",
"caseSensitive": false,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "59941363-663a-40d4-91ca-a28241ae6c1e",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.list.name }}",
"rightValue": "Estágio"
}
]
},
"renameOutput": true
}
]
},
"options": {
"ignoreCase": true
}
},
"typeVersion": 3
},
{
"id": "1d01dded-d575-431c-9190-f0476efdb12a",
"name": "Google Calendar24",
"type": "n8n-nodes-base.googleCalendar",
"position": [
-544,
-768
],
"parameters": {
"eventId": "={{ $json.id }}",
"calendar": {
"__rl": true,
"mode": "id",
"value": "={{ $json.organizer.email }}"
},
"operation": "update",
"updateFields": {
"end": "={{ DateTime.fromMillis(Number($('ClickUp').item.json.due_date)).format(\"yyyy-MM-dd HH:mm:ss\") }}",
"color": "10",
"start": "={{ DateTime.fromMillis(Number($('ClickUp').item.json.start_date)).format(\"yyyy-MM-dd HH:mm:ss\") }}",
"summary": "={{ $('ClickUp').item.json.name }}",
"description": "={{ $('ClickUp').item.json.description }}"
}
},
"typeVersion": 1.1
},
{
"id": "dde7ff23-40e6-46c1-928d-fb2f3d1629fb",
"name": "if_allDayEvent5",
"type": "n8n-nodes-base.if",
"position": [
-1008,
-848
],
"parameters": {
"options": {},
"conditions": {
"options": {
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "57af3729-0eaf-4cec-b9aa-de39b74ecc40",
"operator": {
"type": "string",
"operation": "notEmpty",
"singleValue": true
},
"leftValue": "={{ $json.end.date }}",
"rightValue": ""
}
]
}
},
"typeVersion": 2
},
{
"id": "4453a4f0-433d-45e8-99f1-ac610348971e",
"name": "Google Calendar25",
"type": "n8n-nodes-base.googleCalendar",
"position": [
-544,
-928
],
"parameters": {
"eventId": "={{ $json.id }}",
"calendar": {
"__rl": true,
"mode": "id",
"value": "={{ $json.organizer.email }}"
},
"operation": "update",
"updateFields": {
"end": "={{ DateTime.fromMillis(Number($('ClickUp').item.json.due_date)).plus(1,'day').format(\"yyyy-MM-dd\") }}",
"color": "10",
"start": "={{ DateTime.fromMillis(Number($('ClickUp').item.json.start_date)).format(\"yyyy-MM-dd\") }}",
"allday": "yes",
"summary": "={{ $('ClickUp').item.json.name }}",
"description": "={{ $('ClickUp').item.json.description }}"
}
},
"typeVersion": 1.1
},
{
"id": "09ccc83e-1714-40be-8e09-57a4a478bb4a",
"name": "If27",
"type": "n8n-nodes-base.if",
"position": [
-768,
-768
],
"parameters": {
"options": {},
"conditions": {
"options": {
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "f08129c7-f807-4915-9012-020c59db3629",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $('Switch').item.json.colorId }}",
"rightValue": "=10"
},
{
"id": "f4816249-1454-4086-bed7-c7b74098b706",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $('ClickUp').item.json.name }}",
"rightValue": "={{ $json.summary }}"
},
{
"id": "a8e8d896-7b88-45b2-8763-5f65f34ebf64",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $('ClickUp').item.json.description }}",
"rightValue": "={{ $if($('Switch').item.json.description === undefined, \"\", $('Switch').item.json.description) }}"
},
{
"id": "55f6a009-6627-4bbf-8135-042518f59f27",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $('ClickUp').item.json.start_date.toInt().toDateTime().format(\"yyyy-MM-dd HH:mm:ss\") }}",
"rightValue": "={{ $json.start.dateTime.toDateTime().format(\"yyyy-MM-dd HH:mm:ss\") }}"
},
{
"id": "37ec2dae-3270-4e32-9d15-7e30d79fd562",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $('ClickUp').item.json.due_date.toInt().toDateTime().format(\"yyyy-MM-dd HH:mm:ss\") }}",
"rightValue": "={{ $json.end.dateTime.toDateTime().format(\"yyyy-MM-dd HH:mm:ss\") }}"
}
]
}
},
"typeVersion": 2
},
{
"id": "042d3161-3dfa-4e9e-96a4-136688899268",
"name": "If28",
"type": "n8n-nodes-base.if",
"position": [
-768,
-928
],
"parameters": {
"options": {},
"conditions": {
"options": {
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "f08129c7-f807-4915-9012-020c59db3629",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $('Switch').item.json.colorId }}",
"rightValue": "=10"
},
{
"id": "f4816249-1454-4086-bed7-c7b74098b706",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $('ClickUp').item.json.name }}",
"rightValue": "={{ $json.summary }}"
},
{
"id": "a8e8d896-7b88-45b2-8763-5f65f34ebf64",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $('ClickUp').item.json.description }}",
"rightValue": "={{ $if($('Switch').item.json.description === undefined, \"\", $('Switch').item.json.description) }}"
},
{
"id": "55f6a009-6627-4bbf-8135-042518f59f27",
"operator": {
"type": "dateTime",
"operation": "equals"
},
"leftValue": "={{ $('ClickUp').item.json.start_date.toInt().toDateTime().format(\"yyyy-MM-dd\") }}",
"rightValue": "={{ $('Switch').item.json.start.date.toDateTime().format(\"yyyy-MM-dd\") }}"
},
{
"id": "37ec2dae-3270-4e32-9d15-7e30d79fd562",
"operator": {
"type": "dateTime",
"operation": "equals"
},
"leftValue": "={{ $('ClickUp').item.json.due_date.toInt().toDateTime().format(\"yyyy-MM-dd\") }}",
"rightValue": "={{ $('Switch').item.json.end.date.toDateTime().minus(1,'day').format(\"yyyy-MM-dd\") }}"
}
]
}
},
"typeVersion": 2
},
{
"id": "0d37d1f0-96c6-4a46-87ea-8010c11b8fdc",
"name": "条件分支",
"type": "n8n-nodes-base.switch",
"position": [
-1328,
-1328
],
"parameters": {
"rules": {
"values": [
{
"outputKey": "A Fazer",
"conditions": {
"options": {
"leftValue": "",
"caseSensitive": false,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"operator": {
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $('ClickUp').item.json.status.status }}",
"rightValue": "=a fazer"
}
]
},
"renameOutput": true
},
{
"outputKey": "Em Progresso",
"conditions": {
"options": {
"leftValue": "",
"caseSensitive": false,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "3dc27d16-3016-483a-8f07-d7159acac9c1",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $('ClickUp').item.json.status.status }}",
"rightValue": "em progresso"
}
]
},
"renameOutput": true
},
{
"outputKey": "Bloqueado",
"conditions": {
"options": {
"leftValue": "",
"caseSensitive": false,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "44f2d5e6-8222-48da-bb9a-15c1d3ac6c79",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $('ClickUp').item.json.status.status }}",
"rightValue": "bloqueado"
}
]
},
"renameOutput": true
},
{
"outputKey": "Cancelado",
"conditions": {
"options": {
"leftValue": "",
"caseSensitive": false,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "435b0cf8-183a-4bca-9fd5-6d996147af80",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $('ClickUp').item.json.status.status }}",
"rightValue": "cancelado"
}
]
},
"renameOutput": true
},
{
"outputKey": "Concluído",
"conditions": {
"options": {
"leftValue": "",
"caseSensitive": false,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "d7187ce8-198a-4033-b02b-3afe8f1ce016",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $('ClickUp').item.json.status.status }}",
"rightValue": "concluído"
}
]
},
"renameOutput": true
},
{
"outputKey": "Concluído (esconder)",
"conditions": {
"options": {
"leftValue": "",
"caseSensitive": false,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "7b45fbdd-0bf0-4bdc-9cad-92c73f8f98f3",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $('ClickUp').item.json.status.status }}",
"rightValue": "concluído (esconder)"
}
]
},
"renameOutput": true
}
]
},
"options": {
"ignoreCase": true
}
},
"typeVersion": 3
},
{
"id": "c0f42dd5-616b-4f4e-8b93-2e5e2513192b",
"name": "Switch1",
"type": "n8n-nodes-base.switch",
"position": [
-2048,
-1280
],
"parameters": {
"rules": {
"values": [
{
"outputKey": "Tarefas Pessoais",
"conditions": {
"options": {
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"operator": {
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.space.id }}",
"rightValue": "90130818069"
}
]
},
"renameOutput": true
},
{
"outputKey": "Faculdade",
"conditions": {
"options": {
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"operator": {
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.space.id }}",
"rightValue": "90130817978"
}
]
},
"renameOutput": true
},
{
"outputKey": "Cursos de Tecnologia",
"conditions": {
"options": {
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "18e45ae2-9885-4d35-9961-bb450ab70b86",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.space.id }}",
"rightValue": "90130818052"
}
]
},
"renameOutput": true
},
{
"outputKey": "Estágio",
"conditions": {
"options": {
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "b79507f8-2784-45f3-8006-a395586e8794",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.space.id }}",
"rightValue": "90130818045"
}
]
},
"renameOutput": true
}
]
},
"options": {}
},
"typeVersion": 3
},
{
"id": "3802a28f-dea7-4935-a4fd-13275b089c87",
"name": "Google Calendar6",
"type": "n8n-nodes-base.googleCalendar",
"onError": "continueErrorOutput",
"position": [
-1600,
-1408
],
"parameters": {
"eventId": "={{ $json.calendarEventId }}",
"options": {},
"calendar": {
"__rl": true,
"mode": "list",
"value": "81ee464e0b153d9b2bb24e45511c02e571c43b2e1c621a44ec3653dab8d35642@group.calendar.google.com",
"cachedResultName": "Faculdade"
},
"operation": "get"
},
"typeVersion": 1.1
},
{
"id": "5bbc9a8b-e6b7-42e0-aeb6-de39a9d35343",
"name": "Google Calendar1",
"type": "n8n-nodes-base.googleCalendar",
"onError": "continueErrorOutput",
"position": [
-1600,
-1584
],
"parameters": {
"eventId": "={{ $json.calendarEventId }}",
"options": {},
"calendar": {
"__rl": true,
"mode": "list",
"value": "gustavo10157@gmail.com",
"cachedResultName": "Tarefas Pessoais"
},
"operation": "get"
},
"typeVersion": 1.1
},
{
"id": "03b3e0e7-55fc-4b8c-a6b0-a7eb931c710f",
"name": "Google Calendar7",
"type": "n8n-nodes-base.googleCalendar",
"onError": "continueErrorOutput",
"position": [
-1600,
-1200
],
"parameters": {
"eventId": "={{ $json.calendarEventId }}",
"options": {},
"calendar": {
"__rl": true,
"mode": "list",
"value": "4c195f912fa5d605bf2fe52d6b2551c723eb8d3b268f57fcf9f9df081b1dea73@group.calendar.google.com",
"cachedResultName": "Cursos de Tecnologia"
},
"operation": "get"
},
"typeVersion": 1.1
},
{
"id": "03cd0dbf-21a2-475c-b045-fac314ae7201",
"name": "Google Calendar8",
"type": "n8n-nodes-base.googleCalendar",
"onError": "continueErrorOutput",
"position": [
-1600,
-1024
],
"parameters": {
"eventId": "={{ $json.calendarEventId }}",
"options": {},
"calendar": {
"__rl": true,
"mode": "list",
"value": "4aa82d736848d18d8935ecef6c2714fcda22beed2fd4158329ce032a655dd47b@group.calendar.google.com",
"cachedResultName": "Estágio"
},
"operation": "get"
},
"typeVersion": 1.1
},
{
"id": "b7e3c749-04e6-4c7e-a747-94309c5dee94",
"name": "条件判断1",
"type": "n8n-nodes-base.if",
"position": [
-2096,
-592
],
"parameters": {
"options": {},
"conditions": {
"options": {
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "or",
"conditions": [
{
"id": "775e79b5-27c2-485d-ba6d-809c70f4455f",
"operator": {
"type": "string",
"operation": "notEmpty",
"singleValue": true
},
"leftValue": "={{ $json.due_date }}",
"rightValue": false
},
{
"id": "d54df191-477b-4318-ae20-39dc9389dfd0",
"operator": {
"type": "string",
"operation": "notEmpty",
"singleValue": true
},
"leftValue": "={{ $json.start_date }}",
"rightValue": ""
}
]
}
},
"typeVersion": 2
},
{
"id": "9965e96b-f095-491d-9cf9-fdbc4dbd19c6",
"name": "Switch3",
"type": "n8n-nodes-base.switch",
"position": [
-2512,
-1008
],
"parameters": {
"rules": {
"values": [
{
"outputKey": "taskStatusUpdated",
"conditions": {
"options": {
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"operator": {
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.event }}",
"rightValue": "taskStatusUpdated"
}
]
},
"renameOutput": true
},
{
"outputKey": "taskCreated",
"conditions": {
"options": {
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "c28bda30-ad7b-4454-9068-cfee8c364873",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.event }}",
"rightValue": "taskCreated"
}
]
},
"renameOutput": true
},
{
"outputKey": "taskDeleted",
"conditions": {
"options": {
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "ce288bda-d51b-4ffa-8c5b-0109d7b21d3e",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.event }}",
"rightValue": "taskDeleted"
}
]
},
"renameOutput": true
},
{
"outputKey": "taskUpdated",
"conditions": {
"options": {
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "671e69ee-7ae5-4364-bb35-0d6f36f84854",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.event }}",
"rightValue": "taskUpdated"
}
]
},
"renameOutput": true
},
{
"outputKey": "taskDueDateUpdated",
"conditions": {
"options": {
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "0c8250cf-5b5f-49d6-981b-8e272c889e98",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.event }}",
"rightValue": "taskDueDateUpdated"
}
]
},
"renameOutput": true
}
]
},
"options": {}
},
"executeOnce": true,
"typeVersion": 3
},
{
"id": "25fdf8a0-29b4-4e6e-8888-6289cb1e886d",
"name": "合并",
"type": "n8n-nodes-base.merge",
"position": [
-1328,
-1024
],
"parameters": {
"mode": "chooseBranch"
},
"typeVersion": 2.1
},
{
"id": "767a4db1-013a-42d4-a553-a6f45818466a",
"name": "ClickUp1",
"type": "n8n-nodes-base.clickUp",
"position": [
-2256,
-592
],
"parameters": {
"id": "={{ $json.task_id || $json.id }}",
"operation": "get",
"authentication": "oAuth2"
},
"typeVersion": 1
},
{
"id": "5815eb78-a5ef-45c2-b1a4-5aab5e814f45",
"name": "ClickUp",
"type": "n8n-nodes-base.clickUp",
"position": [
-2224,
-1280
],
"parameters": {
"id": "={{ $json.task_id }}",
"operation": "get",
"authentication": "oAuth2"
},
"typeVersion": 1
},
{
"id": "89cfa5e0-4d84-45ca-a9d2-5b7d7baff1b6",
"name": "创建 – 详细",
"type": "n8n-nodes-base.stickyNote",
"position": [
-3024,
-736
],
"parameters": {
"color": 5,
"width": 576,
"height": 544,
"content": "## 创建 – ClickUp → Google Calendar"
},
"typeVersion": 1
},
{
"id": "74734f68-ff33-4951-bdb6-1e95b7781fe1",
"name": "更新 – 详细",
"type": "n8n-nodes-base.stickyNote",
"position": [
-2784,
-1872
],
"parameters": {
"color": 5,
"width": 736,
"height": 480,
"content": "## 更新 – 保持日历与 ClickUp 更改同步"
},
"typeVersion": 1
},
{
"id": "a4aac25b-c89b-4ab5-8dd2-c088615364e6",
"name": "删除 – 详细",
"type": "n8n-nodes-base.stickyNote",
"position": [
-3024,
-128
],
"parameters": {
"color": 5,
"width": 576,
"height": 544,
"content": "## 删除 – 移除事件并清理映射"
},
"typeVersion": 1
}
],
"pinData": {},
"connections": {
"If": {
"main": [
[],
[
{
"node": "Google Calendar10",
"type": "main",
"index": 0
}
]
]
},
"If1": {
"main": [
[
{
"node": "Switch2",
"type": "main",
"index": 0
}
]
]
},
"If17": {
"main": [
[],
[
{
"node": "Google Calendar15",
"type": "main",
"index": 0
}
]
]
},
"If18": {
"main": [
[],
[
{
"node": "Google Calendar16",
"type": "main",
"index": 0
}
]
]
},
"If19": {
"main": [
[],
[
{
"node": "Google Calendar17",
"type": "main",
"index": 0
}
]
]
},
"If20": {
"main": [
[],
[
{
"node": "Google Calendar18",
"type": "main",
"index": 0
}
]
]
},
"If21": {
"main": [
[],
[
{
"node": "Google Calendar19",
"type": "main",
"index": 0
}
]
]
},
"If22": {
"main": [
[],
[
{
"node": "Google Calendar",
"type": "main",
"index": 0
}
]
]
},
"If23": {
"main": [
[],
[
{
"node": "Google Calendar20",
"type": "main",
"index": 0
}
]
]
},
"If24": {
"main": [
[],
[
{
"node": "Google Calendar21",
"type": "main",
"index": 0
}
]
]
},
"If25": {
"main": [
[],
[
{
"node": "Google Calendar22",
"type": "main",
"index": 0
}
]
]
},
"If26": {
"main": [
[],
[
{
"node": "Google Calendar23",
"type": "main",
"index": 0
}
]
]
},
"If27": {
"main": [
[],
[
{
"node": "Google Calendar24",
"type": "main",
"index": 0
}
]
]
},
"If28": {
"main": [
[],
[
{
"node": "Google Calendar25",
"type": "main",
"index": 0
}
]
]
},
"Merge": {
"main": [
[
{
"node": "ClickUp1",
"type": "main",
"index": 0
}
]
]
},
"Switch": {
"main": [
[
{
"node": "if_allDayEvent3",
"type": "main",
"index": 0
}
],
[
{
"node": "if_allDayEvent",
"type": "main",
"index": 0
}
],
[
{
"node": "if_allDayEvent1",
"type": "main",
"index": 0
}
],
[
{
"node": "if_allDayEvent2",
"type": "main",
"index": 0
}
],
[
{
"node": "if_allDayEvent4",
"type": "main",
"index": 0
}
],
[
{
"node": "if_allDayEvent5",
"type": "main",
"index": 0
}
]
]
},
"ClickUp": {
"main": [
[
{
"node": "Switch1",
"type": "main",
"index": 0
},
{
"node": "Merge",
"type": "main",
"index": 0
}
]
]
},
"Switch1": {
"main": [
[
{
"node": "Google Sheets4",
"type": "main",
"index": 0
}
],
[
{
"node": "Google Sheets5",
"type": "main",
"index": 0
}
],
[
{
"node": "Google Sheets6",
"type": "main",
"index": 0
}
],
[
{
"node": "Google Sheets7",
"type": "main",
"index": 0
}
]
]
},
"Switch2": {
"main": [
[
{
"node": "Edit Fields",
"type": "main",
"index": 0
}
],
[
{
"node": "Edit Fields1",
"type": "main",
"index": 0
}
],
[
{
"node": "Edit Fields2",
"type": "main",
"index": 0
}
],
[
{
"node": "Edit Fields3",
"type": "main",
"index": 0
}
]
]
},
"Switch3": {
"main": [
[],
[
{
"node": "ClickUp1",
"type": "main",
"index": 0
}
],
[
{
"node": "Google Sheets2",
"type": "main",
"index": 0
}
],
[
{
"node": "ClickUp",
"type": "main",
"index": 0
}
],
[
{
"node": "ClickUp",
"type": "main",
"index": 0
}
]
]
},
"ClickUp1": {
"main": [
[
{
"node": "If1",
"type": "main",
"index": 0
}
]
]
},
"Edit Fields": {
"main": [
[
{
"node": "Edit Fields4",
"type": "main",
"index": 0
}
]
]
},
"Edit Fields1": {
"main": [
[
{
"node": "Edit Fields4",
"type": "main",
"index": 0
}
]
]
},
"Edit Fields2": {
"main": [
[
{
"node": "Edit Fields4",
"type": "main",
"index": 0
}
]
]
},
"Edit Fields3": {
"main": [
[
{
"node": "Edit Fields4",
"type": "main",
"index": 0
}
]
]
},
"Edit Fields4": {
"main": [
[
{
"node": "Google Calendar9",
"type": "main",
"index": 0
}
]
]
},
"Edit Fields6": {
"main": [
[
{
"node": "Google Sheets1",
"type": "main",
"index": 0
}
]
]
},
"Configuration": {
"main": [
[
{
"node": "Switch3",
"type": "main",
"index": 0
}
]
]
},
"Google Sheets2": {
"main": [
[
{
"node": "Google Calendar14",
"type": "main",
"index": 0
},
{
"node": "Google Calendar13",
"type": "main",
"index": 0
},
{
"node": "Google Calendar12",
"type": "main",
"index": 0
},
{
"node": "Google Calendar11",
"type": "main",
"index": 0
}
]
]
},
"Google Sheets4": {
"main": [
[
{
"node": "Google Calendar1",
"type": "main",
"index": 0
}
]
]
},
"Google Sheets5": {
"main": [
[
{
"node": "Google Calendar6",
"type": "main",
"index": 0
}
]
]
},
"Google Sheets6": {
"main": [
[
{
"node": "Google Calendar7",
"type": "main",
"index": 0
}
]
]
},
"Google Sheets7": {
"main": [
[
{
"node": "Google Calendar8",
"type": "main",
"index": 0
}
]
]
},
"if_allDayEvent": {
"main": [
[
{
"node": "If23",
"type": "main",
"index": 0
}
],
[
{
"node": "If18",
"type": "main",
"index": 0
}
]
]
},
"ClickUp Trigger": {
"main": [
[
{
"node": "Configuration",
"type": "main",
"index": 0
}
]
]
},
"Google Calendar": {
"main": [
[
{
"node": "Google Sheets3",
"type": "main",
"index": 0
}
]
]
},
"if_allDayEvent1": {
"main": [
[
{
"node": "If24",
"type": "main",
"index": 0
}
],
[
{
"node": "If17",
"type": "main",
"index": 0
}
]
]
},
"if_allDayEvent2": {
"main": [
[
{
"node": "If25",
"type": "main",
"index": 0
}
],
[
{
"node": "If20",
"type": "main",
"index": 0
}
]
]
},
"if_allDayEvent3": {
"main": [
[
{
"node": "If22",
"type": "main",
"index": 0
}
],
[
{
"node": "If19",
"type": "main",
"index": 0
}
]
]
},
"if_allDayEvent4": {
"main": [
[
{
"node": "If26",
"type": "main",
"index": 0
}
],
[
{
"node": "If21",
"type": "main",
"index": 0
}
]
]
},
"if_allDayEvent5": {
"main": [
[
{
"node": "If28",
"type": "main",
"index": 0
}
],
[
{
"node": "If27",
"type": "main",
"index": 0
}
]
]
},
"Google Calendar1": {
"main": [
[
{
"node": "Switch",
"type": "main",
"index": 0
}
],
[
{
"node": "Merge",
"type": "main",
"index": 1
}
]
]
},
"Google Calendar6": {
"main": [
[
{
"node": "Switch",
"type": "main",
"index": 0
}
],
[
{
"node": "Merge",
"type": "main",
"index": 1
}
]
]
},
"Google Calendar7": {
"main": [
[
{
"node": "Switch",
"type": "main",
"index": 0
}
],
[
{
"node": "Merge",
"type": "main",
"index": 1
}
]
]
},
"Google Calendar8": {
"main": [
[
{
"node": "Switch",
"type": "main",
"index": 0
}
],
[
{
"node": "Merge",
"type": "main",
"index": 1
}
]
]
},
"Google Calendar9": {
"main": [
[
{
"node": "If",
"type": "main",
"index": 0
}
]
]
},
"Google Calendar10": {
"main": [
[
{
"node": "Google Sheets",
"type": "main",
"index": 0
}
]
]
},
"Google Calendar11": {
"main": [
[
{
"node": "Edit Fields6",
"type": "main",
"index": 0
}
]
]
},
"Google Calendar12": {
"main": [
[
{
"node": "Edit Fields6",
"type": "main",
"index": 0
}
]
]
},
"Google Calendar13": {
"main": [
[
{
"node": "Edit Fields6",
"type": "main",
"index": 0
}
]
]
},
"Google Calendar14": {
"main": [
[
{
"node": "Edit Fields6",
"type": "main",
"index": 0
}
]
]
},
"Google Calendar15": {
"main": [
[
{
"node": "Google Sheets3",
"type": "main",
"index": 0
}
]
]
},
"Google Calendar16": {
"main": [
[
{
"node": "Google Sheets3",
"type": "main",
"index": 0
}
]
]
},
"Google Calendar17": {
"main": [
[
{
"node": "Google Sheets3",
"type": "main",
"index": 0
}
]
]
},
"Google Calendar18": {
"main": [
[
{
"node": "Google Sheets3",
"type": "main",
"index": 0
}
]
]
},
"Google Calendar19": {
"main": [
[
{
"node": "Google Sheets3",
"type": "main",
"index": 0
}
]
]
},
"Google Calendar20": {
"main": [
[
{
"node": "Google Sheets3",
"type": "main",
"index": 0
}
]
]
},
"Google Calendar21": {
"main": [
[
{
"node": "Google Sheets3",
"type": "main",
"index": 0
}
]
]
},
"Google Calendar22": {
"main": [
[
{
"node": "Google Sheets3",
"type": "main",
"index": 0
}
]
]
},
"Google Calendar23": {
"main": [
[
{
"node": "Google Sheets3",
"type": "main",
"index": 0
}
]
]
},
"Google Calendar24": {
"main": [
[
{
"node": "Google Sheets3",
"type": "main",
"index": 0
}
]
]
},
"Google Calendar25": {
"main": [
[
{
"node": "Google Sheets3",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
高级 - 项目管理, 多模态 AI
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
通过Webhook集成将Google Tasks转换为Google Calendar事件
通过Webhook集成将Google Tasks转换为Google Calendar事件
If
Set
Webhook
+4
16 节点R4wd0G
个人效率
带有 Chatgpt Agent Prompt 检查的信用卡
AI驱动信用卡推荐系统，集成OpenAI GPT、Telegram和Google Sheets
If
Set
Code
+7
31 节点Nishant
AI 聊天机器人
宠物美容发布与预约自动化
使用AI、Facebook和Telegram机器人自动化宠物美容发布与预约
If
Set
Switch
+17
36 节点Christian Moises
AI 聊天机器人
WordPress博客自动化专业版（深度研究）v2.1市场
使用GPT-4o、Perplexity AI和多语言支持自动化SEO优化的博客创建
If
Set
Xml
+27
125 节点Daniel Ng
内容创作
GPT-4o与错误处理的自动化简历筛选 - Google表格与云端硬盘流程
GPT-4o与错误处理的自动化简历筛选 - Google表格与云端硬盘流程
If
Set
Gmail
+12
34 节点David Olusola
内容创作
批量SEO内容生成与带AI图片的Webflow草稿创建（模板）
使用GPT、Gemini图片和Webflow草稿创建进行批量SEO内容生成
If
Set
Code
+18
54 节点Dahiana
内容创作
