The Scenario
It's Thursday morning and your security team has just landed a quarterly access review request in your inbox. They need a full list of every active OAuth connection your platform manages through Nango — connection IDs, provider config keys, end-user organization IDs, and when each connection was created. By end of day.
You know the data is in Nango. You've looked at the dashboard before. But the dashboard shows you one page of connections at a time, and you have 340 of them across 12 integrations.
The bad version:
- Open the Nango dashboard, filter to the first integration, copy the visible connection rows into a worksheet manually
- Repeat for each of the remaining 11 integrations, reformatting column names each time to match a consistent header row
- Realize the dashboard doesn't show creation dates in the default view, go back through each integration's detail panel, and pull them one by one
Your security team is not waiting two days for this list. And they're certainly not waiting for the third iteration when someone asks you to re-pull it with a different date filter.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook that reads your data and talks to Nango on your behalf. Open a blank workbook, launch SheetXAI from the sidebar, and give it this prompt.
Pull every Nango connection into my Excel sheet — include the connection ID, integration name, end user organization ID, and any metadata tags in separate columns
What You Get
- A new worksheet with one row per Nango connection
- Column A: connection ID
- Column B: provider config key (integration name)
- Column C: end user organization ID
- Column D: metadata tags
- All 340+ connections written in one pass — paginated automatically, no manual iteration
What If the Data Is Not Quite Ready
The connection list is too broad — you only need connections for one specific integration
List all Nango connections where the provider config key is github-prod and write the connection ID, end user ID, and creation date into a worksheet called GitHub Connections, sorted by creation date ascending
You need to join connection data with a customer name lookup in a second worksheet
List all Nango connections and write the connection ID and end user ID into columns A and B of the Connections sheet, then look up each end user ID in the Customers worksheet column A and write the matching company name from column B into column C
The export needs to flag connections older than 90 days for review
List all Nango connections, write them to the Audit worksheet with ID in column A, provider config key in column B, and creation date in column C, then add a column D that says REVIEW if the connection was created more than 90 days ago, and CURRENT otherwise
Clean up the raw export, flag stale connections, and summarize the count by integration in one shot
Pull all Nango connections into the Raw worksheet with full details, then in the Summary worksheet write one row per provider config key showing the integration name in column A, total connection count in column B, and how many are older than 90 days in column C — flag any integration with more than 20 stale connections in column D as HIGH RISK
One prompt that handles the extract, the analysis, and the summary without a second pass.
Try It
Get the 7-day free trial of SheetXAI and open a blank Excel workbook, then ask it to pull your full Nango connection inventory. When the access review comes back next quarter, the pull takes thirty seconds. Also useful: see how to catalog your configured integrations or bulk-delete stale connections.