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 a Google Sheet. There are 400-plus customers. The last customer export in the sheet 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, and realize the signup date column is in a format the outreach tool rejects
- 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
- Try to import into the outreach tool, get a column mapping error because the CSV headers don't match what the tool expects, rename the columns in the sheet, 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 Google Sheet. It reads the sheet 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.
List all MoonClerk customers and write the customer name, email, payment form name, subscription status, and signup date into the 'Customer Export' sheet
What You Get
- One row per MoonClerk customer written to the 'Customer Export' sheet
- Columns: customer name, email, payment form name (which maps to the plan tier), subscription status, and signup date
- Dates come through in ISO format (YYYY-MM-DD) by default — compatible with most CRM and outreach tool imports
- Active, paused, and cancelled customers are all included; filter by status column to scope the list
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' sheet — 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' sheet 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 customers who are on cancelled status for a win-back campaign
Pull all MoonClerk customers into the 'Customer Export' sheet 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' sheet 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 sheet is import-ready when you're done.
Try It
Get the 7-day free trial of SheetXAI and open the Google Sheet 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.