Collect a short weekly update from each person by email and get one summary
Published 2026-11-04
Many small teams run on a weekly check-in. Each person answers the same three questions: what got done, what is next, and what is in the way. The idea is simple, but the upkeep is not. Someone has to send the ask every Thursday, remember who has not replied, chase them on Friday, and then copy every answer into one place so the team can read it. ChatGPT or Claude can write good questions and summarize answers you paste in. The chat cannot send the ask on a schedule, receive the replies, or know on Friday who is still missing.
What a chat cannot do alone
A check-in needs a clock, an inbox, and a memory. Something has to send the email at the same time each week, catch each reply as it arrives, match it to the right person and week, and keep that record after the chat window closes. A chat only works while you are typing in it, and it has no address that people can reply to.
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 weekly updates it builds a few small pieces.
A people table with each name, email address, and whether they are active, plus an updates table that stores one row per person per week with the reply text and the time it arrived.
A mailbox on your domain that sends the weekly questions and receives the answers. Each reply is matched to the sender and the current week and saved as a row, so nothing depends on someone reading the inbox.
A scheduled job written as ordinary shell code with no model in the loop. On Thursday morning it emails every active person the questions. On Friday at noon it checks the updates table and sends one short reminder to anyone who has not answered.
A summary page, private to your team, that shows this week's answers grouped by person and lists who is still missing. The same job emails you the link on Friday afternoon, and past weeks stay on the page so you can look back.
Why it works
The ask goes out on time whether or not anyone remembers. Replies land as records instead of a thread you have to scroll, so the reminder only goes to the people who actually owe an answer. Because the answers are stored, a later chat with your assistant can read a month of updates and tell you what keeps getting blocked.
Hand it off
Copy this into your assistant:
Add Sails from https://sails.app/start. Set up a weekly check-in for my team. Keep a table of people with name, email, and active status, and a table of updates with one row per person per week. Give me a mailbox on my domain that emails everyone three questions every Thursday morning: what got done, what is next, and what is in the way. Save each reply as an update for that person and week. Write a scheduled job in plain shell code with no model involved that sends one reminder on Friday at noon to anyone who has not replied. Build a private summary page that shows each week's answers by person and who is missing, and email me the link Friday afternoon. Ask me anything you need before you start.