The Scenario
You are a data quality lead. Your company runs eight Segment sources — a JavaScript source, a server-side source, a mobile SDK, and five partner integrations — and the schema settings are inconsistent across them.
Some sources block certain events. Some allow everything and flag unknown properties. Some have been configured by three different engineers over two years and nobody knows what the current state is.
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 a Google Sheet 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, the blocked events list, and the property filter rules
- Copy them into the sheet 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. You have five of eight sources done. The 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 sheet, 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.
SheetXAI reads column A, calls Segment's Config API for each source ID, and writes the schema data back into the sheet per row.
What You Get
A schema documentation sheet 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
All eight sources in one pass. No clicking through individual settings panels.
For sources where a field is empty or schema enforcement is off, the cell will reflect 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 schema enforcement level alongside the lists
The enforcement level — whether schema settings are enforcing, filtering, or just 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.
When you want to flag sources that allow all events with no restrictions
You want to identify which sources are in "allow all" mode with no schema enforcement, as those are the ones 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. Then 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 sheet.
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, the comparison logic, and the flag format all in one prompt.
Try It
Get the 7-day free trial of SheetXAI and open any sheet 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 Google Sheets overview.