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.
Your data entry volunteer entered all 90 into a Google Sheet over Sunday afternoon. The sheet has donor name, email, amount, and date — one row per cheque.
Now someone has to get all 90 into Raisely. One at a time. Through the Raisely admin interface.
The slow version of Monday morning:
- Open Raisely, navigate to offline donations, click "Add Donation"
- Type in the first donor's name, email, amount, and date
- Click save. Note the donation ID somewhere. Move to row two.
- Repeat 89 more times
- Realize row 47 had the wrong date format and Raisely rejected it
- Find row 47 in the sheet, fix it, re-enter it
- Three hours later. Your wrist hurts. The campaign closes in 45 minutes.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI reads your sheet and writes the offline donations to Raisely for you, row by row, logging confirmation IDs back to the sheet as it goes.
Open the SheetXAI sidebar and type:
For each row in this sheet (donor name in column A, email in column B, amount in column C, 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 in Raisely via the API, and writes the confirmation UUID back to column E. When it is done, column E has 90 UUIDs. You have a full audit trail without touching Raisely's admin panel once.
What You Get
A completed offline donation batch with a built-in audit trail:
- 90 offline donation records created in Raisely — one per row
- Donation UUIDs in column E — written back in real time as each record is created
- Error flagging — if a row fails (wrong email format, missing required field), SheetXAI writes the error message to column E instead of a UUID so you can fix and rerun just that row
- Campaign total updated — Raisely reflects the full event total immediately
You have a paper trail that matches the sheet. If someone later disputes a donation amount, the UUID links directly to the Raisely record.
What If the Data Is Not Quite Ready
Event data entered by volunteers is rarely perfect. Inconsistent date formats, missing emails, and partial names are standard.
When some donors did not provide email addresses
A few attendees wrote down name and amount but no email. Raisely requires an email to create a donor record.
For each row in this sheet, create an offline donation in 'annual-gala'. If column B (email) 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 date column has inconsistent formats
Volunteers entered dates as "15/04/2025", "April 15", "15 April 2025", and "2025-04-15" across different rows.
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 the amounts include currency symbols or commas
Some volunteers wrote "$1,500.00" instead of "1500" in the amount column.
Strip any currency symbols, commas, and whitespace from column C so each cell contains a plain number. Then create the offline donation records in 'annual-gala' and log UUIDs in column E.
When you need to notify the finance team with a summary after the batch runs
The finance lead wants a quick 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 all rows are processed, write a summary in cell G1: total records created, total amount submitted, and a count of any rows that failed with error details in G2 onward.
The pattern: clean the data and submit it in one prompt. The errors are flagged inline, so you fix and rerun only what failed, not the whole batch.
Try It
Get the 7-day free trial of SheetXAI and ask it to process your next batch of offline donations from a sheet. The Raisely integration is included in every plan. See also how to bulk-create Raisely supporter accounts or the Raisely in Google Sheets overview.