How Do I Get an AI Agent to Draft Weekly Client Status Reports?
Build an AI agent in Gumloop that drafts each client's weekly status report from your tracking sheet and names the row behind every line, for you to send.
Build an AI agent in Gumloop that reads the tracking sheet your team already keeps and drafts one status report per client each week. It's told to report only what the sheet says, name the row behind every line and mark a client whose rows didn't change, and it leaves the sending to you.
Somebody on your team scrolls the tracking sheet each week to write each client's status update.
What does your tracking sheet need before the drafts can work?
One tab, with one row for each item you're tracking for a client, and columns for a row number, the client, the item, its status, the date the row was last updated, the owner and a note. Number the rows 1, 2, 3 in a column headed Row. If your rows carry no date, add a Last updated column and start filling it in this week. The instructions judge a week by that column alone, and a row nobody dated is listed as undated.
How do you build the client status report AI agent in Gumloop?
- 01
Point it at the tab your team already keeps.
In Gumloop, create a new AI agent and describe the job in a sentence. On the tab named Agent, open Connectors, select + Add and search for Google Sheets, which Gumloop's help page lists among its built-in connectors. Don't add another connector. Open the connector and turn off any tool whose name says it writes, adds or deletes. The linked pages don't list that connector's tools, so read the names in your own account. What Are Read-Only Tools for AI Agents? explains the difference. For whatever stays on, open the approval icon beside the connector and choose Ask for writes/deletes. Gumloop's default is Always allow. Checked on 2026-11-11 against Gumloop's help page on connectors, Human in the loop and Gumloop's AI agent builder page.
- 02
Save the block below as the instructions, with Edit Own Instructions off.
Open the tab named Agent, paste the block and fill the brackets. Edit Own Instructions sits under the instructions box. Turn it off, then press Save. A fix typed in chat, like "just call it on track," could be written into the instructions. To change the format, edit the instructions yourself and save. Checked on 2026-11-11 against the self-improving instructions section of Gumloop's AI agent builder page.
- 03
Read the first drafts with the people who own the clients.
Open a new task and type "Draft the client status reports for the week ending" and a date. Hand each draft to the person who owns that client. They'll read it against what they know, and every line should name a row they can open. Read each "No rows changed" line twice. It means either nothing happened or nobody updated the sheet, and only the owner can say which.
- 04
Set a Thursday trigger, then send the drafts yourself.
Open the Triggers tab, select Add trigger and choose Scheduled Trigger. Describe the schedule in plain language, such as every Thursday afternoon, for a time after your team has updated the sheet. The AI agent processes the trigger's prompt as if you'd typed it in chat: "Draft this week's status report for every client in the sheet." Find the drafts on the Tasks page with the Source filter set to Triggered by Schedule. Don't add an email connector. Copy each draft into your own email, add what the sheet can't know and send it. Checked on 2026-11-09 against Gumloop's triggers page and the Tasks section of Gumloop's AI agent builder page.
I am an ambassador for Gumloop. Code SMBIZ takes 20% off your first month.
What do you paste into the instructions for the weekly status drafts?
You are my weekly client status drafter. I'm the [MY ROLE] at [COMPANY NAME], and I send every report myself. My goal each week is one draft per client that says only what the tracking sheet says. Read only the tab named [TAB NAME] in my sheet [SHEET NAME OR LINK]. The columns are Row, Client, Item, Status, Last updated, Owner and Note. The reporting week is the seven days up to and including the most recent [WEEK END DAY]. For each client, write a draft I can paste into an email. Start with one headline sentence, then one line for each row whose Last updated date falls inside the reporting week, using the Item and Status as written. Then list any row whose Status says [BLOCKED WORD]. After every line, name its row, written like (row 12), using the number in the Row column. If a client has no row dated inside the reporting week, write "No rows changed since" and the latest date in that client's rows, name that row, and leave out everything else about the client except undated rows. If a row has no date, list it as undated and leave the decision to me. Never calculate, estimate, soften or infer. If I ask about something that isn't in the sheet, say so. Drafts only. You never send, schedule or forward anything.
What should a quiet client's line tell you in the first three weeks?
Start with the quiet clients. If an owner says work happened and the sheet says no, the fix is your team's habit of dating rows, and you leave the instructions as they are.
Then read one line the way the client would. The AI agent repeats the Item and Status as written, so your team's shorthand shows up in the draft. Fix the sheet if it keeps coming back. When a project ends, open What Should an AI Agent Capture When a Project Closes? for the case note.
Frequently asked questions
What if my team doesn't date its rows?
Add a Last updated column before you build, and have whoever touches a row date it. Until then the draft lists every row as undated.
Can it send each report to the client?
It has no email connector to send with, so you copy each draft from the task.
What about work that happened on a call and never reached the sheet?
Whoever was on the call types it into the sheet as a dated row. The draft is built from what the rows hold, so a call missing from the sheet shows up as a quiet client.