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 sheet 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 spreadsheet row by row
- 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 to get the full picture
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 Google Sheet. It reads your sheet and talks to Nango directly — including the integration script configuration endpoint. Open a sheet, 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 sheet
What You Get
- One row per integration written to the Summary sheet
- 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 sheet — 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 tab
Pull all Nango integration scripts into the Scripts sheet 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 tab 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 sheet with integration key, script name, and type in columns A through C, then in the Coverage tab 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 tab 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 Google Sheet 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.