AutomationFlowsEmail & Gmail › Daily Overdue Tasks Report From Clickup to Gmail for Team Accountability

Daily Overdue Tasks Report From Clickup to Gmail for Team Accountability

ByRahul Joshi @rahul08 on n8n.io

Description

Event trigger★★★★☆ complexity10 nodesGmailClickUp
Email & Gmail Trigger: Event Nodes: 10 Complexity: ★★★★☆ Added:

This workflow corresponds to n8n.io template #7572 — 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": "P5nDlFKGwnJEGbT8",
  "meta": {
    "templateCredsSetupCompleted": true
  },
  "name": "Overdue Task Alert ClickUp(BDE)",
  "tags": [],
  "nodes": [
    {
      "id": "d1c1d4e7-cdf3-4fce-adb9-7294fea2cbaf",
      "name": "When clicking 'Execute workflow'",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
        -800,
        96
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "3fa087f8-003c-47a6-985a-bd2c4db1f38d",
      "name": "Process Sprint Data",
      "type": "n8n-nodes-base.function",
      "position": [
        -272,
        96
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "a357605a-2891-419d-a907-e29905b54772",
      "name": "Send Daily Report Email",
      "type": "n8n-nodes-base.gmail",
      "position": [
        256,
        96
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "6dcd13d2-620f-492b-bf7b-ab54e6f0412a",
      "name": "Get many tasks",
      "type": "n8n-nodes-base.clickUp",
      "position": [
        -512,
        96
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "a9aab990-5814-49ee-8971-68c4cbf6ffec",
      "name": "creating report",
      "type": "n8n-nodes-base.function",
      "position": [
        -32,
        96
      ],
      "parameters": {},
      "typeVersion": 1,
      "alwaysOutputData": true
    },
    {
      "id": "515e9f2c-f8ee-45cc-8d63-0a840fb78250",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        272,
        -352
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "682299d9-fb22-49bb-84fc-68b88eb02425",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -176,
        -384
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "2d79980f-2734-4fe3-a0cf-76a2c8f4fb12",
      "name": "Sticky Note3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -384,
        240
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "625ab8aa-284d-43b8-ad71-8ae51b8f8a9f",
      "name": "Sticky Note4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -656,
        -272
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "e0fd355b-52ba-494a-987b-7d4b4eb227ba",
      "name": "Sticky Note5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1056,
        -272
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    }
  ],
  "active": false,
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "2ff55ac4-6a6a-4e16-b695-92a5f3bfef15",
  "connections": {
    "Get many tasks": {
      "main": [
        [
          {
            "node": "Process Sprint Data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "creating report": {
      "main": [
        [
          {
            "node": "Send Daily Report Email",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Process Sprint Data": {
      "main": [
        [
          {
            "node": "creating report",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "When clicking 'Execute workflow'": {
      "main": [
        [
          {
            "node": "Get many tasks",
            "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/7572/ — 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

📘 Description

HTTP Request, Gmail Trigger, ClickUp +3
Email & Gmail

Stripe invoicing automation that is connected to your CRM, in this example, it is ClickUp. At the end of the flow, once your lead has been sent an invoice, you (or your team) will be sent an email not

ClickUp Trigger, HTTP Request, Stripe +2
Email & Gmail

This n8n workflow automates the candidate shortlisting process by integrating Google Sheets, Gmail, ClickUp, and Calendly. It fetches candidate records, filters high-scoring profiles, sends personaliz

Google Sheets, Gmail, ClickUp
Email & Gmail

This workflow automates the tracking and follow-up process for pending payments. It pulls lead payment data from Google Sheets, checks whether the status is “Open,” and then routes actions accordingly

Google Sheets, Slack, ClickUp +1
Email & Gmail

This workflow runs every Monday at 8 AM and automatically monitors your Jira project, measures progress against the active sprint, and delivers a structured report to stakeholders — with zero manual e

Postgres, Jira, N8N Nodes Htmlcsstopdf +1