All workflows
Google Sheets logoGmail logoAnthropic logo

Weekly metrics briefing by email

Every Monday, reads your metrics sheet and emails a short written briefing on what moved and by how much.

Every Monday at 07:003 apps5 steps

Apps it connects

Authenticate each one once and the workflow is ready to run.

What it does

Each integration step this workflow runs, in order, what it is for, and the conditions and loops that decide when it runs.

  1. 1Google SheetsRead rowsReads the 'Metrics' tab, taking each measure's name with this week's and last week's values and skipping unreadable rows.
  2. If lines is empty

    1. 2GmailSendSends you the briefing and its numbers, the numbers alone if the summary failed, or a note that the sheet was empty.

    Otherwise

    1. Try

      1. 3AnthropicGenerate model responseAsks the AI for a short Monday briefing on what moved and by how much, using only the numbers, never explaining why.
      2. 4GmailSend

      If a step fails

      1. 5GmailSend

How it works

What happens on each run, in plain English.

Every Monday at 07:00, the 'Metrics' tab of your spreadsheet is read, one measure per row with this week's and last week's values, and the AI writes a short briefing on what changed, which way and by how much. It is emailed to you with the numbers it was written from underneath.

The briefing is told not to explain why anything moved, because a spreadsheet cannot tell you that and a plausible invented cause is worse than none. It is also told not to estimate, annualise or project, and to call a measure incomplete rather than treat a blank cell as zero. If the sheet has no readable measures you get an email saying so, since an empty sheet usually means something upstream stopped running. If the summary cannot be written, the numbers are sent on their own. Nothing in the sheet is changed.

You need a spreadsheet with a 'Metrics' tab holding 'Measure', 'This week' and 'Last week' columns.

google sheetsgmailmetricsbriefingweeklyai

Start from a workflow that already works.

Add "Weekly metrics briefing by email" to your workspace, connect its apps, and make it yours. No credit card required.

Free plan available · No credit card required