The Scenario
You are a campaign manager at a direct mail agency. A filter query last week surfaced 400 high-value recipient IDs from Stannp's contact database — previous responders, high-spend segments — and you exported those IDs into an Excel workbook. The campaign launches tomorrow. These 400 IDs need to be in the target group before you can submit the send.
The bad version:
- Open Stannp's UI, navigate to Groups, find the target group, look for a bulk-add option.
- Discover that the UI supports adding individual contacts or importing full address data as CSV — not a list of existing contact IDs.
- Open the API documentation, find the add-recipients-to-group endpoint, realize you need to write a loop that calls it once per ID or find the batch variant.
- Hand the task to a developer. Wait until tomorrow. The campaign was supposed to go out this morning.
Four hundred IDs already in Stannp's system, a group that already exists, and the route between them requires either a script or a workaround that involves re-entering contact data you already have.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook. It reads the ID list and calls the Stannp bulk add-to-group endpoint directly.
Take the list of Stannp recipient IDs in my Excel column A and add them all to the group with ID in cell D1 — note any failures in column B.
What You Get
- Column B filled with a confirmation note for each ID successfully added to the group.
- Any IDs that failed — duplicates, IDs that no longer exist in Stannp — appear in column B with the specific error, so you know which rows need attention before launch.
- The group is ready for the campaign without a developer dependency or a manual workaround.
What If the Data Is Not Quite Ready
IDs mixed with blank rows that need to be filtered out
Skip blank rows in column A, then add all non-blank recipient IDs to the Stannp group with ID in cell D1 and write the confirmation or error into column B. Write the total added count into cell D2.
IDs from two worksheets needing consolidation
Combine all recipient IDs from column A of the Q1 worksheet and the Q2 worksheet, remove duplicates, add the unique IDs to the Stannp group with ID in cell A1 of the Summary worksheet, and write the total added count and any failure count into cells B1 and B2 of the Summary worksheet.
IDs need to be validated as numeric before the add call
Check each value in column A — skip rows where the value is not a positive integer — then add all valid IDs to the Stannp group with ID in cell D1 and write the confirmation or error into column B. Write the count of skipped non-integer rows into cell D2.
Full filter, dedup, add, and confirmation in one pass
Remove duplicate values from column A of the Recipients worksheet, flag rows with non-numeric values by writing Invalid in column B, then add all remaining IDs to the Stannp group with ID in cell D1 and write the confirmation or error into column B — overwriting the Invalid flag only if the API call actually ran for that row.
Combining the dedup, validation, and group add in a single prompt means the group is clean on the first attempt rather than requiring a cleanup run after spotting errors.
Try It
Get the 7-day free trial of SheetXAI and open any Excel workbook with a list of Stannp recipient IDs and ask it to bulk-add them to a mailing group. For estimating campaign cost after the group is ready, see the estimate-campaign-cost spoke. For the hub overview, see How to Connect Stannp to Excel.