How Should an AI Agent Track Quarterly OKRs From My Team's Sheet?
Build an AI agent in Gumloop that sets your OKR sheet beside the last copy and lists what moved, stalled or was edited. It's told to calculate nothing.
From two snapshots of your OKR sheet, the one your team updates now and the copy you saved at the last review, an AI agent in Gumloop lists what moved, what stalled and what was edited after the fact, with the two values the sheet shows. It's told to calculate nothing and explain nothing.
"At the last review this result was further along. What changed?" Someone asks that about one key result in the quarterly review, and it lands on whoever has the sheet open.
Answering it takes two pictures of the sheet. A sheet that's updated in place holds only the latest values, so last review's version is gone unless someone saved a copy.
The AI agent reads both pictures each run. It sets this snapshot's rows beside the last snapshot's and reports what moved, what stalled and what was edited after the fact, with the two values the sheet holds beside each row. Its instructions tell it not to calculate anything the sheet doesn't show and not to explain anything.
What counts as moved, stalled or edited after the fact?
Moved is a result whose value column holds something different from the last snapshot. The list shows the old value, then the new one, as each cell reads.
Stalled is a result that isn't finished and holds the same value in both snapshots. An owner may have done work that never reached a value column.
Edited after the fact is a cell that was supposed to stay put and didn't: a target, the wording of a key result, an owner, or a row found in only one snapshot.
How do you build the quarterly results comparison in Gumloop?
- 01
Save a frozen copy of the tab and give every row a fixed ID.
Duplicate the tab your team updates, name the copy for the date of the review and leave it alone. That copy is the last snapshot. Add an ID column (KR-01, KR-02 and so on) and keep each ID with its row.
- 02
Add Google Sheets to the AI agent and read both tabs back.
Open Gumloop, start a new AI agent and describe the job in a sentence. On the tab named Agent, expand Connectors, click Add, search for Google Sheets and sign in. The connector page doesn't describe reading a named tab, so ask in chat for the first row of each tab by name. If it can't reach one, paste that tab in with its name on the first line; What If the Tool I Need Has No Connector? shows other routes. Checked on 2026-11-11 against Gumloop's AI agent builder page and Gumloop's connector help page, which names Google Sheets among its built-in connectors.
- 03
Turn off the connector's tools that change the sheet.
Click the approval icon beside the connector and change Always allow, Gumloop's default, to Ask for writes/deletes. Then open the connector and turn off any tool that writes. The connector page doesn't list its tools, so read the list in your account. Checked on 2026-11-09 against Human in the loop and Gumloop's connector help page.
- 04
Paste the instructions and keep the AI agent from editing them.
Paste the block below into the instructions box on the tab named Agent and fill the brackets. Then switch off Edit Own Instructions, the toggle under the box that lets a chat correction rewrite the instructions, and press Save. A remark such as "treat this one as moved" is meant for one row, and with the toggle off you change the instructions by editing the box. If Reflections is on under Performance in the sidebar, open its settings (the icon on the Reflections header) and set Apply Suggestions to Review Queue, so a change it suggests to the instructions won't apply until you accept it. Checked on 2026-11-11 against Gumloop's AI agent builder page and Gumloop's Reflections page.
- 05
Change two cells in a spare copy and see if it names them.
Duplicate the last-snapshot tab and, in the spare, change one value and one target. Tell the AI agent the spare is this snapshot for the test. The value should land under Moved, the target under Edited after the fact, and every other unfinished row under Stalled. If a row you didn't touch is listed, compare its two cells character by character before you blame the instructions.
I am an ambassador for Gumloop. Code WOMENINAI takes 20% off your first month.
What do you paste into the instructions for the quarterly results comparison?
You compare two snapshots of my results sheet. I'm the [YOUR ROLE] at [YOUR ORGANIZATION], and the sheet tracks our [PERIOD, FOR EXAMPLE QUARTERLY] objectives and key results. The tab "[THIS SNAPSHOT TAB]" is the sheet as it stands now. The tab "[LAST SNAPSHOT TAB]" is the copy I saved at the last review. Match rows by the value in the "[ID COLUMN]" column. The value columns are [VALUE COLUMNS]. The columns that shouldn't change between snapshots are [FIXED COLUMNS, SUCH AS WORDING, TARGET AND OWNER]. A row is finished when "[STATUS COLUMN]" says "[FINISHED STATUS]". Report only these three lists: 1. Moved: rows where a value column differs. Show the last snapshot's value, then this snapshot's, copied exactly as the sheet shows them. 2. Stalled: rows that aren't finished and whose value columns are identical in both snapshots. Show the value once. 3. Edited after the fact: rows where a fixed column differs, and rows found in only one snapshot. Show the old and new cell exactly as written. End every row with an empty line that reads "Owner's explanation:". Never write it yourself. Use only numbers the sheet shows. Don't subtract, total, round, convert to a percentage or judge pace. If a tab is missing or unreadable, say so and stop. You have read access only. Be direct with me.
Which rows deserve a question before anyone else asks it?
Read Edited after the fact before the other two lists and ask each owner why, starting with any target on it.
Run it the day before the review. A row under Moved with a lower value is the question from the review itself, and its explanation line shouldn't hold anything yet. If it holds text the AI agent wrote, read the box to see whether a line in the instructions has changed.
If nearly every row lands under Stalled, check that someone's updated the tab that holds this snapshot. A renamed column is a reason to open the block early. For a weekly read across departments, use Can an AI Agent Brief Me on Five Departments Every Monday?.
Frequently asked questions
What if I have no copy from the last review?
Make one now. The block has the AI agent say a tab's missing and stop, so the comparison starts at your next review.
Who writes the explanation for a result that slipped?
Its owner types it on the empty line the AI agent leaves under the row. The instructions tell the AI agent not to write it.
What happens when someone rewords a key result mid-quarter?
The ID still matches the row, so the old and new wording show up under Edited after the fact. A row whose ID changed appears there too, as a row found in only one snapshot.