The Scenario
It is the last week of the quarter. Your email engineering team has called a template audit. You have 25 Resend templates in the account. The team wants to know which ones are still published, what their subjects are, and which ones have not been touched since last year.
The audit lives in a Google Sheet called TemplateAudit. The goal is one row per template, columns A through C: name, subject, published status.
The bad version:
- You open the Resend dashboard, navigate to Templates
- You click through each template to find the published status because the list view does not show it
- You manually copy the name, subject, and status into the sheet, one row at a time
- Twelve templates in, you accidentally skip one and do not notice
- You hand the team a spreadsheet with 24 rows when there should be 25, and nobody is sure which one is missing.
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 results into the sheet for you.
Open the SheetXAI sidebar and type:
List all Resend templates and write each template's name, subject, and published status into columns A, B, and C of the TemplateAudit sheet. Use row 1 as a header row.
SheetXAI calls the Resend templates endpoint, pulls all 25 templates, and writes one row per template into the sheet with name in A, subject in B, and published status in C. The whole audit dump happens in one call, no clicking through the dashboard.
What You Get
A populated TemplateAudit sheet with one row per Resend template:
- Column A — template name
- Column B — subject line
- Column C — published status (true/false or published/draft depending on Resend's response)
- Row 1 — headers
Every template is accounted for, pulled directly from the API. Nothing is skipped because you lost count. If Resend has 25 templates, the sheet has 25 data rows.
From there the team can sort by published status to find what is still live, filter by creation date to find stale ones, and add a "decision" column (archive, update, keep) right in the sheet.
What If the Data Is Not Quite Ready
Template audits get more useful when you can add context. SheetXAI can pull more fields and enrich the sheet in the same prompt.
When you want creation date alongside name and subject
The audit needs a "last modified" or "created" date to identify stale templates.
List all Resend templates and write each template's name, subject, creation date, and published status into columns A, B, C, and D of the TemplateAudit sheet.
When you want to flag templates whose subjects look duplicated
Some templates have nearly identical subject lines and the team wants to find them quickly.
List all Resend templates and write name, subject, and published status into columns A, B, and C of TemplateAudit. Then scan column B and add "DUPLICATE SUBJECT" in column D for any rows that share a subject line with another row.
When you only want the published templates
The audit is focused on what is actually live, not drafts.
List all Resend templates. Write only the published ones into the TemplateAudit sheet with name in column A, subject in column B. Leave drafts out entirely.
When you want the full audit in one shot: pull, flag staleness, and sort
You want all templates pulled, flagged if they are older than 90 days and still published, and sorted so the stale published ones are at the top.
List all Resend templates and write name, subject, creation date, and published status into columns A through D of the TemplateAudit sheet. Add a column E with "STALE" for any template that is published and has a creation date older than 90 days from today. Sort the sheet so STALE rows appear first, then unpublished rows, then the rest.
The pattern: pulling the data and annotating it happen together. One prompt, a sheet ready for the team to act on.
Try It
Get the 7-day free trial of SheetXAI and open any sheet, then ask it to pull your Resend templates into it. The Resend integration is included in every SheetXAI plan. See also how to export contact properties or the Resend in Google Sheets overview.