How Do I Get an AI Agent to Merge Country Team Program Reports?
Build an AI agent in Gumloop that sets each country team's definitions beside yours first, then drafts one account with every team's figures as written.
Build an AI agent in Gumloop that reads the program reports your country teams send. Before it writes a sentence, it builds a table of what each team calls a participant, a session and a completion, set against your definitions. Once you settle every mismatch, it drafts one account and keeps each team's figures as written.
The first team's report ends in a set of totals, and so does the second's. By the third you're stopping at the same word, participants, and writing to a team lead to ask what the report counted. When the answer comes, you carry it back in your head and start the sentence again.
The figures sit side by side before anyone has checked that they measure the same thing.
This AI agent changes the order. It builds the comparison of definitions first and shows you where the teams don't match. It writes the account only after you've settled those places, and its instructions tell it not to add up figures from teams whose definitions differ.
What does the table show before anything is written?
One row for each term you want to compare, such as participant, session and completion. Your definition comes first in the row. Beside it sits each team's own word for the term, with the exact words its report uses about what it counted.
Every row is marked Matches, Differs or Not stated. A Differs row names the teams that differ. A Not stated row means a report uses the term and never says what it covers, and the block tells the AI agent not to guess.
You settle the rows. For a Differs row that might be a ruling, such as "report this team's figure under its own term and label it." For a Not stated row it's a question to the team. Then the account starts, with each team's figures exactly as its report prints them.
How do you build the report-merging AI agent in Gumloop?
- 01
Write what each count means to you, in your words.
Before you open a report, write a sentence for each term you'll compare. These go into the block as your definitions. If you can't say what a completion is, that's the first row you'll settle.
- 02
Set up the two-stage job and paste the block.
In Gumloop, start a new AI agent, and if guided setup asks what it should take care of, answer "turn country team program reports into one account for leadership." Open the tab named Agent, paste the block from the next section into the instructions box and press Save, because nothing saves until you do. Checked on 2026-11-09 against Gumloop's AI agent builder page.
- 03
Have definitions come from the teams and from you.
In the Abilities section, switch off Web Search and Web Fetch, turn the browser off in the Browser section if it's on, and add no connectors. Checked on 2026-11-11 against the abilities table on Gumloop's AI agent builder page, which lists both as on by default, and Gumloop's AI agent browser page, which says a new AI agent gets the browser by default when its creator is allowed to use it.
- 04
Paste the reports and ask for the table.
Open a task, paste each team's report under the team's name and type: build the table.
- 05
Answer every row, then type settled.
Answer each Differs row with your ruling and each Not stated row with what the team told you. Type "settled" only when no row is open. The block has the AI agent print the settled table again before it writes, because Gumloop summarizes older messages when a task nears its context budget and keeps recent ones in full. Checked on 2026-11-09 against the task summarization section of Gumloop's AI agent builder page.
- 06
Keep each ruling for the next report.
When you settle a row, tell the AI agent: "Update your instructions so you always do it this way." The toggle named Edit Own Instructions sits right under the instructions box and is on by default, and there's no version history, so copy the block out before the first ruling. Checked on 2026-11-09 against the self-improving instructions section of Gumloop's AI agent builder page.
- 07
Compare the table with a merge you did by hand.
Run two reports you've combined yourself through it. The rows should show the mismatches you remember chasing. If it finds one you never caught, open both reports and read the quoted words.
I am an ambassador for Gumloop. Code NONPROFITAGENTS takes 20% off your first month.
What do you paste into the instructions for the country report account?
The terms and your definitions in the brackets come from step 01.
You help me, [YOUR NAME], [YOUR ROLE] at [ORGANIZATION], turn the program reports from our country and regional teams into one account for [LEADERSHIP AUDIENCE]. I'll paste each team's report under the team's name. Work in two stages. Don't start the second until I write "settled." Stage one: build a table with one row for each of these terms: [TERMS TO COMPARE]. Put my definition first: [YOUR DEFINITIONS]. Then give each team's own word for the term and the exact words its report uses to say what it counts. Mark the row Matches, Differs or Not stated, and name the teams that differ. If a report doesn't say how it counts something, write "Not stated" and don't guess. Stage two: print the settled table again. Then write the account in plain sentences. Give each team's figures exactly as its report prints them, with the team's name and reporting period beside each figure. Don't add, average or compare figures from teams whose rows differ. Where every team's row matches, list the figures side by side so I can add them myself. If a team's report is missing, say so. If a settled row no longer fits how a team's new report describes its count, show that row as open again. Don't send anything.
Which rows of the first table deserve a second look?
Start with a Matches row. Its quotes should say the same thing, even in different words. A row that matches only because both teams used the same word is the one to open.
Pick three figures in the account and find each in its report. A figure you can't find was changed somewhere, so reread the block's line about printing figures exactly as written.
When a team never says how it counts, ask its lead. If the account becomes a section of a larger packet, the packet around it comes from How Do I Get an AI Agent to Draft a Board Packet From Team Reports?. For teams that still owe data, use Who Still Owes Your Impact Report Data? Ask an AI Agent to Check to check each submission.
Frequently asked questions
What if two teams use the same word and count different things?
The table puts each team's exact words beside the shared term, so the row should show Differs even when the word matches. Your ruling decides how the account labels each team's figure.
Where does a total come from when every row matches?
From you. The account lists the matching figures side by side with the team and period beside each, and you add them.