The Scenario
The win-back campaign launches Friday. Your list of 600 re-engagement targets has been sitting in a Google Sheet for two weeks — email in column A, first name in column B, last name in column C, phone in column D, and a column E flagging which customers you actually want to include. None of them are in Remarkety yet.
The bad version:
- Export the sheet as a CSV, rename the headers to match Remarkety's import schema, remove the rows where column E says "exclude," and hope you got the phone number format right.
- Upload the file. Watch Remarkety reject 47 rows because of formatting errors. Fix the errors in the CSV, re-upload, check again.
- Repeat when someone adds 30 more contacts to the sheet on Thursday morning.
The campaign window is fixed. You're not spending Thursday evening in the Remarkety import wizard.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Google Sheet. It reads the data, understands the structure, and talks to Remarkety directly — no CSV, no import wizard, no field-by-field mapping on your end.
Upload all contacts in this sheet to Remarkety using email in column A, first name in column B, last name in column C, and phone in column D. Only include rows where column E says "include". Skip any rows where column A is blank.
What You Get
- All qualifying rows pushed to Remarkety as contacts in a single operation.
- Rows with blank email addresses skipped automatically — no manual filtering before the upload.
- Any rows Remarkety rejects (duplicate emails, malformed phone numbers) surfaced in a sidebar note with the specific error per row.
- A count of successful imports returned so you know exactly how many contacts landed.
What If the Data Is Not Quite Ready
The phone numbers have mixed formats — some with country codes, some without
Upload contacts from columns A through D to Remarkety as before, but first normalize the phone numbers in column D: strip any leading + signs and country codes so all numbers are in 10-digit format.
Some rows are missing last names and the import keeps failing on required fields
Upload contacts to Remarkety from this sheet. Email in column A, first name in column B. If column C is blank, use "Customer" as the last name. Phone in column D. Skip rows where column A is empty.
The list is split across two tabs — "New" and "Returning"
Combine the contacts from the "New" tab and the "Returning" tab. Use email in column A and first name in column B on both tabs. Upload the combined list to Remarkety as contacts, deduplicating by email address.
The data needs cleanup and tagging before import
Go through the contact list in this sheet. Remove any rows where column A is not a valid email format. For remaining rows, tag each contact with "win-back-2026" as a custom attribute. Then upload all cleaned, tagged contacts to Remarkety using email in column A, first name in column B, and last name in column C.
One prompt handles the audit, the tagging, and the upload — you don't have to stage those as three separate steps.
Try It
Get the 7-day free trial of SheetXAI and open the Google Sheet with your re-engagement list, then ask it to push those contacts into Remarkety before your next campaign window. Also see: Export Remarkety Customer Data for RFM Analysis and the Remarkety overview.