Post KPI Snapshots to Slack Automatically

export async function GET() {
  // Pull metrics from your database
  const metrics = await getWeeklyMetrics();

  // Mint the KPI image URL
  const res = await fetch("https://api.htmlpix.com/v1/url", {
    method: "POST",
    headers: {
      Authorization: `Bearer ${process.env.HTMLPIX_KEY}`,
      "Content-Type": "application/json",
    },
    body: JSON.stringify({
      templateId: process.env.KPI_TEMPLATE_ID,
      variables: {
        title: "Weekly KPI Report",
        period: metrics.period,
        metric1Label: "MRR", metric1Value: metrics.mrr, metric1Delta: metrics.mrrDelta,
        metric2Label: "Active Users", metric2Value: metrics.dau, metric2Delta: metrics.dauDelta,
        metric3Label: "Churn Rate", metric3Value: metrics.churn, metric3Delta: metrics.churnDelta,
        metric4Label: "NPS", metric4Value: metrics.nps, metric4Delta: metrics.npsDelta,
        companyName: "Acme Corp",
      },
      width: 800,
      height: 500,
    }),
  });
  const { url: imageUrl } = await res.json();

  // Post to Slack
  await fetch(process.env.SLACK_WEBHOOK_URL!, {
    method: "POST",
    body: JSON.stringify({
      blocks: [{ type: "image", image_url: imageUrl, alt_text: "Weekly KPI" }],
    }),
  });

  return Response.json({ ok: true });
}