The Scenario
You're a solutions architect and it's the third time this month that a customer success rep has pinged you asking which Nango integration supports a specific sync. Does the Salesforce integration have a contacts sync? Does the HubSpot one have an action for creating deals? You know the answer because you built these integrations, but nobody else does, and there's no shared reference.
The ask landed in your queue this morning from your head of CS: build a single workbook that catalogs every integration's available syncs and actions, and share it with the whole team before the weekly standup.
The bad version:
- Open the Nango dashboard, navigate to each of your 15 integrations one by one, read the scripts listed under each one
- Manually record the integration name, sync names, and action names in a workbook worksheet by worksheet
- Realize the dashboard shows script names but not their descriptions unless you click into each one, so you go back and click into each integration's individual scripts
By the time you've done eight integrations, standup has started.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads your workbook and talks to Nango directly — including the integration script configuration endpoint. Open a workbook, launch SheetXAI from the sidebar, and run this prompt.
Retrieve all integration script configurations from my Nango account and write each integration's name, its sync script names, and action script names into a summary worksheet
What You Get
- One row per integration written to the Summary worksheet
- Column A: integration key
- Column B: comma-separated list of sync script names
- Column C: comma-separated list of action script names
- All 15 integrations documented in one pass — no dashboard clicking, no manual entry
What If the Data Is Not Quite Ready
You need one row per script rather than one row per integration
Pull the Nango scripts config and write one row per script into the worksheet — column A for integration key, column B for script name, column C for script type (sync or action)
The catalog needs to cross-reference a list of requested capabilities from a second worksheet
Pull all Nango integration scripts into the Scripts worksheet with integration key in column A, script name in column B, and type in column C, then look up each script name in the Requests worksheet column A and mark column D as COVERED if there's a match, MISSING otherwise
You need to flag integrations that have no action scripts at all
Retrieve all Nango integration script configs, write each integration key to column A and its action count to column B, then add a column C that says NO ACTIONS for any integration with zero action scripts
Document all scripts, flag gaps, cross-reference customer requests, and summarize coverage by integration type
Write all Nango scripts to the Raw worksheet with integration key, script name, and type in columns A through C, then in the Coverage worksheet write one row per integration showing the integration key in column A, sync count in column B, action count in column C, and whether it has been requested by any customer in the Requests worksheet in column D — mark REVIEW in column E for integrations with customer requests but no matching scripts
One prompt that builds the catalog and the gap analysis at the same time.
Try It
Get the 7-day free trial of SheetXAI and open any Excel workbook where you're tracking integration capabilities, then ask it to retrieve your Nango script configurations. Also useful: document your configured integrations for a higher-level view, or document provider auth requirements to capture implementation details.