The Scenario
You're a customer success manager and you just inherited a loyalty campaign brief from someone who left last month. The idea: identify every customer who has been on a paid plan for more than two years and send them a personalized outreach before the annual renewal cycle.
The problem is that the subscriber data lives in MoonClerk, and the outreach tool your team uses pulls from an Excel workbook. There are 400-plus customers. The last customer export in the workbook is from eight months ago, covers only 60 rows, and has a column layout that doesn't match what the outreach tool expects.
The bad version:
- Export the customer list from MoonClerk as a CSV, open it in Excel, and realize the signup date column is in a format that Excel converts to a decimal number on import
- Manually filter the rows down to customers with a subscription start date more than two years ago — which requires a formula, and the date formatting breaks the formula on every third row
- Try to import into the outreach tool, get a column mapping error because the workbook headers don't match what the tool expects, rename the columns, and repeat the import
Four hundred rows, eight months out of date, and the campaign launch is next Tuesday.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads the workbook and through its built-in MoonClerk integration can pull your full customer list with the specific fields and format your workflow needs — without a CSV detour.
Fetch all MoonClerk customers and write their name, email, and current plan amount into my Excel 'CRM Import' sheet so I can import them into our CRM
What You Get
- One row per MoonClerk customer written to the 'CRM Import' worksheet
- Columns: customer name, email, and current plan amount — in the order specified
- Dates, when requested, come through as ISO format (YYYY-MM-DD) by default — compatible with most CRM import tools
- Active, paused, and cancelled customers are all included unless you scope by status in the prompt
What If the Data Is Not Quite Ready
I only want customers who have been active for more than two years
List all MoonClerk customers and write customer name, email, payment form name, and signup date into the 'Loyalty Targets' worksheet — include only customers where the subscription status is active and the signup date is before 2024-05-14
The outreach tool needs a specific column order and header names
Fetch all active MoonClerk customers and write the following columns into the 'CRM Import' worksheet in this exact order: 'First Name', 'Email', 'Plan', 'Start Date' — parse the customer name to extract the first name, map payment form name to 'Plan', and format Start Date as MM/DD/YYYY
I want to flag cancelled customers for a separate win-back list
Pull all MoonClerk customers into the 'Customer Export' worksheet with name, email, plan name, status, and signup date — add a column called 'Campaign Tag' and set it to 'Loyalty' for active customers with signup date before 2024-01-01 and 'Win-Back' for cancelled customers
Full export with segmentation and CRM-ready headers in one shot
Fetch all MoonClerk customers, write their name (first name only), email, payment form name, subscription status, and signup date into the 'Customer Export' worksheet with headers exactly as: First Name, Email, Plan, Status, Start Date — format dates as MM/DD/YYYY, label active customers signed up before 2024-05-14 as 'Loyalty Target' in a new Tag column, and sort by Start Date ascending
One prompt to pull, format, filter, and tag — so the workbook is import-ready when the prompt finishes running.
Try It
Get the 7-day free trial of SheetXAI and open the Excel workbook you use for customer outreach or CRM imports — ask it to pull your full MoonClerk customer list with the columns your downstream tool expects. See also: analyzing discount code usage and the full MoonClerk overview.