Skip to content

Unofficial community registry. Not affiliated with, endorsed by, or sponsored by xAI.

中文

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

  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.

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.