Back to Supabase in Excel
SheetXAI logo
Supabase logo
Supabase · Excel Guide

Export All Supabase SSO Providers Into an Excel Workbook for an Identity Management Report

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.

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 an Excel workbook one by one
  • You miss one domain alias for provider 4 because the field is 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 workbook, 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 workbook — 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 potentially stale metadata URLs

List all SSO providers for Supabase project abc123 and write provider ID, type, domains, metadata URL, and created_at into this workbook. 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

List all SSO providers for Supabase project abc123 and write provider ID, type, and domains into this workbook. In column D, infer the business unit from the domain prefix and write the label.

When you need to compare providers across two projects

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 project xyz789 (staging) and write into columns D and E. In column G, flag any provider in production that is missing from staging.

When you need the full quarterly SSO report in one shot

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 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 Excel workbook, 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 Excel overview.

Stop memorizing formulas.
Tell your spreadsheet what to do.

Join 4,000+ professionals saving hours every week with SheetXAI.

Learn more