The Scenario
Someone on your team migrated your newsletter platform six months ago and left a note saying the subscriber export was "in the shared drive somewhere." It isn't. Your Curated publication has 8,000 subscribers and you need to know which of them are already paying customers before the next campaign goes out.
Your CRM is an Excel workbook. Your Curated subscriber list is in Curated. There is no automatic connection between the two.
The bad version:
- Find the export option in Curated's settings, download a CSV, open it in Excel, copy the email column, paste it into a new sheet of your CRM workbook, write a VLOOKUP to find overlaps, realize the email formats don't match because Curated uses lowercase and your CRM has mixed case, fix the formula, wait for it to calculate across 8,000 rows.
- Realize you only exported 1,000 rows because Curated's export pagination stopped and you didn't notice.
- Re-export, re-import, redo the formula.
Your campaign is supposed to go out Monday. This is Friday afternoon.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. Through its built-in Curated integration, it can pull your full subscriber list directly — no CSV download, no pagination to manage manually.
Open the SheetXAI sidebar and paste this:
Pull my full Curated subscriber list into my Excel sheet, then highlight in yellow any emails that also appear in column A of the 'CRM Contacts' sheet
What You Get
- Every subscriber from your Curated publication is written into the workbook, one per row, with email address, subscription status, and any available metadata (name, signup date) in adjacent columns.
- Emails that appear in both the Curated export and column A of your "CRM Contacts" worksheet are highlighted yellow so you can see the overlap immediately.
- The subscriber count is written into a summary cell so you can verify the pull was complete.
What If the Data Is Not Quite Ready
You need only active subscribers, not unsubscribes
Pull all active subscribers from my Curated publication into the "Subscribers" worksheet — exclude anyone with an unsubscribed status. One row per subscriber with email in column A and signup date in column B.
You want to segment by how recently they subscribed
Export my full Curated subscriber list into this workbook. In column C, add a label: "New" if they subscribed in the last 30 days, "Recent" if they subscribed in the last 90 days, and "Established" for anyone older than that. Use today's date as the reference.
You need to cross-reference against multiple CRM worksheets
Pull my full Curated subscriber list into the "All Subscribers" worksheet. Then check column A of both the "Enterprise CRM" worksheet and the "SMB CRM" worksheet and highlight in green any subscriber who appears in either one.
Full audience audit with segmentation, cross-reference, and a count summary
Export every Curated subscriber into the "Audience" worksheet. Flag in column C if the email appears in column A of "CRM Contacts." Flag in column D if the email appears in column A of "Trial Users." In column E, write "Both," "CRM only," "Trial only," or "Neither" based on the flags. Add a summary row at the top with total counts for each segment.
Ask for the cleanup and the analysis in a single prompt — you get the full picture without running it in stages.
Try It
Get the 7-day free trial of SheetXAI and open your audience management workbook, then ask it to pull your Curated subscribers and cross-reference them against whatever list you're working with. You can also bulk-import links to a draft or export your full issue performance history — the other guides in this series cover both.