Email a weekly digest of everything still open
Published 2026-10-14
Every small team carries a quiet pile of unfinished work: payments waiting on a reply, customers who have not confirmed, items still missing a document, questions that never got an answer. You know the pile exists. What you do not have is a single place that lists it, or a moment each week when the list shows up in your inbox without you rebuilding it. So Monday starts with scrolling, searching, and asking people what is still open.
What a chat cannot do alone
ChatGPT or Claude can help you write a summary if you paste everything in. It cannot keep the list between conversations, notice when a row changes during the week, or email you on Friday with only what is still open. A chat has no clock and no mailbox. A calendar reminder just tells you to do the work yourself. A scheduled prompt can wake a model each week, but then the model has to invent the list from whatever you left in the thread, which is expensive and unreliable for a job that is really just filtering rows.
What your assistant builds with Sails
Sails is a coding agent you connect over MCP, with cloud deployment built in. Your assistant writes the code and Sails runs it in the cloud. For this job it builds three pieces.
A table of open items. Each row has a short description, who it belongs to, a due date if there is one, a status such as open, waiting, or done, and an optional note. You and your assistant add and update rows as work moves. When something closes, the status changes once, and it drops out of the digest.
A mailbox. The digest goes out from an address you own, so it lands in the same place as your other mail and you can reply or forward it. If you want a copy for a teammate, the job can send to more than one address.
A scheduled job. It is ordinary shell code that runs every Friday morning. It reads every row whose status is still open or waiting, groups them by person or by due date, and emails a short digest: what is overdue, what is due next week, and what is waiting on someone else. There is no model in the loop. The job filters the table and sends mail the same way every time.
Why it works
The list lives in one table, so the digest cannot drift from what you actually track. You stop rebuilding the same summary from memory or from a dozen threads. When something is done, you mark the row and next Friday it is gone. When something new arrives, you add a row and it shows up without a separate note to yourself.
Because the job is plain code on a schedule, it runs whether or not anyone opens a chat that week. The cost is almost nothing. The value is that Monday starts from a real list instead of a scavenger hunt.
Hand it off
Copy this into your assistant:
Add Sails from https://sails.app/start. Build me a weekly digest of open items. Create a table with description, owner, due date, status (open, waiting, done), and notes. Write a scheduled job that runs every Friday morning as plain shell code with no model involved, selects rows that are still open or waiting, groups them by owner and by overdue vs due next week, and emails the digest from my mailbox to [addresses]. Show me how to add and close rows, then send a sample digest with a few example items. Ask me anything you need before you start.