/
/
Find major donors who have no NetSuite customer
For operations teams who want to know which large DonorPerfect donors are missing from NetSuite, just by asking their AI assistant.
On this page
Connector
Connect DonorPerfect, pick your AI tool and paste the prompt.
The problem
A major donor has no customer when billing is needed
Large donors are recorded in DonorPerfect, but nothing ensures a matching customer exists in NetSuite. Someone has to pull donors above a level and look each up, so a gap surfaces only when billing is needed.
Without PopdockAI
- Export donors above a giving level
- Search NetSuite for each by email
- Fall back to name and hope
- Find the gap when an invoice is due
With PopdockAI
- Donors above your level are listed
- Each is looked up in NetSuite by email, then name
- Name-only matches are flagged as weak
- Missing donors listed largest first, nothing changed
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** Find DonorPerfect donors whose lifetime giving is at least `{min-total}` (default 1000) and who have no NetSuite customer.
**Step 1: List donors (DonorPerfect)**
Call `donorperfect-get-donor` with `gift-total.min` = `{min-total}` and `max-records` = `{max-donors}` (default 50). Keep the donor id, name, email and `gift-total`.
**Step 2: Check each one (NetSuite)**
For each donor with an email call `netsuite-get-customer` with `email` = that email. If nothing returns, try `name`. Donors with no email are checked by name only and flagged as weak.
**Step 3: Report**
List the donors with no NetSuite customer, largest `gift-total` first: donor id, name, email, `gift-total`, last contribution. Then give counts: checked, matched by email, matched by name only, missing.
**Rules & Guidelines:**
* `donorperfect-get-donor` is on the donorperfect server; `netsuite-get-customer` is on the netsuite server.
* Read-only. Do not call any `donorperfect-save-*` tool, `donorperfect-set-flag`, or any `netsuite-add-*` or `netsuite-update-*` tool. Never change either system.
**Validation:**
* If `donorperfect-get-donor` returns nothing, say so and stop.
* Do not call NetSuite more than once per donor.
* If `{max-donors}` is reached, say the list may be incomplete.Who it's for
One answer, three teams that use it
Finance operations
Prepare customers before invoicing
Know which major donors need a NetSuite customer set up.
Which DonorPerfect donors over 10,000 lifetime have no NetSuite customer?
Data analysts
Measure system coverage
Counts of matched and missing donors show how aligned the systems are.
Check the top 100 DonorPerfect donors against NetSuite customers and give me counts.
Development directors
Avoid billing surprises
Gaps are known before a sponsorship invoice is needed.
Are any of our top 20 donors missing from NetSuite?
How it works
What PopdockAI does when you ask
You give a giving level and your AI assistant checks each major DonorPerfect donor for a NetSuite customer. It only reads and says when the limit was reached.
01
Ask
You give a minimum lifetime giving amount and how many donors to check.
02
List
It reads DonorPerfect donors above that amount with their email and total giving.
03
Match
It looks each donor up in NetSuite by email, then by name, and flags name-only matches as weak.
04
Report
It lists donors missing from NetSuite, largest first, with counts, and changes nothing.
What PopdockAI provides
The tools behind the answer
Ready made tools for DonorPerfect and one secure connection to your AI tool. No code, no exports.
donorperfect-get-donor
netsuite-get-customer
This report is built from Get data tools only. PopdockAI applies the row, field and parameter rules your admin sets, and every query is written to the audit trail.
The outcome
Major donors without a customer named in advance
Related use cases
More ways to put this data to work
One prompt template with infinite possibilities.
Your AI assistant adapts its approach, tone, and capabilities to match each unique context while you maintain a single, manageable workflow.
Join forward-thinking companies that are transforming their operations with intelligent, secure AI automation.

.webp)
