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 a Google Sheet. 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 Google Sheets, copy the email column, paste it into a new tab of your CRM sheet, write a VLOOKUP or MATCH formula 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 Google Sheet. 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:
Export all email subscribers from my Curated publication into this Google Sheet with one subscriber per row, then highlight in yellow any emails that also appear in column A of the "CRM Contacts" tab
What You Get
- Every subscriber from your Curated publication is written into the sheet, 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" tab 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" tab — 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 sheet. 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 tabs
Pull my full Curated subscriber list into the "All Subscribers" tab. Then check column A of both the "Enterprise CRM" tab and the "SMB CRM" tab 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" tab. 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 sheet, 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.