Generate ClickUp Weekly Assignment & Performance Reports with Gmail

This n8n workflow automates the generation and delivery of professional weekly reports from ClickUp, pulling tasks filtered by the current week, organizing them by assignee, and highlighting urgent/overdue items with priority badges and sprint points. It calculates team statistics and formats everything into a polished HTML email sent automatically via Gmail, eliminating manual reporting efforts.

Key benefits include real-time visibility into upcoming assignments, performance tracking per team member, and proactive alerts for bottlenecks, saving project managers hours of spreadsheet work each week. Ideal for sales teams, project leads, and managers needing quick insights without sifting through ClickUp dashboards.

Use cases span sales pipeline monitoring, sprint reviews, and productivity check-ins. Prerequisites are straightforward: ClickUp API token, Gmail with app password, and basic n8n setup. Customize filters, styling, and schedules (e.g., Mondays at 9 AM) for seamless integration into your workflow.