Rahul Joshi This workflow corresponds to n8n.io template #7570 — we link there as the canonical source.
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 →
{
"id": "xVWb962oKTrPDnCW",
"meta": {
"templateCredsSetupCompleted": true
},
"name": "Time logs Report Clickup (BDE)",
"tags": [],
"nodes": [
{
"id": "d62f9407-69b4-41d9-9977-8fd3bb43d084",
"name": "Process Sprint Data",
"type": "n8n-nodes-base.function",
"position": [
-416,
288
],
"parameters": {},
"typeVersion": 1
},
{
"id": "8883b033-77cf-4d39-b0dc-490b11c4dedf",
"name": "Send Daily Report Email",
"type": "n8n-nodes-base.gmail",
"position": [
224,
288
],
"parameters": {},
"typeVersion": 1
},
{
"id": "6627e0b3-2931-42cf-ac8a-0565d694fb3f",
"name": "creating report",
"type": "n8n-nodes-base.function",
"position": [
-64,
288
],
"parameters": {},
"typeVersion": 1
},
{
"id": "259a67a2-52d9-4c5b-93c2-6d245b25c3f2",
"name": "Sticky Note1",
"type": "n8n-nodes-base.stickyNote",
"position": [
240,
-112
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "b12bcbbe-9b65-4e19-8e0f-0ccc06bd49d0",
"name": "Sticky Note2",
"type": "n8n-nodes-base.stickyNote",
"position": [
-160,
-192
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "12efbfc4-e75d-4c3c-a45d-d4a86146dded",
"name": "Sticky Note3",
"type": "n8n-nodes-base.stickyNote",
"position": [
-416,
432
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "b7f97dd4-af50-4951-96c9-feda7ff3cc22",
"name": "Sticky Note4",
"type": "n8n-nodes-base.stickyNote",
"position": [
-656,
-112
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "36cfc79f-1179-4765-b334-485d24a331b8",
"name": "Sticky Note5",
"type": "n8n-nodes-base.stickyNote",
"position": [
-2032,
-80
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "9d8e43e9-7320-4eaa-bdb7-da8da622ae1b",
"name": "Get All Lists (Sprints)",
"type": "n8n-nodes-base.clickUp",
"position": [
-1520,
304
],
"parameters": {},
"typeVersion": 1
},
{
"id": "6a348c15-a6a0-4e80-8294-d216d87f0f95",
"name": "Check Lists Exist",
"type": "n8n-nodes-base.if",
"position": [
-1264,
304
],
"parameters": {},
"typeVersion": 2
},
{
"id": "e25f00d1-5688-4339-8492-2cdd3ec522df",
"name": "Find Latest Sprint",
"type": "n8n-nodes-base.code",
"position": [
-992,
288
],
"parameters": {},
"typeVersion": 2
},
{
"id": "6f26a0c3-4b29-4588-8eb6-c9c92bfa3549",
"name": "Get Tasks from Latest Sprint",
"type": "n8n-nodes-base.clickUp",
"position": [
-736,
288
],
"parameters": {},
"typeVersion": 1
},
{
"id": "61aaf594-4dc8-4545-bca0-8c2f559064ab",
"name": "Schedule Trigger",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
-1792,
304
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "75f51ab6-006e-4010-8874-e86e49b15ca4",
"name": "Sticky Note",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1664,
-80
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "5d63e9d8-b728-43a1-bff6-5a0964bdf01b",
"name": "Sticky Note7",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1072,
448
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "2ec45003-a396-4eae-ac06-f725a4e85b8c",
"name": "Sticky Note9",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1328,
-96
],
"parameters": {
"content": ""
},
"typeVersion": 1
}
],
"active": false,
"settings": {
"executionOrder": "v1"
},
"versionId": "9242b7eb-44ce-406d-bfd9-7f5e97fcd660",
"connections": {
"creating report": {
"main": [
[
{
"node": "Send Daily Report Email",
"type": "main",
"index": 0
}
]
]
},
"Schedule Trigger": {
"main": [
[
{
"node": "Get All Lists (Sprints)",
"type": "main",
"index": 0
}
]
]
},
"Check Lists Exist": {
"main": [
[
{
"node": "Find Latest Sprint",
"type": "main",
"index": 0
}
],
[]
]
},
"Find Latest Sprint": {
"main": [
[
{
"node": "Get Tasks from Latest Sprint",
"type": "main",
"index": 0
}
]
]
},
"Process Sprint Data": {
"main": [
[
{
"node": "creating report",
"type": "main",
"index": 0
}
]
]
},
"Get All Lists (Sprints)": {
"main": [
[
{
"node": "Check Lists Exist",
"type": "main",
"index": 0
}
]
]
},
"Get Tasks from Latest Sprint": {
"main": [
[
{
"node": "Process Sprint Data",
"type": "main",
"index": 0
}
]
]
}
}
}
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
Description
Source: https://n8n.io/workflows/7570/ — 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.
This workflow runs daily at 9 AM to pull unpaid invoices from Microsoft SQL, send staged payment reminder emails via Gmail based on due date timing, update invoice status and an audit log in the datab
Relatórios aos Laboratórios. Uses httpRequest, gmail, formTrigger. Scheduled trigger; 54 nodes.
YOUR_ID 4. Uses gmail, googleDrive, googleSheets, httpRequest. Scheduled trigger; 53 nodes.
14310 Send Overdue Invoice Payment Reminders With Ifirma Gmail Postgrid And Slack. Uses httpRequest, stopAndError, slack, gmail. Scheduled trigger; 53 nodes.
Addendo — Blog Automatico Don Jacinto Nahual. Uses httpRequest, redis, github, gmail. Scheduled trigger; 51 nodes.