The Scenario
A new analytics integration project just landed on your plate. You're a marketing technologist and you need to map MSG91 Segmento's configured event types to your CDP's internal event taxonomy before the engineering team can connect the two systems. The list of event types lives somewhere in the MSG91 console. The mapping template lives in an Excel workbook. And the spec is due by end of week.
You've never needed to document Segmento event types before. You have no idea how many there are.
The bad version:
- Log into MSG91, navigate to Segmento, find where event types are listed — which takes longer than expected.
- Manually copy each event type name and ID into the workbook row by row.
- Realise you're not sure if the list is complete, because the console paginates and you've lost track of which page you were on.
What should take ten minutes becomes an hour of careful scrolling.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It calls the MSG91 Segmento API, pulls every configured event type, and writes them to your workbook.
Fetch all event types from MSG91 Segmento and write each event type name and ID to this sheet.
What You Get
- Every configured Segmento event type is written to the workbook — name in one column, ID in the next.
- The list is complete. No pagination to manage, no spot-checking needed.
- You have a clean reference ready to plug into the CDP mapping template.
What If the Data Is Not Quite Ready
You need a third column for the CDP mapping
Fetch all event types from MSG91 Segmento, write the event type name to column A and ID to column B, then add an empty column C with the header 'CDP Event Name' for manual mapping.
Cross-reference against an existing internal taxonomy list
Fetch all MSG91 Segmento event types and write them to columns A and B, then in column C mark any event type name that appears in the 'Internal Taxonomy' worksheet column A as 'matched' and leave others blank.
Filter to event types matching a naming pattern
Fetch all MSG91 Segmento event types, filter to those whose names start with 'purchase_', and write the matching names and IDs to columns A and B.
Pull, match, flag unmapped, and sort alphabetically — one prompt
Fetch all MSG91 Segmento event types, write name and ID to columns A and B, look up each event type name against the 'Internal Taxonomy' worksheet column A, mark matched ones in column C as 'mapped', and sort the output alphabetically by event type name.
That instruction handles the pull, the cross-reference, the flag, and the sort — the engineering team gets a complete reference without you stitching four steps together.
Try It
Get the 7-day free trial of SheetXAI and open the integration mapping workbook you're building, then ask it to pull all MSG91 Segmento event types so you have a full schema reference. See the sibling spoke on logging user events to Segmento or return to the MSG91 hub.