Weekly chart of how a metric has moved
Every Monday, charts the recent history of one metric from your sheet and emails you the chart with a note on what changed.
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.
- 1Google SheetsRead rowsReads the history tab and keeps the rows whose measure matches the one you named, in the order they appear.
- 2QuickChartCreate line chartDraws a line chart of the most recent readings, one point per period, titled with the measure's name.
- 3AnthropicGenerate model responseAsks the AI for two or three sentences on how the readings moved, with no forecast, target, advice or explanation of why.
- 4GmailSendEmails you the chart link, the note and the readings underneath, or a message saying no readings matched the measure.
How it works
What happens on each run, in plain English.
Every Monday at 08:00, the measurement history you keep in Google Sheets is read, the measure you name is drawn as a line chart of its most recent readings, and the chart is emailed to you with a short note from the AI on how the numbers have moved.
The note describes only what the readings show: no forecast, no target, no advice and no explanation of why anything moved, because a list of numbers cannot tell you that. The readings are printed underneath, so nothing in the note has to be taken on trust. A value can be written with currency signs, commas or percentages and still read fine, and a row with no readable number is listed as left off rather than counted as zero. If the chart cannot be drawn the readings are still emailed, and if nothing matches the measure you get an email saying so.
The tab needs one row per reading with 'Period', 'Measure' and 'Value' columns, oldest at the top. The email carries a permanent link to the chart image rather than an attachment.
You May Also Be Interested In
Extract purchase orders from GmailReads each new purchase order email, looks its items up in your product list, and logs every line with name and price.Monthly P&L report for each cost centerOn the 3rd of each month, turns last month's transactions in your sheet into a P&L for each cost center, with AI commentary.Weekly revenue up-or-down emailEvery Monday, totals last week's revenue from your sheet, says if it is up or down on the week before, and explains a rise.Weekly employee feedback digestEvery Monday, the week's feedback form responses summarized for HR and emailed, then cleared from the sheet.
Start from a workflow that already works.
Add "Weekly chart of how a metric has moved" to your workspace, connect its apps, and make it yours. No credit card required.
Free plan available · No credit card required