Skip to article

How Do I Get an AI Agent to Draft My Monthly Investor Update?

Build an AI agent in Gumloop that drafts your monthly investor update from one sheet and is told to report only its figures, name each row, send nothing.

By Jacqueline V. TwillieNovember 9, 20266 min readGuide
Quick answer

Build an AI agent in Gumloop that reads the one sheet where you keep your numbers and drafts your monthly investor update from it. It's told to report only figures in the sheet, name the row behind each one, and leave a gap where a figure is missing. You read the draft and send it yourself.

The investor update stalls on one decision: which numbers go in every month, including the ones you'd rather skip.

Without that list, you pick again each month and the list moves with the news. Settle the list once and keep it in the sheet; the AI agent's instructions say to report only what's in a row.

The instructions also tell it never to calculate, estimate or send.

Which numbers do you report every month, good or bad?

A new hire preparing this update would ask you the same thing first. In my setup video I said "Think of it like a really smart new hire on your team."

Use one tab. Each row is one metric, in the order investors should read them. Columns: the metric, this month, last month, the change and a note. Write the change as a formula in the sheet.

Two cells above the table hold your headline on the month and your ask of investors, in your own words. A metric you'd rather not feature stays on the list, with a note you wrote.

Work the list out on paper first, as What Should You Do on Paper Before You Build an AI Agent? describes.

What do you paste into the instructions for the investor update?

Copy and fill in
You are my investor update drafter. I'm the [MY ROLE] at [COMPANY NAME] and send every update myself.
My goal each month is a draft for [INVESTOR GROUP] with the same numbers in the same order, good month or bad.
Read only the tab named [TAB NAME] in my sheet [SHEET NAME OR LINK], or in a test copy when I name one. Each row is one metric with this month, last month, the change and my note. [HEADLINE CELL] and [ASK CELL] hold my headline and my ask.
Report a number only if it sits in a cell of that tab. Never calculate, round, estimate or infer one. If a cell is empty, write "not in the sheet" beside that metric and leave the gap.
After every number, name its row, written as (row [ROW NUMBER]).
Write the update in this order: my headline, every metric in sheet order with its value and change, then my ask. Copy my headline and ask as written, and leave me a line to fill if either is empty.
Where a number went down, repeat the sheet's change as written, add no adjectives, and leave a line for my explanation.
Draft only. You never send, schedule or forward anything. Tell me if two cells in the sheet disagree.

How do you build the investor update AI agent in Gumloop?

  1. 01

    Add Google Sheets as the only connector.

    In Gumloop, create a new AI agent and answer guided setup with the job in your own words. Open Connectors, select + Add and pick Google Sheets. The connectors you add define what the AI agent can access, so don't add another. Open the approval icon beside the connector (the default is Always allow) and choose Ask for writes/deletes. Read-only tools run freely and the connector's write, delete and unknown-risk tools stop at an approval card. Checked on 2026-11-11 against the AI agent builder page, Human in the loop and the connector help page.

  2. 02

    Turn off the abilities that reach past the sheet.

    Web Search, Web Fetch and Search Past Tasks are on by default. Switch all three off in the Abilities section, and turn the browser off in the Browser section if it's on. Leave Ask Question on, so it can ask you when the sheet isn't clear. Checked on 2026-11-11 against the abilities table on the AI agent builder page and the browser page.

  3. 03

    Paste the block, then keep instruction changes in your hands.

    Open the tab named Agent, paste the block, fill the brackets and press Save (Ctrl/Cmd + S). Nothing saves until you do. Edit Own Instructions sits under the instructions box, on by default with no version history. Switch it off and press Save again, because a correction made in chat could be written into the instructions and stay there. Keep a copy of your filled instructions elsewhere, and if Reflections is on under Performance, set Apply Suggestions to Review Queue in its settings. Checked on 2026-11-11 against the self-improving instructions section of the AI agent builder page and the Reflections page.

  4. 04

    Compare it with an update you've already sent.

    Open a new task, type "Draft the update for" and the month, and set your sent update beside it. Then copy the sheet, empty one cell in the copy, name it in a new task and run it again. The draft should say "not in the sheet" for that metric.

  5. 05

    Start it yourself when the month is closed.

    Skip the Triggers tab: a Scheduled Trigger runs at a set time, and the sheet isn't necessarily final by then. When the numbers are final, open a new task, name the month, then copy the draft from the task's chat into your own email. Checked on 2026-11-11 against the triggers page and the AI agent builder page.

I am an ambassador for Gumloop. Code VENTURENYC takes 20% off your first month.

How do you know the draft's numbers are the sheet's?

Tick every number against the row it names. A number with no row is your first fix: tighten the line that says to name one.

Ask for a metric the sheet has no row for. The answer should be that the sheet doesn't hold it. If a figure appears, recheck step 02, then tighten the block's line about numbers in cells.

Then run a down month through, on a made-up copy you name in the task and never your real sheet. Lower one value and read the sentences around it: the sheet's change as written, no softening adjective, and a line waiting for your explanation. If the wording leans toward good news, read How Do You Stop an AI Agent Telling You What You Want to Hear?

For the summary at the front of a board deck, read How to Have an AI Agent Fill Your Board Deck Summary Page.

Frequently asked questions

What if a number in the sheet is wrong?

The draft repeats it with its row. Fix the cell and run the task again. The block asks the AI agent to flag two cells that disagree and leaves any single value to you.

Can it explain why a number went down?

Only in the words you wrote. Where a number fell, the block has it leave a line for your explanation, and your note column gives it context.

Can I change which numbers it reports?

Yes. Add or remove a row in the sheet. The instructions say every metric in sheet order, and you don't need to touch the rules you pasted.

More on Data for Corporate Executives