Skip to article

Who Still Owes Your Impact Report Data? Ask an AI Agent to Check

Build an AI agent in Gumloop that lists what the impact report needs from each team, marks what arrived, and drafts a reminder naming only what's missing.

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

From last year's outline and your list of who supplies what, an AI agent in Gumloop builds the list, checks each field team's submission against it, marks each item arrived, missing or unusable, and drafts one reminder per team with your date. Its instructions bar estimates, and you send each reminder.

It's the week the annual impact report goes to design, and one section is still empty. You open last year's report to remember what that section held.

The question that week is which team owes what, and answering it means rereading last year's report and each submission, item by item.

From last year's report outline and your list of who supplies what, the AI agent builds the full list of data points and stories the report needs.

What does the list show for each field team?

Each team gets its own list, one line per item the report needs from it, and every line carries one of three marks. Arrived means the item is in the submission, and the line names the place it was found. Missing means it isn't there. Unusable means it's there in a shape the report can't use, and the line quotes what was sent and names what's absent from it: a different reporting period, a total with no breakdown, a story with no consent line. You name those tests in the block.

The block bars it from filling a gap with an estimate or changing a figure a team sent, and a team whose items all arrived gets no reminder. Whether two teams count the same way is a separate job, and How Do I Get an AI Agent to Merge Country Team Program Reports? covers it once the submissions are in.

What do you paste into the instructions for the impact report tracker?

Your tests for an unusable item go in the second paragraph's bracket, and your date in the last.

Copy and fill in
You help me, [YOUR NAME], [YOUR ROLE] at [ORGANIZATION], collect what our field teams owe for the annual impact report. I'll paste last year's report outline, my list of who supplies what, and each team's submission under the team's name.

First, build the full list of data points and stories the report needs, section by section, from the outline. Beside each item write the team that supplies it and the form the report needs: [REQUIRED FORM, FOR EXAMPLE REPORTING PERIOD, BREAKDOWN AND CONSENT LINE].

Then check each team's submission against its items and mark each one Arrived, Missing or Unusable. For Arrived, name the place it was found. For Unusable, quote what was sent and name what's missing from it. Don't judge whether a figure is right, and don't compare teams.

Never estimate a missing figure or change a number a team sent. Copy every figure exactly as written.

For each team with Missing or Unusable items, draft one reminder that names exactly those items, says what is wrong with each, and asks for them by [REMINDER DATE]. Send nothing. If something is unclear, say so and ask me.

How do you build this AI agent in Gumloop?

  1. 01

    Pair last year's outline with a list of who supplies what.

    Paste the headings of last year's report into a document and write beside each section which teams supply it and who sends it. Where a section needs a story, add the consent line you require.

  2. 02

    Open Gumloop and save the block as the instructions.

    In Gumloop, start a new AI agent and describe the job in a sentence. On the tab named Agent, paste the block into the instructions box and press Save. Checked on 2026-11-09 against Gumloop's AI agent builder page.

  3. 03

    Paste each submission, or connect the sheet it lives in.

    Pasting needs no setup: put each team's submission into the task under the team's name, and skip this step and the next. If your teams fill in a shared Google Sheet, expand Connectors on the tab named Agent, click Add, search for Google Sheets and sign in. Checked on 2026-11-09 against Gumloop's connector help page.

  4. 04

    Make the sheet connector ask before anything that writes.

    Change the approval beside it from Always allow, Gumloop's default, to Ask for writes/deletes, so a tool that writes waits for you. The help page doesn't list the tools, so read them in your account. Checked on 2026-11-11 against Human in the loop and Gumloop's connector help page.

  5. 05

    If your teams answer through a form, check what Gumloop can read.

    Gumloop's triggers page lists Google Forms as an app trigger that fires when a new response is submitted. It doesn't say whether Forms is also a connector with tools for reading responses. Search for it in the Add dialog, and if it's listed, read its tool list first. If not, paste the responses; What If the Tool I Need Has No Connector? shows other routes. Checked on 2026-11-11 against the triggers page and Gumloop's connector help page.

  6. 06

    Switch off Web Search, Web Fetch and Edit Own Instructions.

    Switch off the first two in the Abilities section. The third, under the instructions box, lets a correction for one team rewrite the tests in the block. Press Save again. Checked on 2026-11-11 against Gumloop's AI agent builder page.

  7. 07

    Sort one team's submission by hand, then compare.

    Take a team whose submission you've already gone through and mark its items on paper. Paste the outline, the supplier list and that submission into a task, and set your marks beside the AI agent's. Where one differs, open the submission and read what it quoted before you decide who's wrong. The reminder should name only the items you marked missing or unusable, with your date.

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

Does every reminder name something the team still owes?

Before you send one, find each item it names in that team's submission. An item that's there was marked wrongly. If the date isn't yours, open the box and check whether a line has changed.

When a team sends what was missing, paste the new material into the same task and ask for the list again. Missing items should now read Arrived, along with the ones that already did. Once every team's items are Arrived, open How Do I Get an AI Agent to Draft a Board Packet From Team Reports?.

Frequently asked questions

What if a team's story arrives without a consent line?

The story is marked Unusable, with what was sent quoted and the missing consent line named, and the reminder asks for the consent line. It doesn't judge whether consent was given.

Can it send the reminders itself?

It isn't set up to. The build adds no email connector, and the block tells it to send nothing. It writes each reminder as text under the team's name, and you send it.

What if this year's outline differs from last year's?

Paste the new outline and the AI agent builds the list from it.

More on Data for Nonprofit Directors