The Scenario
You are an e-commerce manager migrating from Klaviyo to eSputnik. The migration is supposed to be live in four business days.
You have 900 historical orders sitting in a Google Sheet, one row per order: customer email in column A, external order ID in column B, order total in column C, order date in column D. That order history needs to be in eSputnik before launch so the abandoned-cart and repurchase automations have enough data to trigger correctly from day one.
The slow version of this week:
- You read eSputnik's event import documentation and realize it requires a specific JSON structure
- You ask your developer to write a script to convert the sheet rows to the right format
- The developer is mid-sprint and gets to it two days later
- The script runs but errors on 40 rows with malformed dates
- You manually fix the dates, re-run the script, re-import
- It is Thursday morning and you still have not verified whether the automations are actually triggering correctly.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI reads the sheet and calls eSputnik's event import API for you, so you do not need a developer or a custom script.
Open the SheetXAI sidebar and type:
Import all 900 orders from my 'Order History' sheet into eSputnik — customer email in A, external order ID in B, order total in C, order date in D. Import each row as a past order event.
SheetXAI reads every row, structures each one as an eSputnik order event, calls the import API, and gives you a confirmation. The automations have the history they need before launch.
What You Get
900 historical order events in eSputnik, structured correctly for automation triggers:
- Each row imported as an order event — not as a contact field, as an actual event eSputnik can trigger off
- External order ID preserved — so your reporting can cross-reference eSputnik events back to the original orders
- Date field handled — SheetXAI passes the date in the format eSputnik expects, no conversion by hand
- Confirmation returned — you know the import ran without verifying each row manually
The automation trigger window matters here. If you import 900 orders but they are all attributed to today's date instead of their original order dates, your repurchase timing will be off. SheetXAI imports the date values as-is from the sheet, not as today.
What If the Data Is Not Quite Ready
Migration source data is never clean. SheetXAI handles the cleanup and the import in the same prompt.
When order dates are in mixed formats
Some rows have dates formatted as "2025-03-14," others as "March 14, 2025," others as "14/03/25." eSputnik expects one consistent format.
Normalize all dates in column D to ISO format (YYYY-MM-DD). Then import all rows into eSputnik as past order events — email in A, order ID in B, total in C, normalized date in D.
When some orders are missing totals
A handful of rows have no value in column C, either cancelled orders or data gaps from the old platform.
Import all rows from this sheet into eSputnik as past order events. For rows where column C is blank, import the event with the order total set to 0 and add a note that the total was missing from source. Log any such rows in a new column E with the label "MISSING TOTAL."
When you only want orders from the past 12 months
The sheet goes back three years but you only want the last 12 months to seed the automations.
Filter to rows where column D is dated within the last 12 months from today. Import only those rows into eSputnik as past order events — email in A, order ID in B, total in C, date in D.
When you also need to deduplicate on order ID before importing
The Klaviyo export included some orders twice because the account had duplicate events from a prior integration.
Deduplicate the rows in this sheet by order ID in column B, keeping one occurrence per order. Then import the deduplicated set into eSputnik as past order events — email in A, order ID in B, total in C, date in D. Write the total count of imported events into cell E1.
The pattern: instead of cleaning the export and then writing a separate import script, you ask for both in one prompt. The migration gets done this afternoon.
Try It
Get the 7-day free trial of SheetXAI and open any sheet with historical order or event data, then ask it to push the records to eSputnik. The eSputnik integration is included in every SheetXAI plan. See also how to bulk-import contacts from a sheet or the eSputnik in Google Sheets overview.