The Scenario
A product analyst just walked into a situation they didn't expect. The post-purchase campaign sequence in MSG91 Segmento is configured and ready — but it's been sitting idle for a month because nobody imported the historical purchase events that would trigger it. The data has been accumulating in a Google Sheet the whole time: 1,200 rows, user IDs in column A, product SKUs in column B, purchase amounts in column C, timestamps in column D. The events need to go into Segmento so the campaign can start firing against real behaviour.
The analyst's deadline is the end of the day.
The bad version:
- Read the MSG91 Segmento API documentation to figure out the create event endpoint and its required payload format.
- Write a script — or ask an engineer to write one — that reads the sheet row by row, formats each event as the correct JSON, and posts it to the API.
- Discover that three columns need to go into the event's
propertiesobject as nested fields, not top-level fields, which requires restructuring the script. - Run it, get a 400 on row 7, debug the payload format.
That's a half-day engineering task. Your deadline is today.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads every row and calls the MSG91 Segmento create event API for you — no script, no JSON formatting, no engineering queue.
For each row in this sheet, create a user event in MSG91 Segmento using the user ID from column A, event type 'purchase' with the product SKU from column B and amount from column C as properties.
What You Get
- One Segmento event is created per row — user ID, event type, and all specified properties submitted correctly.
- Results are returned per row: success confirmation or the error code and reason for rows that didn't post.
- 1,200 rows post in a single pass. No script, no pagination to manage.
What If the Data Is Not Quite Ready
Some user IDs are blank — skip those rows
For each row in this sheet where column A is not blank, create a user event in MSG91 Segmento with event type 'purchase', the product SKU from column B and amount from column C as properties, and write the result to column E.
The event name varies by row rather than being fixed
For each row in this sheet, create an MSG91 Segmento event using the user ID from column A, the event name from column B, and the JSON properties from column C — write the API response status to column D.
Timestamp needs to be included with each event
For each row, create an MSG91 Segmento user event using the user ID in column A, event type 'purchase', the SKU from column B and amount from column C as properties, and the timestamp from column D — write the result to column E.
Deduplicate by user ID and SKU, then bulk-post with cleanup — one prompt
Deduplicate this sheet by the combination of user ID in column A and SKU in column B keeping the row with the highest amount in column C, then for each remaining row create an MSG91 Segmento event with event type 'purchase' and the SKU and amount as properties, writing the result to column E.
That instruction handles the deduplication logic and the event posting in one pass — no separate cleanup step, no second tool.
Try It
Get the 7-day free trial of SheetXAI and open the sheet with your historical user events, then ask it to log them all to MSG91 Segmento so your campaigns can start triggering against real behaviour. See the sibling spoke on exporting Segmento event types or return to the MSG91 hub.