The Scenario
You are a growth lead. Your company has 8 Resend audiences built over the past year. You are putting together a quarterly email performance review in an Excel workbook on SharePoint.
The campaign data lives in one tab. You need to pull audience names and IDs into another tab so your VLOOKUP formulas can connect campaign performance to audience labels. Resend shows the audiences in the dashboard, but not in a format you can paste into Excel.
The bad version:
- You open the Resend dashboard and navigate to Audiences
- You copy the name of the first audience, switch to Excel, paste it, switch back, copy the ID, paste it
- You do this eight times
- You miss one audience because the list scrolls and you do not notice
- Your pivot table gives you totals for seven audiences when there should be eight.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook that reads the Resend API and writes the audience list into the workbook for you.
Open the SheetXAI sidebar and type:
Fetch every Resend audience and paste the audience name, ID, and creation date into the AudienceList tab in this workbook. Use row 1 as a header row.
SheetXAI calls the Resend audiences endpoint, pulls all 8 audiences, and writes one row per audience. Name in A, ID in B, creation date in C. Every audience, no scrollbar to miss.
What You Get
A populated AudienceList tab:
- Column A — audience names
- Column B — audience IDs
- Column C — creation dates
- Row 1 — headers
The IDs in column B are ready for VLOOKUP against the campaign data in the other tab. No manual copying, no missed rows.
What If the Data Is Not Quite Ready
Audience exports get more useful with context. SheetXAI can pull more and enrich the workbook in the same prompt.
When you want to flag audiences that are older than six months
Old audiences may have stale contacts inflating the numbers.
List all Resend audiences and write name, ID, and creation date into columns A, B, and C of AudienceList. Add "STALE" in column D for any audience created more than 180 days ago.
When you want to match audiences to campaign performance data already in the workbook
The CampaignData tab has audience IDs in column A and open rates in column B. You want to pull in audience names.
Fetch all Resend audiences and write their names and IDs into a lookup area starting at column G of AudienceList. Then use those to fill audience names in column C of the CampaignData tab by matching on the ID in column A.
When you want to see only audiences created this year
The quarterly report covers current audiences, not old test lists from two years ago.
List all Resend audiences created in 2026. Write name, ID, and creation date into columns A, B, and C of AudienceList.
When you want the full inventory in one shot
You want name, ID, creation date, and a "no campaigns" flag for audiences that do not appear in the CampaignData tab.
List all Resend audiences and write name, ID, and creation date into columns A, B, and C of AudienceList. Cross-reference with the CampaignData tab: if an audience ID in column B does not appear in the CampaignData tab's column A, write "NO CAMPAIGNS" in column D.
The pattern: pulling the audience list and enriching it with context happen together in one prompt.
Try It
Get the 7-day free trial of SheetXAI and open any workbook, then ask it to pull your Resend audiences. 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.