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 are the right tool: subscribers can opt into specific topics and you can target broadcasts accordingly.
You have a Google Sheet with 10 rows. Column A is the topic name, column B is the description. You need each one created in Resend as a topic 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 sheet, paste the description, save
- You do this ten times
- On topic seven you paste the wrong description because you mixed up the rows
- You spend an extra twenty minutes fixing topics in the dashboard that should have taken five minutes to create from the sheet.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Google Sheet 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 sheet (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 sheet and ten live Resend topics:
- Column A — topic names, untouched
- Column B — descriptions, untouched
- Column C — Resend topic IDs, one per row
The IDs in column C are your reference for the preference center build. Pass them directly to your frontend without going back into the dashboard to look them up.
What If the Data Is Not Quite Ready
Topic setup sheets are rarely perfectly formatted. SheetXAI handles the issues and the creation in the same prompt.
When some descriptions are blank
A few topics in column B have no description yet. You do not want to create them with an empty description.
For each row in TopicSetup 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 verify 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 TopicSetup (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 set up.
List all existing Resend topics and write each topic's name, ID, and description into columns A, B, and C of the TopicsInventory sheet. Use row 1 as a header row.
When you need to create, verify, and log in one shot from a mixed sheet
The sheet has some new topics and some that may already exist. You want new ones created and existing ones looked up, all in one pass.
For each row in TopicSetup (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 creation and the existence check happen together. No double-creates, no missed topics.
Try It
Get the 7-day free trial of SheetXAI and open any sheet 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 or the Resend in Google Sheets overview.