The Scenario
You are an operations lead at a nonprofit. A data entry error three weeks ago caused 30 donations to be assigned to the wrong fundraiser profile. The donations show up in the campaign total, but the individual fundraiser leaderboard is wrong — one fundraiser shows $4,200 more than they actually raised, and another shows $4,200 less.
You caught it in the weekly data audit. Your team has already prepared a correction sheet: column A has the donation UUID, column B has the correct target profile UUID. 30 rows.
Raisely lets you reassign a donation to a different profile via the API. But there is no bulk reassignment in the admin panel. It is one at a time.
The slow version:
- Open Raisely, navigate to the first donation by UUID
- Click reassign, select the target profile, confirm
- Go back to the sheet, mark that row done, find the next UUID
- Repeat 29 more times
- Realize row 14 has the wrong target profile UUID — Raisely returns a 404 error
- Go back to the correction sheet, find the right UUID, fix it, resubmit
- An hour and a half later. The leaderboard is still wrong until you finish.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI reads the correction sheet and reassigns each donation to its correct profile in Raisely, logging the result per row.
Open the SheetXAI sidebar and type:
For each row in this sheet where column A is a donation UUID and column B is the target profile UUID, move the Raisely donation to that profile and log the result in column C. Write 'Moved' if successful, or the error message if not.
SheetXAI iterates through all 30 rows, calls the Raisely API to reassign each donation, and writes the result to column C. When done, the leaderboard is corrected and column C shows you exactly what happened.
What You Get
30 corrected donation assignments with a row-level audit trail:
- "Moved" in column C for each successfully reassigned donation
- Error message in column C for any row that failed — bad UUID, invalid profile, API error
- Leaderboard corrected — the affected fundraiser profiles show the right totals immediately
- No manual navigation through the Raisely admin panel
If a UUID is wrong, the error message in column C tells you exactly what Raisely returned. Fix the UUID in column B, rerun just that row.
What If the Data Is Not Quite Ready
Correction sheets prepared under time pressure have their own issues.
When you need to verify target profile UUIDs before reassigning
Before touching 30 live donation records, you want to confirm that each target profile UUID in column B is actually a valid profile.
For each row, look up the Raisely profile at the UUID in column B and return the profile name. Write the profile name to column D as 'Target Profile Name'. Do not reassign anything yet — this is a validation step.
When the correction sheet has duplicates
Someone added the same donation UUID twice in the correction table, pointing to different target profiles.
Check column A for duplicate donation UUIDs. Flag any row where the UUID appears more than once in a 'Duplicate Warning' column before proceeding. Only reassign rows with unique UUIDs — skip duplicates and log 'SKIPPED — Duplicate UUID' in column C.
When some rows have already been processed manually
Someone reassigned five donations by hand before you ran the batch. You do not want to move those again.
For each row where column C is blank, reassign the donation in column A to the profile in column B. Skip rows where column C already contains 'Moved'. Log 'Moved' or the error in column C for each row processed.
When you need an audit summary after the batch runs
The finance lead wants a confirmation that all 30 donations were moved and that the affected fundraiser profiles now show the correct totals.
Process all 30 reassignments and log results in column C. After all rows are processed, write a summary in cell E1: total rows processed, total successfully moved, total with errors. For any error rows, list the donation UUID and error message in column F onward.
The pattern: validate the correction data first, then reassign in bulk, then summarize what changed. The audit trail in column C is the handoff to finance.
Try It
Get the 7-day free trial of SheetXAI and ask it to process your next bulk donation reassignment from a correction sheet. The Raisely integration is included in every plan. See also how to import all donations for board reporting or the Raisely in Google Sheets overview.