The Scenario
You are a product manager. The team just hit its target: 500 early-access signups for the new newsletter, collected at an event last week. The data is in an Excel workbook on OneDrive, column A is email, column B is first name.
The first broadcast goes out Thursday. Before it sends, every contact has to be in the "Product Updates" Resend audience.
The bad version:
- You ask the developer to write a script to import the contacts
- She pulls the workbook from OneDrive, writes the script, runs it, hits a rate limit at row 200
- She adds a delay, re-runs from the top, discovers 40 of the first 200 got double-imported because the script did not check for existing contacts
- You send the broadcast to a messy audience and spend an hour cleaning it up afterward.
The fast version is one prompt before lunch.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook that talks to Resend directly, so you do not need a developer or a script.
Open the SheetXAI sidebar and type:
Read all rows in the NewsletterSignups tab in this workbook (A=email, B=first name). Add each person as a Resend contact to the audience named "Product Updates." If the audience does not exist, create it first. Log each contact ID in column C.
SheetXAI creates the audience if it is missing, adds every row as a Resend contact with the correct first name, and writes the contact ID back into column C. Five hundred contacts, five hundred IDs logged.
What You Get
A completed workbook and a populated Resend audience:
- Columns A and B — email and first name, untouched
- Column C — Resend contact IDs, one per row
- "Product Updates" audience — fully populated and ready for Thursday's broadcast
The contact IDs in column C are your reference if you need to update or remove contacts later.
What If the Data Is Not Quite Ready
Event signup lists are rarely clean. SheetXAI handles the issues and the import in the same prompt.
When the workbook has duplicate emails
You collected signups from two badge scanners and some addresses appear twice.
Deduplicate the NewsletterSignups tab by column A, keeping the first occurrence. Then add each unique row to the "Product Updates" Resend audience and write contact IDs in column C.
When first names have inconsistent casing
Some rows have all-caps first names from the badge scanner export.
Normalize the first names in column B to title case. Then add every row to the "Product Updates" Resend audience with the normalized name and log contact IDs in column C.
When you only want to import people who confirmed opt-in
Column C has an opt-in flag ("yes" or "no") and you only want the "yes" rows.
Filter the NewsletterSignups tab to rows where column C equals "yes". Add each filtered row to the "Product Updates" Resend audience (A=email, B=first name) and write the contact ID into column D.
When the audience, dedup, normalization, and import all need to happen at once
The workbook is raw from the event platform, has duplicates, mixed-case names, and an unfiltered opt-in column.
Look at the NewsletterSignups tab. Deduplicate by column A, keeping the first occurrence. Normalize column B to title case. Filter to rows where column C equals "yes". Create a Resend audience called "Product Updates" if it does not exist. Add each filtered row as a contact. Write the contact ID in column D and any errors in column E.
The pattern: the data work and the API call happen together. No pre-processing, no developer, no Thursday-morning scramble.
Try It
Get the 7-day free trial of SheetXAI and open any workbook with subscriber data, then ask it to create the Resend audience and import the contacts. The Resend integration is included in every SheetXAI plan. See also how to bulk-assign contacts to segments in Excel or the Resend in Excel overview.