The Scenario
You're a developer relations manager and a customer success handoff landed in your queue this morning. A new enterprise customer wants to know exactly which integrations your platform supports — provider names, authentication modes, whether each one uses OAuth2 or an API key — before they commit to going live. They want it in writing.
You have 15 integrations configured in Nango. Their names are scattered across the dashboard. You remember most of them, but not all, and you definitely don't have the auth modes memorized.
The bad version:
- Open the Nango dashboard, click into each integration one by one, screenshot or manually copy the provider name, display name, auth mode, and creation date
- Paste into a shared doc or sheet, reformatting each time because the dashboard shows different fields depending on which screen you're on
- Realize you forgot three integrations, go back, add them, then reconcile the date format because two entries came in as UTC and one as local time
This sheet is going to a customer. It cannot look like it was assembled in twenty minutes from five different browser tabs.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads your spreadsheet context and talks to Nango directly. Open a sheet, launch the SheetXAI sidebar, and run this prompt.
List all integrations configured in my Nango account and populate a sheet with each integration's unique key, provider name, display name, auth mode, and creation date
What You Get
- One row per configured integration, written to the active sheet
- Column A: unique integration key
- Column B: provider name (as Nango identifies it)
- Column C: display name
- Column D: auth mode (OAuth2, API Key, Basic, etc.)
- Column E: creation date (ISO timestamp)
- Complete — no integrations skipped, no manual reconciliation
What If the Data Is Not Quite Ready
You only want integrations using a specific auth mode for the audit
List all Nango integrations that use OAuth2 as their auth mode and write the integration key, provider name, and creation date to the sheet — skip any that use API Key or Basic auth
You need to add a "status" column based on whether the integration has active connections
List all Nango integrations, write the key and provider name to columns A and B, then check the connection count for each integration and write it to column C — mark column D as ACTIVE if count is greater than 0, UNUSED otherwise
The integration list needs to be joined with internal notes from another tab
Pull all Nango integrations into the Integrations sheet with the unique key in column A and provider name in column B, then look up each integration key in the Notes tab column A and copy the internal owner name from column B into column C of the Integrations sheet
Document integrations, flag unused ones, and build a summary count by auth mode in one pass
Write all Nango integrations to the Raw sheet with key, provider name, auth mode, and connection count in columns A through D, then in the Summary sheet write one row per auth mode showing the mode in column A and the total integration count in column B — highlight any auth mode with more than 5 unused integrations in column C
The summary and the raw data in a single operation, no second prompt needed.
Try It
Get the 7-day free trial of SheetXAI and open any Google Sheet where you're tracking integration coverage, then ask it to document your current Nango setup. Also worth reviewing: how to catalog your sync and action scripts or document provider auth requirements.