The Scenario
You are a developer advocate. Your team shipped a private beta last Friday. You have 80 beta testers in an Excel workbook, column A holds their email addresses, column B holds their individually generated invite codes.
The task is simple: send each person a personalized welcome email via Resend. The email should include their invite code. Log the Resend email ID back into column C so you have a delivery record.
The bad version:
- You write a Node script to loop through the workbook rows
- The workbook is on SharePoint and the script cannot authenticate cleanly
- You export to CSV, fix the script to read from a file instead, run it locally
- The script sends fine in dev, breaks because twelve rows had stale emails from an old export
- You remove the bad rows manually, re-run, wait for confirmation
- You ship the beta invite email four hours after you planned to.
The fast version is one prompt, no script, no CSV export.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook that reads the data and calls the Resend API for you, so you do not have to write or run any code.
Open the SheetXAI sidebar and type:
Read the InviteList tab (A=first name, B=email, C=invite code) and send each person a personalized Resend email from hello@myapp.com with subject "Your beta invite" and a body that includes their first name and invite code. Log each sent email ID in column D.
SheetXAI reads every row, sends a Resend email per recipient with that row's name and invite code in the body, and writes each returned email ID back into column D. Eighty rows. Eighty sends. Eighty IDs logged.
What You Get
A completed workbook with:
- Columns A, B, C — name, email, invite code, untouched
- Column D — Resend email IDs, one per row, written in as each send completes
The delivery record is built as the sends go out, not reconstructed from a log afterward. If anything bounces later you have the email ID to look it up in Resend.
Want a different body? Tell SheetXAI to use an HTML template, or to vary the sign-off based on a tier column. It adjusts the send per row before calling Resend.
What If the Data Is Not Quite Ready
Most real beta tester lists are not clean. SheetXAI handles the cleanup and the send in the same prompt.
When some rows have duplicate email addresses
You assembled the list from two sign-up forms and some addresses appear twice with different invite codes.
Deduplicate the InviteList tab by column B (email), keeping the row with the longer invite code. Then send the personalized Resend email to each unique address and log the email ID in column D.
When some invite codes are blank
A few rows in column C are empty because those testers were added manually.
For each row in InviteList, if column C is blank write "NO_CODE" into it. Then send the Resend welcome email to every row. For rows with NO_CODE, substitute a note in the body that says "Your invite code will follow in a separate email." Log email IDs in column D.
When you only want to send to testers who have not been contacted yet
Column D already has email IDs in some rows from a partial run last week.
For each row in the InviteList tab where column D is blank, send the personalized Resend email and write the email ID into column D. Skip any row that already has a value in column D.
When you want to clean, send, and log in one shot on a raw export
The tab has raw data including duplicates, blank invite codes, and mixed-case emails. You want everything handled at once.
Look at the InviteList tab. Remove duplicate rows by column B. Normalize email addresses to lowercase. For rows missing a code in column C, write "PENDING." Then send each row a personalized Resend email from hello@myapp.com with the invite code in the body (using "Your invite code is coming soon" if code is PENDING). Log the Resend email ID in column D and any errors in column E.
The pattern: the cleanup and the API call happen together in one prompt.
Try It
Get the 7-day free trial of SheetXAI and open any workbook with email addresses and personalization data, then ask it to send the Resend emails. The Resend integration is included in every SheetXAI plan. See also how to import subscribers into a Resend audience from Excel or the Resend in Excel overview.