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

RPRyan Peng · 1 workflow · Updated Nov 13, 2026

UsesClaudeGmailGoogle Sheets

Weekly metrics briefing by email

ScheduleRun every Monday at 07:00.Run every Monday at 07:00.
ValuesSet metricsUrl to blank.Set metricsUrl to blank.
ValuesSet recipientEmail to blank.Set recipientEmail to blank.
ValuesSet metricsTab to Metrics.Set metricsTab to Metrics.
ValuesSet maxRows to 100.Set maxRows to 100.
Google SheetsGoogle SheetsRead the rows of metricsUrl. Save it as sheet.Read the rows of metricsUrl. Save it as sheet.
ValuesSet lines to an empty list.Set lines to an empty list.
Decisions & LoopsFor each measure in sheet.rows:For each measure in sheet.rows:
Decisions & LoopsIf a step below fails, save the error as rowErrorIf a step below fails, save the error as rowError
Try
TextTrim measure.Measure and save it as label.Trim measure.Measure and save it as label.
Decisions & LoopsIf label isn't emptyIf label isn't empty
Yes
ListsAdd - label: this week measure["This week"], last week measure["Last week"] to the end of lines and save it as lines.Add - label: this week measure["This week"], last week measure["Last week"] to the end of lines and save it as lines.
No
No steps
On error
ValuesShow in the output: Skipped a metrics row: rowError as text.Show in the output: Skipped a metrics row: rowError as text.
Decisions & LoopsIf lines is emptyIf lines is empty
Yes
GmailGmailSend an email to recipientEmail.Send an email to recipientEmail. Subject: Weekly briefing - no numbers foundThe metrics sheet had no readable measures this week, so there is no briefing to send. It is worth checking whether whatever fills that sheet is still running.
No
TextJoin lines with a new line and save it as numbers.Join lines with a new line and save it as numbers.
Decisions & LoopsIf a step below fails, save the error as briefingErrorIf a step below fails, save the error as briefingError
Try
ClaudeClaudeAsk Claude: 'Below is this week's numbers from a metrics sheet, one row per measure, with last week's value alongside. Write a short Monday briefing for whoever runs this business.Ask Claude: 'Below is this week's numbers from a metrics sheet, one row per measure, with last week's value alongside. Write a short Monday briefing for whoever runs this business. Lead with what changed and by how much. Say plainly which way each thing moved. Where a number moved a lot, say so; where it barely moved, say that too rather than dressing it up. Rules you must follow: - Use only the numbers below. Do not estimate, annualise, or project. - Do not explain WHY something moved. You cannot know that from a spreadsheet, and a plausible invented cause is worse than none. - If a measure is missing this week's or last week's value, say it is incomplete rather than treating a blank as zero. This week's numbers: numbers'. Save it as written. Maximum response length: 700
TextTrim written.response_text and save it as briefing.Trim written.response_text and save it as briefing.
GmailGmailSend an email to recipientEmail.Send an email to recipientEmail. Subject: Weekly briefingbriefing --- The numbers this was written from: numbers
On error
GmailGmailSend an email to recipientEmail.Send an email to recipientEmail. Subject: Weekly briefing - numbers onlyThe written summary could not be produced this week, so here are the numbers on their own. numbers