The Scenario
You are a developer. Your Resend account has 12 custom contact properties — fields like plan_tier, signup_source, trial_end_date — that drive personalization across your email templates.
The frontend team is building the new signup form and they need the schema. Instead of digging through the Resend dashboard and pasting into Slack, you want to drop an Excel workbook in the shared SharePoint folder with all 12 properties listed cleanly.
The bad version:
- You open the Resend dashboard, navigate to Contacts, then to Properties
- You screenshot the list and share it in Teams
- The frontend dev asks for the fallback values, which are not in the screenshot
- You click into each property individually to find them
- Forty minutes to produce a table that should have taken four.
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 property schema into the workbook for you.
Open the SheetXAI sidebar and type:
List all Resend contact properties and write each property's key, type, and fallback value into columns A, B, and C of the ContactProperties tab. Use row 1 as a header row.
SheetXAI calls the Resend contact properties endpoint, pulls all 12 properties, and writes one row per property. Key in A, type in B, fallback in C.
What You Get
A populated ContactProperties tab ready to share from SharePoint:
- Column A — property key (e.g.,
plan_tier,signup_source) - Column B — data type (e.g., string, number, boolean)
- Column C — fallback value
- Row 1 — headers
The frontend team has the full schema, including fallbacks. No Teams back-and-forth, no dashboard clicking.
What If the Data Is Not Quite Ready
Property schema documentation gets more useful with extra context. SheetXAI can enrich it in the same prompt.
When you want to bulk-create new properties from the workbook instead of exporting
The frontend team has drafted the new properties in a NewProperties tab and you need to create them in Resend.
Read the NewProperties tab in this workbook (A=property key, B=data type, C=fallback value) and create each one as a Resend contact property. Write the new property ID in column D for each row.
When you need to flag which properties have no fallback value
Properties without a fallback can cause blank fields in emails.
List all Resend contact properties and write key, type, and fallback into columns A, B, and C of ContactProperties. Add "NO FALLBACK" in column D for any row where column C is blank.
When you want to check which properties are referenced in templates
You suspect some properties are defined but never used.
List all Resend contact properties and write their keys into column A of ContactProperties. Also fetch all Resend templates. For each property key, check if it appears in any template content and write "in use" or "unused" in column B.
When you need a full schema audit in one shot
You want all properties pulled, fallbacks flagged, and stale unused ones surfaced at the top.
List all Resend contact properties and write key, type, fallback value, and creation date (if available) into columns A through D of ContactProperties. Add "NO FALLBACK" in column E for rows with blank fallbacks. Sort so NO FALLBACK rows appear first.
The pattern: pulling the schema and annotating it happen in one prompt.
Try It
Get the 7-day free trial of SheetXAI and open any workbook, then ask it to pull your Resend contact properties. The Resend integration is included in every SheetXAI plan. See also how to export Resend templates from Excel or the Resend in Excel overview.