Daily overdue tasks report from ClickUp to Gmail for team accountability
Needs changesNeeds 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 to replace before upgrading
| Removed in 3.0 | Replace with |
|---|---|
| Function (legacy) Process Sprint Data, creating report | Code node, mode 'Run Once for All Items' |
Nodes used (4)
- Manual Trigger
n8n-nodes-base.manualTrigger - Function
n8n-nodes-base.function - Gmail
n8n-nodes-base.gmail - ClickUp
n8n-nodes-base.clickUp
What it does
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 professional reports to keep teams accountable. Perfect for sales and business development managers who need real-time visibility on overdue ClickUp tasks to drive accountability and timely completion. Features 🚨 Complete Overdue Task List - All tasks with past due dates, status, and sprint points 👤 Assignee Breakdown - Organized by team member for quick follow-ups 🏷 Priority Tagging - Visual urgency assessment with priority indicators 📊 Summary Statistics - Total overdue tasks per user and team-wide metrics 📅 Daily Automation - Ensures no overdue task slips through the cracks 📧 Professional Reports - Polished HTML emails delivered via Gmail Setup Instructions - Prerequisites: Ensure you have n8n (v1.0+), ClickUp workspace access, and Gmail account with app-specific password - ClickUp API: Generate API token in ClickUp Settings > Apps and add to n8n credentials - Gmail Configuration: Set up Gmail credentials using app-specific password (enable 2FA first) - Import Workflow: Load the JSON template and update ClickUp workspace/list IDs - Configure Recipients: Update email recipient list in the Gmail node - Test Run: Execute manually to verify data retrieval and email delivery - Schedule: Set daily schedule (recommended: 8 AM on weekdays) The polished HTML report is sent automatically via Gmail, keeping managers, team leads, and stakeholders informed without manual task tracking. Perfect for sales and business development managers who need real-time visibility on overdue ClickUp tasks to drive accountability and timely completion. Keywords: n8n ClickUp automation, overdue task report, overdue assignments, ClickUp to Gmail workflow, missed deadline tracker, sales task monitoring, overdue sprint points report.