How to Turn a Donor Export Into a Prioritized First Time Donor Thank You Call List With AI

A raw donor export does not tell you who to call first. Without quick prioritization, first-time donors sit in the queue and the follow-up window closes. This workflow is for small development teams that want a fast, practical way to prioritize stewardship after a campaign, event, or giving push. The goal is to get to a usable result with the fewest moving parts while still keeping the work grounded in real source material.

Editorial guardrail: Use AI to extract, organize, and draft. A staff member should verify funder requirements, donor details, legal acknowledgment language, budget numbers, names, dates, privacy issues, and tone before anything is submitted or sent.

What you need

• A donor export in CSV or spreadsheet format
• Fields for donor name, gift date, amount, campaign or source, and donor status if available
• Gemini or ChatGPT for spreadsheet review
• A clear internal rule for who gets a call versus an email

How to capture or gather the source material

• Export recent gifts from your CRM for the campaign or time period you care about. Include donor name, gift amount, gift date, campaign, and whether the donor appears to be new or returning.
• If your CRM does not flag first-time donors cleanly, add a quick lookup column before upload or ask your database person for a filtered first-time donor list.
• Delete columns that should not be exposed in the AI workflow, such as full payment details or notes that were never intended for broad review.

The fastest workflow

1. Upload the donor file to Gemini and explain your follow-up rule. For example: prioritize first-time donors above $100, event donors who have not received a personal call, and gifts made in the last seven days.
2. Ask Gemini to sort the list into call first, email first, and no personal follow-up needed, with a short reason for each priority level.
3. Export the resulting list into your own stewardship tracker and assign callers immediately.
4. After calls are completed, record outcome notes in the CRM so the next export gets smarter.

Tool-specific instructions

Primary path: Gemini

• Gemini is a good fit for this spreadsheet-first workflow because it can analyze uploaded files and help you categorize rows into practical outreach buckets.
• Be explicit about your prioritization rule. AI cannot know your stewardship policy unless you state it.
• Ask for short reasons, not full scripts, in the first pass. The first job is triage.

Fallback options

ChatGPT fallback

• Upload the same spreadsheet to ChatGPT and ask for a prioritized thank-you call list with clear tiers.
• If you use ChatGPT, keep the prompt focused on ranking and reasons. Do not ask it to draft scripts until the list is cleaned.

Claude fallback

• Claude is useful if you want the output turned into a simple action memo for staff or board callers.
• Upload the cleaned file after you remove unnecessary columns.

Copy and paste prompt blocks tailored to the workflow

Primary prompt

Review the attached donor export and create a prioritized first-time donor thank-you call list. Use this rule set: focus on new donors, recent gifts, higher gift amounts, and donors tied to campaigns where a personal call would matter. Return three groups: Call first, Email first, and No personal call needed. For each donor, include a short plain-English reason for the priority. Do not invent donor history that is not in the file.

Fallback prompt

Analyze this donor export and sort donors into follow-up priority tiers for thank-you calls. Base the ranking only on the columns in the file and the stewardship rules I provide.

Quality checks

• Make sure the file actually isolates first-time donors if that is the goal.
• Check for duplicate rows before you assign callers.
• Review the call rules with your development lead so the ranking matches real stewardship practice.
• Do not send the file to AI with payment card details, bank information, or unnecessary sensitive notes.

Common failure modes and fixes

• The list is too broad: Tighten the prompt with a real time window and a minimum gift threshold.
• Gemini ranks donors in a way your team would not use: State your stewardship rules explicitly and rerun.
• The file contains too much sensitive data: Create a reduced export for the AI step and keep the full record in the CRM.
• Callers still do not know what to say: Run a second pass after ranking to create brief call notes or opener lines.

Sources Checked

• Google Gemini Help, Upload & analyze files in Gemini Apps. https://support.google.com/gemini/answer/14903178?co=GENIE.Platform%3DAndroid&hl=en. Accessed 2026-03-26.
• OpenAI Help Center, File Uploads FAQ. https://help.openai.com/en/articles/8555545-file-uploads-faq. Accessed 2026-03-26.
• Anthropic Help Center, Uploading files to Claude. https://support.anthropic.com/en/articles/8241126-what-kinds-of-documents-can-i-upload-to-claude-ai. Accessed 2026-03-26.
• Fundraising Effectiveness Project, 2025 Q3 Quarterly Fundraising Report. https://publications.fepreports.org/. Accessed 2026-03-26.
• Association of Fundraising Professionals, FEP Q3 2025 Data Demonstrates Fundraising Strength and Early Signs of Donor Stabilization. https://afpglobal.org/news/fep-q3-2025-data-demonstrates-fundraising-strength-and-early-signs-of-donor-stabilization. Accessed 2026-03-26.
• Bloomerang, Nonprofit Gratitude Strategies. https://bloomerang.com/blog/nonprofit-gratitude-strategies/. Accessed 2026-03-26.
• NonProfitHub, First-Time Donor Retention: 3 Nonprofit Best Practices. https://nonprofithub.org/first-time-donor-retention-3-nonprofit-best-practices/. Accessed 2026-03-26.

Quarterly Refresh Flag

Review this article by 2026-06-24. Re-check product features, upload flows, and nonprofit compliance references before updating or republishing.