The Scenario
You are a data quality lead. Your company runs eight Segment sources, and the schema settings are inconsistent across them. Some block certain events, some allow everything, and some have been touched by three different engineers over two years.
You need to document the schema settings for all eight sources before the quarterly data quality review. The source IDs are in column A of an Excel workbook and the review deck is due Wednesday at noon.
The manual version:
- Log into Segment
- Open each source's schema settings panel
- Read the allowed events list, blocked events list, and property filter rules
- Copy them into the workbook by hand
- Do this eight times
- Realize source 5 has 47 allowed event types and you are copy-pasting them one at a time
- Wednesday morning. Five of eight sources done. Deck is in an hour.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI reads the Segment API and writes schema settings into the workbook, so you do not have to click through each source's settings panel.
Open the SheetXAI sidebar and type:
For each source ID in column A, fetch the Segment schema settings and write the allowed events, blocked events, and property filter rules into columns B, C, and D of the Schema Audit tab.
SheetXAI reads column A, calls Segment's Config API for each source ID, and writes the schema data back into the workbook per row. All eight sources in one pass.
What You Get
A schema documentation tab with one row per source:
- Column A — source ID (your source data)
- Column B — allowed events (comma-separated list or JSON array)
- Column C — blocked events
- Column D — property filter rules
For sources where schema enforcement is off, the cell reflects that directly so you know where enforcement gaps exist.
What If the Data Is Not Quite Ready
Schema audits always need comparison and cross-referencing. SheetXAI handles it in the same prompt.
When you want the enforcement level alongside the lists
The enforcement level — enforcing, filtering, or reporting — is as important as the event lists.
For each source ID in column A, fetch the Segment schema settings and write the schema enforcement level into column B, allowed event count into column C, blocked event count into column D, and the full allowed events list as a comma-separated string into column E of the Schema Audit tab.
When you want to flag sources in unrestricted mode
You want to identify which sources allow all events with no enforcement, as those are creating noise in downstream tools.
For each source ID in column A, fetch the Segment schema settings. Write the enforcement level into column B. In column C, write "UNRESTRICTED — review needed" for any source where enforcement is off or allows all events. Write the blocked events list into column D.
When you need to compare settings against a standard template
You have a Standard Schema tab that defines the expected allowed events for each source type. You want to flag any source that allows events outside the standard set.
For each source ID in column A, fetch the Segment schema settings and write the allowed events list into column B. Compare the allowed events for each source against the expected list in the Standard Schema tab (matched by source type in column C). Write COMPLIANT or NON-COMPLIANT into column D.
When you need enforcement level, event lists, property rules, and a compliance flag all in one pass
The full audit requires all fields and a comparison against the standard in one tab.
For each source ID in column A, fetch the Segment schema settings. Write the enforcement level into column B, allowed events list into column C, blocked events list into column D, and property filter rules into column E. Compare the allowed events against the Standard Schema tab and write COMPLIANT or NON-COMPLIANT into column F.
The pattern: describe the documentation structure, comparison logic, and flag format all in one prompt.
Try It
Get the 7-day free trial of SheetXAI and open any workbook with Segment source IDs, then ask it to pull the schema settings for each one. The Segment integration is included in every SheetXAI plan. For related workflows, see how to pull destination configurations for audit or the Segment in Excel overview.