The Scenario
A developer on the checkout team exported 150 abandoned cart records from a custom-built checkout system into an Excel workbook — customer email in column A, cart total in column B, product SKUs in column C, and the timestamp in column D. The records need to go into Remarkety so the automated cart-recovery sequence can fire for each customer. The sequence is already built and tested. The only thing blocking it is that the data isn't in Remarkety yet.
The developer handed off the workbook at 4 PM on a Wednesday and went back to the sprint. Moving the data into Remarkety is now your problem.
The bad version:
- Look up the Remarkety Tracks API endpoint for cart events. Figure out the required payload shape. Write a script to iterate through the rows, format each one as a Remarkety cart event, and POST it to the API.
- Test on five rows. Discover that the product SKU field needs to be an array, but column C has the SKUs as a comma-separated string. Add a parsing step.
- Run the full batch. Row 73 fails because the cart total is formatted as currency with a dollar sign and Remarkety expects a plain number. Fix it. Rerun rows 73 through 150.
You are not a developer. The developer who handed this off assumed you could handle the "easy" part.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook. It reads the data, figures out the structure, and sends the cart events to Remarkety — including the array formatting and the type normalization — without you having to touch the API or write a script.
Push all 150 abandoned cart records from this Excel workbook to Remarkety — email in column A, cart value in column B, and product SKU list in column C. Column C has comma-separated SKUs — treat each one as a separate item in the cart. Skip any rows where column A is blank.
What You Get
- A Remarkety cart event created for each row with a valid email address.
- Comma-separated SKUs in column C parsed into a proper array for the Remarkety event payload automatically.
- Cart totals normalized to plain numbers even if they contain currency symbols.
- A count of successfully tracked events returned in the sidebar, plus a note on any rows that failed and why.
What If the Data Is Not Quite Ready
The cart total column has dollar signs and the API is rejecting them
Track cart events in Remarkety for each row. Email in column A. Strip any dollar signs or commas from column B and use the resulting number as the cart total. Product SKUs in column C, comma-separated — send as an array. Skip rows where column A is blank.
You need to add a cart URL to each event for the recovery email link
Track a cart event in Remarkety for each row. Email in column A, cart total in column B, SKUs in column C. For the cart URL, use the pattern "https://store.example.com/cart?email=" followed by the email in column A. Skip rows where column A is blank.
Some customers are already in Remarkety and you only want to track carts for new ones
Cross-check the emails in column A against existing Remarkety contacts. For any email that is not yet a Remarkety contact, create the contact first using email in column A and then track a cart event using cart total in column B and SKUs in column C. Skip rows where column A is blank.
Full pipeline — dedup, normalize, track, and log results in one shot
Go through each row in this workbook. Email in column A, cart total in column B (strip currency symbols), product SKUs in column C (comma-separated, treat as array), timestamp in column D. Skip rows where column A is blank or column B is zero. For each valid row, track a cart event in Remarkety. After the run, write a result log starting in column F: "Success" if the event was tracked, or the error message if it failed.
One prompt does the full pipeline — cleanup, event tracking, and a result log you can hand back to the developer.
Try It
Get the 7-day free trial of SheetXAI and open the Excel workbook with your abandoned cart records, then ask it to push those events into Remarkety before the recovery sequence window closes. Also see: Bulk Import Contacts Into Remarkety and the Remarkety overview.