The Scenario
You are an event coordinator at a nonprofit. Last Saturday's annual gala was a success. 90 guests wrote cheques and handed them to volunteers at the door. The campaign closes in 48 hours and every one of those cheques needs to be recorded in Raisely as an offline donation before the final total is locked.
A data entry volunteer entered all 90 into an Excel workbook over Sunday: donor name, email, amount, and date — one row per cheque.
Now someone has to get all 90 into Raisely. One at a time.
The slow version of Monday morning:
- Open Raisely, navigate to offline donations, click "Add Donation"
- Enter the first donor's name, email, amount, and date
- Click save, note the donation ID, move to row two
- Repeat 89 more times
- Row 47 has the wrong date format — Raisely rejects it. Find it in the workbook, fix it, re-enter.
- Three hours later. The campaign closes in 45 minutes. You are at row 73.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI reads your workbook and creates the offline donations in Raisely row by row, writing confirmation UUIDs back to the sheet as it goes.
Open the SheetXAI sidebar and type:
For each row in this workbook (donor name in column A, email in column B, amount in column C in AUD, date in column D), create an offline donation record in my Raisely campaign 'annual-gala' and log the resulting donation UUID in column E.
SheetXAI iterates through all 90 rows, creates each offline donation via the Raisely API, and writes the confirmation UUID to column E. When done, column E has 90 UUIDs and a full audit trail.
What You Get
A completed offline donation batch with a row-level audit trail:
- 90 offline donation records in Raisely — one per row
- Donation UUIDs in column E — written back in real time
- Error flagging — any row that fails logs the error in column E so you can fix and rerun that row only
- Campaign total updated — Raisely reflects the full event total immediately
No manual data entry. No risk of skipping a row because it is 4:59 PM.
What If the Data Is Not Quite Ready
Event workbooks prepared by volunteers always have formatting issues. SheetXAI handles them in the same prompt.
When date formats are inconsistent across rows
Volunteers entered "15/04/2025," "April 15," and "2025-04-15" in the same date column.
Before creating the offline donations, normalize all dates in column D to ISO 8601 format (YYYY-MM-DD). Then create the offline donation records in 'annual-gala' and log UUIDs in column E.
When some donors did not provide email addresses
A few attendees left the email field blank. Raisely requires an email.
For each row, create an offline donation in 'annual-gala'. If column B is blank, use 'unknown-[row number]@gala2025.placeholder' as a temporary email and mark column F 'No Email — Needs Update'. Log UUIDs in column E for all created records.
When the amount column contains currency symbols or commas
Some rows show "$1,500.00" instead of "1500".
Strip any currency symbols, commas, and whitespace from column C so each cell is a plain number. Then create the offline donation records in 'annual-gala' and log UUIDs in column E.
When the finance team needs a summary after the batch runs
The finance lead wants a confirmation that all 90 donations landed and the total matches their cheque tally.
Create offline donation records in 'annual-gala' for all 90 rows. Log UUIDs in column E. After processing, write in cell G1: total records created, total amount submitted, and a count of any failed rows with error details in G2 onward.
The pattern: clean and submit in one prompt. Fix only the rows that failed.
Try It
Get the 7-day free trial of SheetXAI and ask it to process your next batch of offline donations from an Excel workbook into Raisely. The Raisely integration is included in every plan. See also how to bulk-create Raisely supporters without duplicates or the Raisely in Excel overview.