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 sheet 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 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 sheet
- Realize the docs list providers across multiple pages and the table format doesn't copy cleanly into a spreadsheet
- 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 Google Sheet. It reads your spreadsheet and talks to Nango directly. Open a blank sheet, launch SheetXAI from the sidebar, and run this prompt.
Retrieve the full list of available Nango providers and write each provider's key, display name, auth mode, and category into a new sheet called Nango Provider Catalog
What You Get
- A new sheet tab named Nango Provider Catalog is created
- 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
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 sheet 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 tab column A and mark column C as BUILT if there's a match, AVAILABLE otherwise
The sheet 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 sheet with key, display name, auth mode, and category in columns A through D — check each against the Built Integrations tab and mark column E as BUILT or AVAILABLE; then in a Summary tab 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 Google Sheet, 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.