AutomationFlowsEmail & Gmail › Automated Clickup Time Tracking Reports & Task Performance Analytics via Gmail

Automated Clickup Time Tracking Reports & Task Performance Analytics via Gmail

ByRahul Joshi @rahul08 on n8n.io

Description

Cron / scheduled trigger★★★★☆ complexity16 nodesGmailClickUp
Email & Gmail Trigger: Cron / scheduled Nodes: 16 Complexity: ★★★★☆ Added:

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 →

Download .json
{
  "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
          }
        ]
      ]
    }
  }
}
Pro

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 →

More Email & Gmail workflows → · Browse all categories →

Related workflows

Workflows that share integrations, category, or trigger type with this one. All free to copy and import.

Email & Gmail

YOUR_ID 4. Uses gmail, googleDrive, googleSheets, httpRequest. Scheduled trigger; 53 nodes.

Gmail, Google Drive, Google Sheets +1
Email & Gmail

Calendar and Meeting Prep Workflow. Uses googleCalendar, gmail, clickUp, httpRequest. Event-driven trigger; 38 nodes.

Google Calendar, Gmail, ClickUp +1
Email & Gmail

The FamilyFlow Assistant is your n8n-powered 🚀 companion designed to streamline daily parenting tasks, reduce mental load, and bring a bit more organization and fun into your family life. This versati

Start, Email Send, Telegram Trigger +2
Email & Gmail

Instead of providing a routine check, it focuses on significant movements by: Sending a Slack alert only if a query crosses a defined movement threshold. Emailing a structured report with the Top 25 i

HTTP Request, Slack, Gmail
Email & Gmail

Looking for a way to track GitHub bounty issues automatically and get notified in real time? This GitHub Bounty Tracker workflow monitors repositories for issues labeled 💎 Bounty, logs them in Google

Google Sheets, HTTP Request, WhatsApp +1