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 sheet 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 Google Sheet that reads your data and talks to Nango on your behalf. Open a blank sheet, launch SheetXAI from the sidebar, and give it this prompt.
List all connections from my Nango account and write each connection's ID, provider config key, end user ID, and creation date into a new sheet called Nango Connections
What You Get
- A new sheet tab named Nango Connections is created automatically
- Column A: connection ID
- Column B: provider config key
- Column C: end user ID
- Column D: creation date (ISO timestamp)
- 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 sheet called GitHub Connections, sorted by creation date ascending
You need to join connection data with a customer name lookup in a second tab
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 tab 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 sheet 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 sheet with full details, then in the Summary sheet 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 does 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 Google Sheet, 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.