The Scenario
Your product manager dropped a request this morning: before the quarterly roadmap meeting, she needs to know which of Nango's 250+ providers support OAuth2 versus API Key auth, and how many fall into each category. She wants it in a workbook she can filter herself.
You've seen the Nango provider list in the docs. It's long. Manually going through it and recording auth modes into an Excel worksheet is not how you want to spend your pre-meeting hour.
The bad version:
- Open the Nango provider documentation, start copying provider names and auth modes into a worksheet
- Realize the docs list providers across multiple pages and the table format doesn't copy cleanly into Excel
- Give up halfway through and send a partial list with a note that says "~120 providers, OAuth2 mostly" — which answers exactly none of her questions
The roadmap meeting is in 90 minutes and your PM is already in back-to-backs.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook. It reads your workbook and talks to Nango directly. Open a blank workbook, launch SheetXAI from the sidebar, and run this prompt.
Pull all providers from Nango into my Excel sheet and populate columns with the provider key, name, and authentication method so I can filter and sort them
What You Get
- A worksheet with one row per available Nango provider
- Column A: provider key
- Column B: display name
- Column C: auth mode (OAuth2, API Key, Basic, OAuth1, etc.)
- Column D: category (CRM, communication, accounting, etc.)
- All 250+ providers written in one pass — ready to filter and sort in Excel
What If the Data Is Not Quite Ready
You only want providers that support OAuth2 for a specific scope of planning
Retrieve all Nango providers and write only the ones with OAuth2 as their auth mode — include the provider key in column A, display name in column B, and category in column C
You need to cross-reference the provider list against integrations you've already built
Pull all available Nango providers into a worksheet called Provider Catalog with the key in column A and auth mode in column B, then look up each provider key in the Built Integrations worksheet column A and mark column C as BUILT if there's a match, AVAILABLE otherwise
The workbook needs a count summary by auth mode below the data
Retrieve all Nango providers, write provider key, display name, and auth mode to columns A through C, then below the last row of data add a summary block showing the total count for each unique auth mode
Pull the full catalog, flag already-built integrations, categorize by auth mode, and summarize coverage gaps by category
Write all Nango providers to the Catalog worksheet with key, display name, auth mode, and category in columns A through D — check each against the Built Integrations worksheet and mark column E as BUILT or AVAILABLE; then in a Summary worksheet write one row per category showing total providers, how many are BUILT, and how many are AVAILABLE
One prompt that builds the catalog, cross-references what you have, and surfaces gaps by category.
Try It
Get the 7-day free trial of SheetXAI and open a blank Excel workbook, then ask it to pull the full Nango provider catalog for your planning session. Once you know what you want to build, see how to document provider auth requirements for the implementation phase or document your configured integrations once they go live.