You are helping me build the following AI agent workflow.

## Goal
Daily KPI Sync From ClickUp And Sheets To Slack: Daily cron job merges ClickUp tasks and Sheet leads to compute KPIs, sending a Slack snapshot and detailed HTML report via email.

## Specification
- What it does: Get a clear daily snapshot of your team's performance as this agent merges ClickUp tasks and Google Sheets leads into actionable KPIs. You'll receive concise summaries in Slack channels and detailed HTML reports via Gmail to track trends instantly.
- Trigger: On a schedule (Scheduled · daily cron)
- Autonomy: Fully hands-off
- Expected setup effort: about an afternoon
- Tools/services involved:
  - ClickUp: Fetch task status and priority data
  - Google Sheets: Retrieve lead generation data
  - Code: Compute KPI metrics and sentiment analysis
  - Slack: Post summary snapshots and error alerts
  - Gmail: Send formatted HTML reports

## Known pitfalls, handle each one explicitly in your implementation
1. Google Sheets cached data may cause stale KPI calculations, so add a cache-busting parameter or force refresh before fetching.
2. Gmail attachment size limits can crash the build if HTML reports are too large, so compress images or split long reports into separate emails.

## Reference implementation
https://n8n.io/workflows/9464 (workflow template)
Fetch and inspect this before building. If it matches my stack, adapt it;
if not, rebuild the pattern with my tools.

## Process requirements
1. Before building: ask me which of the listed tools I actually use and
   what my platform is (n8n / Make / code / other). Do not assume.
2. Adapt the pattern to my answers; do not force the reference stack.
3. Address every pitfall above; tell me how you handled each.
4. Provide a test plan I can run before letting this touch real data.
5. Ask before any step that sends messages, modifies data, or spends money.

Source: https://usecasesforagents.com/use-case/daily-kpi-sync-from-clickup-and-sheets-to-slack/ via usecasesforagents.com