The Scenario
You are a white-label email agency. This week you are onboarding 10 new clients. Each one needs their own BigMailer brand with a sender name and from email. You have a Google Sheet with 10 rows — brand name in column A, from name in column B, from email in column C.
Creating each brand manually means logging into BigMailer, clicking "Add Brand," filling in the fields, saving, copying the brand ID, pasting it back into your CRM, and repeating 10 times.
The slow version:
- Navigate to BigMailer's brand list
- Click "Add Brand"
- Fill in brand name, from name, from email
- Copy the new brand ID
- Paste it into the sheet
- Repeat nine more times
- Realize you mistyped a from email on brand 7 and have to go back
- You finish at 6 PM and still have to set up the lists.
The fast version is one prompt and you start on the lists.
The Easy Way: One Prompt in SheetXAI
SheetXAI reads each row and calls the BigMailer brand creation API for each one, then writes the new brand IDs back into the sheet.
Open the SheetXAI sidebar and type:
Create a BigMailer brand for each row in this sheet using the brand name in column A, from name in column B, and from email in column C — write the new brand IDs back into column D. Report any rows that failed and the reason.
SheetXAI iterates through the 10 rows, creates each brand via the BigMailer API, and writes the assigned brand ID into column D. Failed rows get flagged with the error reason so you can fix them without guessing.
What You Get
10 BigMailer brands created with results written back into the sheet:
- Column D — the new brand ID for each row
- Error flags — any rows where BigMailer rejected the request, with the reason
- Audit trail — the sheet now has a permanent record of brand name to brand ID mapping
Column D becomes your agency's brand ID reference. Every subsequent prompt that needs to import contacts, create lists, or pull campaign stats for a specific client starts with "use the brand ID in column D, row X."
If a client's from email address needs to change after setup, tell SheetXAI to update the brand using the ID in column D and the new address from column C.
What If the Data Is Not Quite Ready
Client onboarding sheets are rarely clean. SheetXAI handles validation and creation in the same prompt.
When some from email addresses are not yet verified in Amazon SES
BigMailer uses Amazon SES and requires verified sender addresses. Some clients have not completed their SES verification yet.
Create BigMailer brands for all rows where column D is blank and column E does not say 'pending-SES'. For rows where column E says 'pending-SES', write "SKIP — awaiting SES" in column D instead of attempting the API call.
When the brand name contains characters BigMailer rejects
Some client names have ampersands, slashes, or other characters that break the API call.
Before creating each brand, sanitize the brand name in column A: replace '&' with 'and', remove slashes, and trim leading and trailing whitespace. Then create the BigMailer brand using the sanitized name, from name in column B, and from email in column C. Write the sanitized name into column E and the brand ID into column D.
When you want a summary of all created brands in a new tab
After creation, the project manager wants a clean summary to share with the client success team.
Create a BigMailer brand for each row in this sheet using columns A, B, and C. Write brand IDs into column D. After all brands are created, add a new sheet tab called 'Brand Summary' and list brand name, from email, and brand ID sorted alphabetically by brand name.
When the sheet has duplicates and some brands already exist in BigMailer
You merged two onboarding sheets and some clients appear twice. Some may already have brands in BigMailer from a previous engagement.
Before creating brands, deduplicate the rows by column C (from email), keeping the first occurrence. For any row where column D already has a brand ID, skip that row. Create brands only for rows where column D is blank. Write new brand IDs into column D and a creation timestamp into column F.
The pattern: ask for validation, creation, and results in one prompt. The onboarding sheet becomes the source of truth.
Try It
Get the 7-day free trial of SheetXAI and open a sheet with your new client details, then ask it to create all the BigMailer brands at once. The BigMailer integration is included in every SheetXAI plan. See also how to bulk-import contacts into a brand or the BigMailer in Google Sheets overview.