R4wd0G This workflow corresponds to n8n.io template #7871 — we link there as the canonical source.
This workflow follows the Google Calendar → Google Sheets recipe pattern — see all workflows that pair these two integrations.
The workflow JSON
Copy or download the full n8n JSON below. Paste it into a new n8n workflow, add your credentials, activate. Full import guide →
{
"meta": {
"templateCredsSetupCompleted": true
},
"nodes": [
{
"id": "20ed9153-7d1e-4ee6-b143-7b3a6d19a1a9",
"name": "Configuration",
"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": "Template Notes",
"type": "n8n-nodes-base.stickyNote",
"position": [
-2848,
-2736
],
"parameters": {
"color": "yellow",
"width": 736,
"height": 352,
"content": "## Template Instructions\nSync **ClickUp tasks \u2192 Google Calendar** (create, update, delete) and keep a mapping in Google Sheets.\n\n**Setup**\n1) Open **Configuration** and set `calendarId_*`, `sheetId`, `sheetTabName`, and `clickupTeamId`.\n2) Assign your **Google** and **ClickUp** credentials to the nodes after import.\n3) Enable the trigger and test.\n\n**Notes**\n- Mapping sheet stores `clickupTaskId`, `calendarEventId`, `eventName`.\n- No secrets in JSON; credentials are selected at runtime."
},
"typeVersion": 1
},
{
"id": "84da75ab-7ee8-4d52-9e0d-44dc34169966",
"name": "If",
"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": "Edit Fields",
"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": "Edit Fields1",
"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": "Edit Fields2",
"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": "Edit Fields3",
"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": "Edit Fields4",
"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": "Edit Fields6",
"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 Trigger",
"type": "n8n-nodes-base.clickUpTrigger",
"position": [
-2768,
-1008
],
"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\u00e9rias 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\u00e9rias 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\u00e1gio",
"conditions": {
"options": {
"leftValue": "",
"caseSensitive": false,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
Pro
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
Teams that manage tasks in ClickUp and want those tasks reflected—and kept in sync—in Google Calendar automatically.
Source: https://n8n.io/workflows/7871/ — original creator credit. Request a take-down →
Related workflows
Workflows that share integrations, category, or trigger type with this one. All free to copy and import.
Sync Notion Database Pages As Clickup Tasks. Uses notionTrigger, clickUp, clickUpTrigger, notion. Event-driven trigger; 5 nodes.
Notion Trigger, ClickUp, ClickUp Trigger +1
This workflow creates/updates ClickUp tasks when Notion database pages are created/updated. All fields in the Notion database are mapped to a ClickUp property.
Notion Trigger, ClickUp, ClickUp Trigger +1
This workflow acts as a junior finance research analyst for a UK boutique M&A or corporate finance team. It listens for Slack messages, classifies the request, gathers company or market data, and prod
HTTP Request, Google Drive, Google Docs +5
Agendamiento_v2. Uses n8n-nodes-evolution-api, redis, httpRequest, executeWorkflowTrigger. Event-driven trigger; 59 nodes.
N8N Nodes Evolution Api, Redis, HTTP Request +3
Cancelacion_v2. Uses executeWorkflowTrigger, redis, httpRequest, n8n-nodes-evolution-api. Event-driven trigger; 46 nodes.
Execute Workflow Trigger, Redis, HTTP Request +3