Is Your Definition of a Lapsed Donor Ready for an AI Agent to Apply?
Build an AI agent in Gumloop that lists the donors who meet your own definition of lapsed and drafts a short reconnection note from your sheet's fields.
It's ready once it's a condition on your sheet's own columns, and then an AI agent in Gumloop can apply it. It lists the rows that meet your condition and drafts a short note for each from the sheet's fields. Its instructions bar appeals, amounts, guilt, guesses about why a donor stopped, and sending.
Sort your donor sheet by last gift date, oldest first, then write the line that marks where the lapsed donors begin. It's a condition on your sheet's own columns: a last gift date before a cutoff you choose, a column that has to be blank, a designation you leave out.
Each note uses four things the sheet records: the name as you typed it, the date of the last gift, its designation, and one sentence you wrote about what that gift made possible. The instructions bar sending and you add no email connector, so you'll review each note in the chat and send it from your own email.
What do you paste into the instructions for the reconnection notes?
Your definition goes in the second paragraph's bracket, and any other column it uses goes in the first paragraph's list.
You help me, [YOUR NAME], [YOUR ROLE] at [ORGANIZATION], write short reconnection notes to donors my sheet marks as lapsed. I'll paste the sheet's rows. Its columns are [NAME COLUMN], [LAST GIFT DATE COLUMN], [DESIGNATION COLUMN] and [GIFT SENTENCE COLUMN]. A donor is lapsed only when this is true of the row: [MY DEFINITION OF LAPSED, WRITTEN ON THE COLUMNS ABOVE, WITH A CUTOFF DATE]. List every row where it is true, and no other row. If a field the condition uses is blank, list the row under "Can't tell." For each lapsed row, write a note of three sentences at most, signed with my name. Use only the name exactly as typed, the last gift date as typed, the designation as typed, and my gift sentence copied as written. Write no appeal, no ask and no amount. Add no fact about the donor that the row doesn't hold. Don't guess why the donor stopped giving, and use no guilt or urgency. If a field is blank, leave out the line that uses it and list the row and the field under "Missing." Send nothing. Write the text of each note only.
How do you build the lapsed donor note AI agent in Gumloop?
- 01
Write what lapsed means as a condition on your own columns.
Decide the test in one sentence that uses only columns your sheet keeps: a column that has to be blank, a designation you leave out, or a last gift date before a cutoff you type as a date, not as a span of time. A donor who asked you to stop writing stays off the list only if the sheet records it, so add a column for that and put it in your condition. Add one more column holding a sentence you wrote about what each donor's last gift made possible.
- 02
Save the block, then switch off what a reconnection note doesn't use.
In Gumloop, start a new AI agent and, when it asks what it should take care of, answer with the job in a sentence. On the tab named Agent, paste the block into the instructions box and press Save. In the Abilities section, switch off Web Search, Web Fetch and Search Past Tasks. In the Browser section, turn the toggle off if it's on, then press Save again. Checked on 2026-11-11 against Gumloop's AI agent builder page and Gumloop's AI agent browser page.
- 03
Keep chat from rewriting the definition and the bars.
Turn off Edit Own Instructions, directly under the instructions box, then press Save again. Read the definition and the bars in the box before each batch. Checked on 2026-11-11 against Gumloop's AI agent builder page.
- 04
Leave sending out of the build.
Add no email connector, and check that the Connectors list holds none. If you add one later, choose Custom as its approval mode, open its detail view and set its tools in Tool Management, since the approvals page's email approval card is for Send Email and the page names no draft tool. Checked on 2026-11-11 against Human in the loop.
- 05
Match its list to a filter you run in the sheet.
Copy a handful of rows into a task, keeping the header row and only the columns your condition and the four fields use. Include a donor you know is lapsed, one you know isn't, and one whose last gift date is blank. Ask for the lapsed list, then apply the same condition as a filter in the sheet and set the two lists side by side; the check is this page's own design. The blank-date row should sit under "Can't tell," with no note.
I am an ambassador for Gumloop. Code THANKSNGOS takes 20% off your first month.
Could you find every fact in a note in its row?
Open the sheet beside the first notes and look for any fact that isn't the name, the date, the designation or your sentence. A guess at why the donor stopped, a thank you for more than the gift in the row, or an amount has gone past the fields. Reread the block's third paragraph.
Check each listed row's date against your cutoff by eye. Then read the "Missing" list against the sheet. Each row on it should have an empty cell in the field it names, and its note should lack the line that field feeds.
When a lapsed donor writes back and a meeting follows, use What Should an AI Agent Brief Me On Before a Major Donor Meeting?. After that meeting, use An AI Agent Can Draft a Thank-You Note After a Meeting for the thank-you. When the cutoff date moves, edit the box.
Frequently asked questions
What if a donor asked you to stop writing and the sheet doesn't say so?
The AI agent works from the rows you paste, so that donor gets a note if the condition says lapsed. Add a column that records the request, put it in your condition and check before you paste.
Can the note mention what the donor gave?
No. A gift amount isn't one of the four fields, and the block bars amounts. The note names the date and designation of the last gift and your own sentence.
What happens when a gift has no sentence about what it made possible?
That line is left out of the note, and the row is listed under "Missing" with the field named. Write the sentence in the sheet and paste the row again.