Templates / Daily overdue tasks report from ClickUp to Gmail for team accountability

Daily overdue tasks report from ClickUp to Gmail for team accountability

Needs changes

by Rahul Joshi ✓ · 121 views · created 2025-08-19 · Project Management, Multimodal AI

Needs changes. This template uses 1 thing(s) that n8n 3.0 removes: Function (legacy). 1 breaking item(s) found. Static check, last run 2026-10-19.

What this workflow does

This workflow has 5 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Gmail and ClickUp.

How it runs

Trigger: Manually, when you click “Execute workflow”.

  1. Get many tasks (ClickUp): uses ClickUp
  2. Process Sprint Data (Function): runs custom JavaScript (legacy Function node)
  3. creating report (Function): runs custom JavaScript (legacy Function node)
  4. Send Daily Report Email (Gmail): uses Gmail

Services it uses

GmailClickUp

Before you upgrade to n8n 3.0

1 thing in this workflow is removed in n8n 3.0. Fix it before you upgrade:

  • Function (legacy) in Process Sprint Data, creating report: replace with Code node, mode 'Run Once for All Items'.

Rather not rewrite it? Many of these flows can be rebuilt in Make (free plan).

Removed in 3.0Replace with
Function (legacy)
Process Sprint Data, creating report
Code node, mode 'Run Once for All Items'

Nodes used (4)

From the author

Description Stay on top of missed deadlines with this automated workflow that generates daily HTML reports of overdue tasks from ClickUp. This automation runs daily, fetching all tasks with past due dates, organizing them by assignee, and delivering…

Excerpt from Rahul Joshi's description on n8n.io.

View the original on n8n.io → Check your own copy

Get the weekly “what broke” email

New templates, newly broken ones, and n8n release changes. One short email a week.

Form not loading? Subscribe here.