Weekly open items digest to Slack

Once a week, your tracker spreadsheet is read, every row not marked done is gathered up, and the lot is posted to a Slack channel as a single digest. Above the list sit two or three sentences from the AI on what stands out: what is blocked, what is overdue and who is carrying the most.

You get a message headed with the number of open items, each listed with its owner and status. It posts even when there is nothing open, because a digest that goes quiet looks the same as one that has broken, so an empty week gets an explicit nothing open message. If the summary cannot be written, the digest still goes out with the list intact and a note that the summary was unavailable. A row with a missing task or status is skipped and logged rather than quietly shortening the list.

Your tracker tab needs 'Task', 'Owner' and 'Status' columns, and you need a Slack channel for the digest.

Run every 7 days.Run every 7 days.

Set spreadsheetUrl to blank.Set spreadsheetUrl to blank.

Set slackChannelId to blank.Set slackChannelId to blank.

Set trackerTab to Tasks.Set trackerTab to Tasks.

Set maxRows to 300.Set maxRows to 300.

Set doneValue to done.Set doneValue to done.

Google SheetsRead the rows of spreadsheetUrl. Save it as sheet.Read the rows of spreadsheetUrl. Save it as sheet.

Set openItems to an empty list.Set openItems to an empty list.

For each row in sheet.rows:For each row in sheet.rows:

If a step below fails, save the error as rowErrorIf a step below fails, save the error as rowError

Try

Make row.Status lowercase and save it as status.Make row.Status lowercase and save it as status.

If status is not doneValueIf status is not doneValue

Yes

Add - row.Task (owner: row.Owner, status: row.Status) to the end of openItems and save it as openItems.Add - row.Task (owner: row.Owner, status: row.Status) to the end of openItems and save it as openItems.

No

No steps

On error

Show in the output: Skipped a tracker row: rowError as text.Show in the output: Skipped a tracker row: rowError as text.

If openItems is emptyIf openItems is empty

Yes

SlackSend a message to slackChannelId.Send a message to slackChannelId.*Weekly open items* Nothing open - every tracked item is done.

No

Join openItems with a new line and save it as itemList.Join openItems with a new line and save it as itemList.

If a step below fails, save the error as summaryErrorIf a step below fails, save the error as summaryError

Try

ClaudeAsk Claude: 'Below is a list of open items from a team tracker. Write a short Slack digest: two or three sentences on what stands out - what is blocked, what is overdue, who is carrying the most - then leave the list itself out, it is posted separately. Use only what is in the list; do not invent status or deadlines.Ask Claude: 'Below is a list of open items from a team tracker. Write a short Slack digest: two or three sentences on what stands out - what is blocked, what is overdue, who is carrying the most - then leave the list itself out, it is posted separately. Use only what is in the list; do not invent status or deadlines. itemList'. Save it as written. Maximum response length: 400

Trim written.response_text and save it as summary.Trim written.response_text and save it as summary.

SlackSend a message to slackChannelId.Send a message to slackChannelId.*Weekly open items* (the length of openItems as text) summary itemList

On error

SlackSend a message to slackChannelId.Send a message to slackChannelId.*Weekly open items* (the length of openItems as text) _Summary unavailable this week._ itemList