Skip to article

Will an AI Agent Sort My Year-End Donor List by My Own Rules?

Build an AI agent in Gumloop that files each donor row under the first of your segment rules it meets, prints that rule and leaves the rest unsorted.

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

Yes, by rules you write. Build an AI agent in Gumloop that goes down your segment rules in your order and files each donor row under the first one it meets, with that rule printed beside it. A row that meets none goes under No segment. You block its writing tools, and its instructions bar appeals and ask amounts.

A donor who fits two of your segment rules can only be filed under one.

The campaign needs each row filed somewhere, and the rules for where are in your head. Filling the column by hand means you're holding them through row after row.

Write the rules down and an AI agent can apply them. Each segment is a plain condition on one of the sheet's own columns, and your order decides which wins. The AI agent's instructions tell it to change nothing in the sheet, and in step 04 you set the connector's Write/delete tools to Never allow.

What does a row look like once the rules have run?

Each row appears once, under its segment, named by the column you pick, with the rule that met it printed beside it. A donor who fits the first rule and the third is filed under the first.

A row that meets no rule sits under No segment, with any column a rule needed that was blank named beside it. A rule that mentions a date carries the calendar date inside the rule.

Once the donors are filed, How Do I Build a Donor Stewardship Tracker With an AI Agent? covers keeping track of who has heard from you, which this build doesn't do.

How do you build the giving segments AI agent in Gumloop?

  1. 01

    Order your segment rules from narrowest to widest, one column each.

    Use the column names exactly as the sheet's first row spells them. A rule names a column, what its cell must hold and the segment that follows: when the cell under Last gift date holds a date on or after the one you write into the rule, the segment is Recent givers. Both names are invented.

  2. 02

    Start the segment sorter as a new AI agent.

    Open Gumloop, create the AI agent and paste the block from the next section into the instructions box on the tab named Agent, add a line for each rule past the third and press Save. Checked on 2026-11-11 against Gumloop's AI agent builder page.

  3. 03

    Add Google Sheets to the AI agent.

    Expand Connectors on the tab named Agent, click Add, search for Google Sheets and sign in. Checked on 2026-11-11 against Gumloop's connector help page. That page doesn't list the connector's tools, so read them in your account. If you'd rather not connect the sheet, paste its rows into the task, after removing any names and columns that your rules and your identifying column don't need.

  4. 04

    Block every writing tool with Never allow.

    The default approval is Always allow. Click the approval icon beside the connector, choose Custom and open its detail view to Tool Management, where tools sit in Read-only and Write/delete groups. Set the write group to Custom and each tool in it to Never allow. Checked on 2026-11-11 against Human in the loop.

  5. 05

    Turn off the segment sorter's Web Search, Web Fetch, browser and Edit Own Instructions.

    In the Abilities section, switch off Web Search and Web Fetch, and in the Browser section, turn the browser off if it's on. Then switch off Edit Own Instructions, the toggle that's right under the instructions box. The No segment pile is how you judge your rules, so keep them where they are while you're reading it. Checked on 2026-11-11 against the abilities and self-improving instructions sections of Gumloop's AI agent builder page and Gumloop's browser page for AI agents.

  6. 06

    Set your own filing of a few rows beside the AI agent's.

    Choose rows whose segment you'd name without the rules, including one that fits none and one that fits two. Compare each segment and printed rule with yours. That test is this page's own suggestion, and if the AI agent printed the later rule for the row that fits two, reread the order sentence in the box first.

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

What do you paste into the instructions for the giving segments?

Copy and fill in
You help me, [YOUR NAME], [YOUR ROLE] at [ORGANIZATION], sort a donor sheet into segments for our year-end giving campaign. I'll point you to the sheet or paste its rows.

My segment rules follow, in the order I want them applied. Go down them for each donor row and file the row under the first rule it meets. Stop there.
First: [SEGMENT NAME], when [CONDITION ON ONE COLUMN].
Second: [SEGMENT NAME], when [CONDITION ON ONE COLUMN].
Third: [SEGMENT NAME], when [CONDITION ON ONE COLUMN].
Identify each row by the value in [IDENTIFYING COLUMN].

A condition uses a column exactly as the sheet's first row spells it. A blank cell in a column a rule needs means that rule isn't met. A row that meets no rule goes under "No segment." Don't fit it into a segment it didn't meet, and add no segment of your own.

Print each row once, under its segment, with the rule that met it beside it. For a row under "No segment," name any column a rule needed that was blank. Read the sheet only and change nothing in it. Write no appeal and no ask amount, and don't count or total anything. If a rule is unclear, ask me.

Is the rule beside each row the first one it meets?

Find a row that meets two of your rules. The rule printed beside it should be the earlier one. If it isn't, reread the order sentence in the box.

Open a few rows under No segment and read the column named beside each. A blank is a cell you'll fill in the sheet. A filled cell that no rule fits is a kind of donor you haven't written a rule for, and a new rule in the box covers it.

Rewrite the rules for each new campaign. What Goes in a Donor Thank-You Letter an AI Agent Drafts? covers the letter an AI agent drafts from each gift row.

Frequently asked questions

What if two of my rules fit the same donor?

The donor is filed under whichever rule comes first in your list, and the printed rule shows which. If the donor belongs under the later one, move that rule up in the box and run the sheet again.

Can it write the appeal for each segment?

No. The block bars appeals and ask amounts and asks only for the filed list. You'll write each segment's appeal yourself.

What does the No segment pile tell me?

That none of your rules met those rows. For each one the block names any column a rule needed that was blank.

More on Data for Nonprofit Directors