The Scenario
You coordinate fundraising for a nonprofit. The year-end appeal campaign launches in four days and the donor list — 2,000 addresses compiled from three separate donation records over the past year — is sitting in an Excel file that someone converted to a Google Sheet. Stannp is ready. The recipient group does not exist yet.
The bad version:
- Download the sheet as a CSV, clean up the column headers to match what Stannp's import API expects, discover that the date-of-last-gift column exported with slashes in some rows and dashes in others because it came from two different source files.
- Upload the CSV to create a new Stannp group, wait for the import to process, get back an error that 87 rows failed validation, open the error report, cross-reference it with the original sheet, fix the rows, re-export a corrected file, re-upload.
- Confirm the recipient count, note the new group ID somewhere, and pass it to the campaign manager.
This is the setup step — you have not even created the campaign yet. Two thousand donors and you are spending your afternoon as a CSV repair technician.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Google Sheet. It reads the donor list and uploads the recipients directly into a new Stannp group via the import API, then writes the confirmation back into the sheet.
Import all recipients from this sheet into a new Stannp group called Year-End Appeal 2025 using first name from column A, last name from column B, street from column C, city from column D, state from column E, ZIP from column F — write the new group ID and total imported count into cells B1 and B2, and note any import errors in cell B3.
What You Get
- The new Stannp group ID written into cell B1 so the campaign manager has it immediately.
- The total successfully imported count in cell B2.
- Any import errors or skipped rows summarized in cell B3 — specific enough to act on, not just a number.
What If the Data Is Not Quite Ready
Date columns formatted inconsistently across source files
Ignore the last-gift-date column for the import, then upload all recipients from this sheet to a new Stannp group called Year-End Appeal 2025 — name in columns A and B, address in columns C through F — and write the group ID and import count into cells B1 and B2.
Addresses from multiple source tabs needing a union
Combine all rows from the Sheet1, Sheet2, and Sheet3 tabs — deduplicating by the email address in column G — and import the merged list into a new Stannp group called Year-End Appeal 2025 using name from columns A and B, address from columns C through F. Write the group ID and total count into cells B1 and B2 of Sheet1.
ZIP codes losing leading zeros in the conversion
Before importing, zero-pad all values in column F to 5 digits, then upload all recipients to a new Stannp group called Year-End Appeal 2025 and write the group ID and import count into cells B1 and B2.
Full deduplicate, validate, and import in one pass
Remove duplicate rows based on the address in columns C through F, flag rows with missing values in any address column by writing Skip into column H, then import all remaining rows to a new Stannp group called Year-End Appeal 2025 and write the group ID, import count, and skipped row count into cells B1, B2, and B3.
Cleaning and importing in one instruction means the group reflects the sheet in its final state, not an intermediate snapshot.
Try It
Get the 7-day free trial of SheetXAI and open any Google Sheet with a donor or mailing list and ask it to import recipients into a Stannp group. For sending postcards directly from a sheet, see the bulk-send postcards spoke. For the hub overview, see How to Connect Stannp to Google Sheets.