The Scenario
You're a backend developer and you've been handed a list of 20 providers that the product team wants to integrate over the next quarter. Before a single line of code gets written, you need a reference document: OAuth authorization URLs, token endpoints, auth modes, required credential fields. You need it in a sheet so the team can sort, filter, and assign owners.
The Nango documentation covers individual providers. Looking up 20 of them one at a time, copying the relevant fields, and pasting them into a spreadsheet is an hour of your afternoon.
The bad version:
- Open the Nango provider docs, search for the first provider, copy the auth mode and authorization URL into your sheet
- Repeat for each of the remaining 19 providers, tabbing between the docs and the spreadsheet each time
- Realize three of the provider keys you were given don't match Nango's canonical naming, spend 15 minutes cross-referencing to find the right keys before you can pull any data for those rows
This reference sheet is going into the sprint planning doc. Every entry needs to be accurate, and you have a planning call in two hours.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Google Sheet. It reads your existing data and talks to Nango directly. If you already have provider keys in column A, launch SheetXAI from the sidebar and run this prompt.
For each provider key listed in column A, retrieve the provider configuration from Nango and write the auth mode, authorization URL, token URL, and required credentials into columns B, C, D, E
What You Get
- Column B: auth mode for each provider (OAuth2, API Key, Basic, etc.)
- Column C: authorization URL (OAuth2 providers)
- Column D: token URL (OAuth2 providers)
- Column E: required credential fields listed
- All 20 rows populated in one pass — no manual lookups, no tab-switching
What If the Data Is Not Quite Ready
Some provider keys in column A are incorrect and need to be validated first
For each provider key in column A, attempt to retrieve the provider config from Nango — if found, write the auth mode in column B; if not found, write INVALID KEY in column B so I can fix those rows before pulling the remaining fields
You need to filter the list to only OAuth2 providers before populating the remaining columns
For each provider in column A, retrieve the auth mode from Nango and write it in column B — then for any row where column B says OAuth2, also retrieve and write the authorization URL in column C and token URL in column D; leave columns C and D blank for non-OAuth2 providers
The sheet needs an additional column noting whether each provider is in Nango's standard catalog or requires custom configuration
For each provider key in column A, retrieve the provider config from Nango and write the auth mode in column B and authorization URL in column C — then add a column D that says STANDARD if the provider is in Nango's built-in catalog, CUSTOM if it requires custom configuration
Validate all keys, pull full auth details for valid ones, flag invalid ones, and summarize how many of each auth type you're dealing with
Check each provider key in column A against Nango — write INVALID in column B for any that don't exist; for valid ones write the auth mode in column B and authorization URL in column C; then in a row below the data write a count of how many providers are OAuth2 vs API Key vs other
One prompt that handles validation, detail retrieval, and summary counting in a single pass.
Try It
Get the 7-day free trial of SheetXAI and open the Google Sheet with your provider key list, then ask it to retrieve the auth configuration for each one from Nango. Also relevant: catalog your configured integrations once implementation begins, or export the full Nango provider catalog if you're still in the discovery phase.