Weekly ClickUp Report to Microsoft Teams

The problem

The solution

One flow. Every input type.

The scheduled trigger fires weekly on Thursdays at 10am. It queries ClickUp for all tasks and subtasks with due dates within 7 days back or 7 days forward, includes closed items so 'done last week' is captured, then parses each task's category from a custom field. The 'Productivity' bucket is explicitly filtered out (personal admin, not client-facing). Categories are sorted alphabetically, each rendered as a section with 'Last 7 days' items (name only, no status noise) and 'Next 7 days' items with formatted MM/DD due dates. The final HTML posts to Teams via the Microsoft Teams node.

Results