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 workbook, 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 workbook 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 Excel workbook. It reads your spreadsheet context and talks to Nango directly. Open a workbook, launch the SheetXAI sidebar, and run this prompt.
Pull all Nango integrations into my Excel worksheet and fill in the unique key, provider config key, and last-updated timestamp for each one in separate columns
What You Get
- One row per configured integration, written to the active worksheet
- Column A: unique integration key
- Column B: provider config key
- Column C: display name
- Column D: auth mode (OAuth2, API Key, Basic, etc.)
- Column E: last-updated 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 worksheet — 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 worksheet
Pull all Nango integrations into the Integrations worksheet with the unique key in column A and provider name in column B, then look up each integration key in the Notes worksheet column A and copy the internal owner name from column B into column C of the Integrations worksheet
Document integrations, flag unused ones, and build a summary count by auth mode in one pass
Write all Nango integrations to the Raw worksheet with key, provider name, auth mode, and connection count in columns A through D, then in the Summary worksheet 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 Excel workbook 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.