The Scenario
You are a newsletter operator. Your publication covers 10 content verticals and you want subscribers to self-select which ones they care about. Resend topics let subscribers opt in, and you can target broadcasts accordingly.
You have an Excel workbook with 10 rows in the TopicSetup tab. Column A is the topic name, column B is the description. You need each one created in Resend before the preference center goes live next week.
The bad version:
- You open the Resend dashboard, navigate to Topics, click "New Topic"
- You type the name from the workbook, paste the description, save
- You repeat this ten times
- On topic eight you paste the wrong description because you confused the rows
- You spend an extra twenty minutes correcting topics in Resend that should have taken five minutes to create.
The fast version is one prompt directly from the workbook.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook that reads your topic list and creates each one in Resend for you.
Open the SheetXAI sidebar and type:
Read all rows in the TopicSetup tab in this workbook (A=topic name, B=description) and create each one as a Resend topic. Write the new topic ID into column C for each row.
SheetXAI reads all ten rows, creates each topic in Resend with the right name and description, and writes the returned topic ID back into column C. Ten topics, ten IDs, no clicking through the Resend dashboard.
What You Get
A completed TopicSetup tab and ten live Resend topics:
- Columns A and B — topic names and descriptions, untouched
- Column C — Resend topic IDs, one per row
The IDs in column C go straight to the frontend team for the preference center build. No extra lookup, no dashboard.
What If the Data Is Not Quite Ready
Topic setup workbooks are rarely perfectly formatted. SheetXAI handles issues and creation together.
When some descriptions are blank
A few rows in column B have no description yet.
For each row in the TopicSetup tab where column B is blank, write "No description provided" into column B. Then create each row as a Resend topic and write the topic ID into column C.
When you want to check which topics already exist before creating new ones
Some topics may already be in your Resend account from a previous run.
List all existing Resend topics. For each row in the TopicSetup tab (A=topic name), check if a topic with that name already exists. If it does, write the existing ID into column C. If not, create it and write the new ID into column C.
When you want to export all existing topics instead of creating new ones
The preference center is already live and you need to document what topics are configured.
List all existing Resend topics and write each topic's name, ID, and description into columns A, B, and C of the TopicsInventory tab. Use row 1 as a header row.
When you need to create, verify, and log in one shot from a mixed sheet
The workbook has some new topics and some that may already exist.
For each row in the TopicSetup tab (A=topic name, B=description), check if a Resend topic with that name already exists. If it does, write the existing ID in column C and "existing" in column D. If it does not, create it and write the new ID in column C and "created" in column D.
The pattern: the existence check and the creation happen together in one prompt. No double-creates, no missed topics.
Try It
Get the 7-day free trial of SheetXAI and open any workbook with topic names and descriptions, then ask it to create them in Resend. The Resend integration is included in every SheetXAI plan. See also how to export your Resend audience list from Excel or the Resend in Excel overview.