The Scenario
You are a security engineer at a company that uses SAML SSO for its internal tools. Every quarter, your identity management report must include every SSO provider configured on your Supabase project: provider ID, associated domains, and metadata URL.
Your Supabase project has six SSO providers configured across three business units. The quarterly report is due Friday. Your previous approach was to copy these details from the Supabase dashboard by hand.
The slow version:
- You log into the Supabase dashboard and navigate to Auth > SSO
- You see six providers listed — no export button
- You click into each one to copy the provider ID, domains, and metadata URL
- You paste them into a Google Sheet one by one, reformatting as you go
- You miss one domain alias for provider 4 because the field is long and truncated in the UI
- The report goes out with an incomplete provider record. The auditor asks for a correction.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI reads your Supabase SSO provider list directly and writes the formatted inventory into the sheet, so you do not have to click into each provider or risk missing truncated fields.
Open the SheetXAI sidebar and type:
List all SSO providers for Supabase project abc123. Write provider ID, type, associated domains, and metadata URL into this sheet — one row per provider. Use readable headers.
SheetXAI calls the Supabase SSO API, retrieves all six providers with their full domain lists, and writes the formatted inventory.
What You Get
A complete SSO provider inventory ready for the quarterly report:
- One row per provider — provider ID, type, domains, metadata URL
- Full domain lists — no truncation, no missed aliases
- All six providers — no dashboard clicking, no copy errors
The report goes out Friday with a complete, accurate provider list. The auditor has what they need.
What If the Inventory Needs More Context
A flat provider list is the starting point. SheetXAI can enrich it in the same prompt.
When you need to flag providers with expired metadata URLs
Metadata URLs sometimes rotate and old ones stop resolving.
List all SSO providers for Supabase project abc123 and write provider ID, type, domains, metadata URL, and created_at into this sheet. Add a note in column E: "Verify metadata URL if provider was created more than 12 months ago."
When you need to check which providers cover which business units
Your six providers map to three business units. You want that attribution visible in the report.
List all SSO providers for Supabase project abc123 and write provider ID, type, and domains into this sheet. In column D, infer the business unit from the domain (e.g. @eu.company.com is EU Operations, @us.company.com is US Operations) and write the label.
When you need to compare providers across two Supabase projects
You have a staging project and a production project and want to verify they have the same providers configured.
List all SSO providers for Supabase project abc123 (production) and write provider ID and domains into columns A and B. List all SSO providers for Supabase project xyz789 (staging) and write provider ID and domains into columns D and E. In column G, flag any provider ID in production that is missing from staging.
When you need the full quarterly SSO report in one shot
Provider inventory, business unit attribution, metadata age flags, and a cross-project diff — all in one prompt.
List all SSO providers for Supabase project abc123. Write provider ID, type, domains, metadata URL, and created_at into the Providers tab. In the Attribution tab, add business unit labels based on domain prefix. In the Risk tab, flag providers older than 12 months with a note to verify the metadata URL. In the Diff tab, compare against Supabase project xyz789 and list any providers missing from staging.
The pattern: the prompt produces the report structure the auditor expects, not just the raw list.
Try It
Get the 7-day free trial of SheetXAI and open any Google Sheet, then ask it to list the SSO providers for your Supabase project. The Supabase integration is included in every SheetXAI plan. For related workflows, see how to export organisation members for an access review or the Supabase in Google Sheets overview.