Weekly open items digest to Slack
Reads your tracker each week and posts everything still open to Slack, with a short note on what stands out.
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 tracker tab with its header row, so each row's 'Task', 'Owner' and 'Status' columns can be checked.
If
openItemsis empty- 2SlackSend messagePosts the digest with the open item count, summary and list, or a nothing open message when everything is done.
Otherwise
Try
- 3AnthropicGenerate model responseAsks the AI for a few sentences on what is blocked, overdue or piling up on one person, using only the list.
- 4SlackSend message
If a step fails
- 5SlackSend message
- 3
- 2
How it works
What happens on each run, in plain English.
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.
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.
Track a property market over timeSearches one property site each week, records the listings that are new to you, and logs how the record has changed.
Summarise and index new documents in a Box folderChecks a Box folder hourly and gives each new PDF its own summary document and one row in your index sheet.
Digest the sources you watch into SlackReads the pages you name each morning, keeps only the lines matching your brief, and posts them to Slack with their source.
Start from a workflow that already works.
Add "Weekly open items digest to Slack" to your workspace, connect its apps, and make it yours. No credit card required.
Free plan available · No credit card required