The Scenario
You are a growth lead. Your company has 8 Resend audiences, built up over the past year as the product expanded into different customer segments.
You are putting together a quarterly email performance review. The campaign data lives in one tab of the workbook, but you need to cross-reference it against audience names and IDs to make the pivot tables work. Resend shows you the audiences in the dashboard, but not in a format you can paste into a sheet.
The bad version:
- You open the Resend dashboard and navigate to Audiences
- You copy the name of the first audience, paste it into the sheet, then go back and copy the ID
- You do this eight times
- You miss an audience because the list has a scrollbar and you stop at six
- Your quarterly review is missing two audiences and the pivot table gives you wrong totals.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Google Sheet that reads the Resend API and writes the audience list into the sheet for you.
Open the SheetXAI sidebar and type:
List all Resend audiences and write each audience's name and ID into columns A and B of the AudienceOverview sheet. 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. Every audience accounted for, no scrollbar to miss.
What You Get
A populated AudienceOverview sheet:
- Column A — audience names
- Column B — audience IDs
- Row 1 — headers
The IDs in column B are ready for your VLOOKUP or XLOOKUP against the campaign data in the other tab. No manual copying, no missed rows.
Once the IDs are in the sheet you can add contact counts from the campaign tab, sort audiences by size, and build the performance summary your stakeholders want.
What If the Data Is Not Quite Ready
Audience exports get more useful with extra context. SheetXAI can pull more fields and enrich the sheet in the same prompt.
When you want creation date alongside name and ID
The quarterly review needs to show when each audience was created to give context on the age of the list.
List all Resend audiences and write each audience's name, ID, and creation date into columns A, B, and C of the AudienceOverview sheet.
When you want to flag audiences that are older than six months
Old audiences may have stale contacts that inflate the numbers. You want to identify them quickly.
List all Resend audiences and write name, ID, and creation date into columns A, B, and C of AudienceOverview. 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 sheet
The CampaignData tab has audience IDs in column A and open rates in column B. You want to bring in audience names for the report.
List all Resend audiences and write their names and IDs into a lookup area starting at column H of AudienceOverview. Then use those to add audience names in column C of the CampaignData tab by matching on the audience ID in column A.
When you want the full inventory in one shot
You want name, ID, creation date, and a flag for audiences with no activity in the campaign data tab, all in one go.
List all Resend audiences and write name, ID, and creation date into columns A, B, and C of AudienceOverview. 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 sheet, 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 or the Resend in Google Sheets overview.