Routines
Weekly numbers note
weekly-numbers
Read this week’s figures from the sheet you name, write one page, and mark cells that are missing compared with last week.
for Grok Bot · unofficial, not affiliated with xAI
CNPS0.1.02026-11-18New
Paste this into Grok Bot and say: create this routine.
Create this routine: Weekly numbers note
Trigger: Once a week, read only the spreadsheet and tab you name.
What to do:
1. Reads only the spreadsheet and tab you name.
2. Pulls the metric names you listed.
3. Writes a gap as a gap. It does not fill zero or invent a ratio.
How:
1. Name the sheet, the tab, and the metric names in the routine.
2. Keep the sheet connector read-only.
3. Write outputs/weekly-numbers.md.
4. Check one week by hand. If a figure disagrees with the sheet, stop.
Rules you can keep:
Read the named tab of the named sheet.
Pull only the metrics the user listed. If a metric is not in the sheet, write "no such row".
If a previous column exists, write this week's value. Do not compute a ratio the user did not ask for.
Leave an empty cell as "empty". Do not write 0.
Write outputs/weekly-numbers.md.
Do not edit the sheet or add a column.
Do not:
- Do not post the numbers to chat or to a public place.
- Do not keep using this routine if the account can edit cells.
- Do not write an empty cell as 0, and do not edit cells.
Paste this into Grok Bot and say: create this routine.What it does
- Reads only the spreadsheet and tab you name.
- Pulls the metric names you listed.
- Writes a gap as a gap. It does not fill zero or invent a ratio.
Who it is for
People who explain a sheet to a team every week.
How to put it in Grok Bot
- Name the sheet, the tab, and the metric names in the routine.
- Keep the sheet connector read-only.
- Write outputs/weekly-numbers.md.
- Check one week by hand. If a figure disagrees with the sheet, stop.
Example
Routine snippet
Read the named tab of the named sheet.
Pull only the metrics the user listed. If a metric is not in the sheet, write "no such row".
If a previous column exists, write this week's value. Do not compute a ratio the user did not ask for.
Leave an empty cell as "empty". Do not write 0.
Write outputs/weekly-numbers.md.
Do not edit the sheet or add a column.Connectors it needs
Safety and permissions
- Do not post the numbers to chat or to a public place.
- Do not keep using this routine if the account can edit cells.
- Do not write an empty cell as 0, and do not edit cells.
Risk: Medium
Questions
Can it draw a chart?
No. This one writes the figures and the gaps. A chart implies math you did not ask for.
The workbook has many tabs.
Name one. Run again for a second tab and say so. Do not mix two years in one pass.
0.1.0
2026-11-18
First published text. Reads numbers. Does not fill zeros.