What Goes in a Donor Thank-You Letter an AI Agent Drafts?
Build an AI agent in Gumloop that drafts a donor thank-you letter from your gift sheet's filled fields, drops any line whose cell is empty and lists it.
What your gift sheet holds, plus one sentence of your own. Build an AI agent in Gumloop that writes one line for each field you filled (the name, the date, the designation and your own sentence about what a gift does). An empty cell removes its line and lists it. Its instructions bar invented impact and sending.
A donor thank-you letter drafted from your gift sheet has one line for each cell you filled, and if a cell's empty, its line leaves the letter and goes onto a list for you.
You give the AI agent a sheet with one row for each gift. For each donor you name, it drafts a letter from the name, the date of the gift, the designation and one sentence of your own about what a gift does. The block below bars invented impact and invented detail about the donor, and an amount appears only if you name an amount column. You don't add a mail connector in this build, so you'll copy each letter out of the task.
What does the letter hold when a cell is empty?
The frame has a line for each field. An empty date cell drops the date line and leaves the rest as it was. An empty name cell drops the greeting, so fill the cell and draft again. After each letter the AI agent lists what's left out, naming the line and the column that's empty.
A record of who's been thanked is a different job, and How Do I Build a Donor Stewardship Tracker With an AI Agent? describes a sheet for it.
What do you paste into the instructions for the thank-you letters?
Words in round brackets mark a cell the AI agent reads.
You help me, [YOUR NAME], [YOUR ROLE] at [ORGANIZATION], draft thank-you letters to donors from a gift sheet with one row for each gift. Draft a letter for each donor I name, using only these columns: [NAME COLUMN], [DATE COLUMN] and [DESIGNATION COLUMN]. My amount column is [AMOUNT COLUMN, OR NONE]. Build each letter from this frame, one line for each field: Dear (the name cell), Thank you for your gift. We received it on (the date cell). You gave it to (the designation cell). [YOUR ONE SENTENCE ABOUT WHAT A GIFT DOES] Your gift was (the amount cell). With thanks, [YOUR NAME], [YOUR ROLE] Copy each cell exactly as written. If a cell is empty, leave out the line that uses it, put nothing in its place, and list the line and the empty column under "Left out" after the letter. If my amount column is NONE, leave out the amount line and state no amount anywhere. Add no impact, no figure and no detail about the donor that the sheet doesn't hold, and no sentence of your own. Draft only. If something is unclear, ask me.
How do you set up the donor letter drafter in Gumloop?
- 01
Fill the cells you can, and write one sentence of your own.
Give each gift its own row and look down the name, date and designation columns for cells that are empty by mistake. Then write one sentence about what a gift does, in the words you'd say to a donor. The block copies it exactly.
- 02
Create the AI agent and paste the frame.
Open Gumloop and start a new AI agent. If guided setup asks what it should take care of, answer in a sentence about drafting thank-you letters from a gift sheet. On the tab named Agent, paste the block into the instructions box and press Save. Checked on 2026-11-11 against Gumloop's AI agent builder page.
- 03
Connect the gift sheet and read where its tools sit.
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. The default approval is Always allow, so click the approval icon beside the connector and choose Ask for writes/deletes. Gumloop's connector help page doesn't list the Google Sheets tools, so open the connector, find Tool Management and read which group each tool sits in, since the write group is what will wait for you. Checked on 2026-11-11 against Human in the loop. Don't add a mail connector.
- 04
Switch off Web Search, Web Fetch and the browser, then guard the letter frame.
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, under the instructions box, and press Save. If Reflections is on under Performance, open its settings and set Apply Suggestions to Review Queue, so a suggested instruction change waits for you. Read the Left out list while the frame is the one you saved. Checked on 2026-11-11 against the abilities and self-improving instructions sections of Gumloop's AI agent builder page, Gumloop's browser page and Gumloop's page on Reflections.
- 05
Take one cell out of a gift row you can check.
Pick a donor whose gift you can check in your records. Paste only that row's name, date and designation cells into the task, once as they stand and once with one cell removed. Read each letter against its cells. The removed cell's line shouldn't appear, and Left out should name it. That test is this page's own suggestion. If a line shows up for an empty cell, reread the sentence in the block that leaves it out.
I am an ambassador for Gumloop. Code THANKSNGOS takes 20% off your first month.
Does the Left out list match the empty cells you can see?
Set the list beside the rows you drafted. Every empty cell should be on it once, and no letter should carry a line for a cell that's empty.
Compare your sentence in each letter with the one in the block, word for word. If you haven't named an amount column, no letter should state an amount, and one that does points to the amount blank in the block as a likely cause.
For filing donors under your own segment rules, use Will an AI Agent Sort My Year-End Donor List by My Own Rules?.
Frequently asked questions
Can it put the gift amount in the letter?
Only if the sheet has an amount column and you've named it in the block. With that blank set to NONE, the block bars an amount anywhere in the letter.
What if a donor's row is missing most of its cells?
The letter keeps the lines that still have cells, and Left out lists the rest. A row with only a name keeps the greeting, the thank-you line, your sentence and the sign-off.
Can the letters go straight into my mail?
This build doesn't add a mail connector. If you add one, set its approval to Ask each time, open its Tool Management to read which group each tool sits in, and reword the last lines of the block to match. Gumloop's approvals page gives sending an email as one of its examples of an action that needs approval and names no draft tool, so check your own tool's group.