The Scenario
You're a data engineer and you're three hours into building a usage report when you hit the wall. You need contact counts from HubSpot for 30 different customer connections — each one managed in Nango. Getting those counts means making a proxied API call for each connection, and you have the connection IDs and provider config keys in a workbook, but no clean way to loop through them and write results back without writing a script.
This isn't a one-time report. It runs monthly. And the person who asked for it has already asked twice why last month's version took three days to produce.
The bad version:
- Write a Python script that reads the workbook, iterates the rows, calls the Nango proxy endpoint for each connection, extracts the contact count from the HubSpot response, and writes it back to the correct cell
- Handle authentication errors for connections that have expired or been revoked mid-run
- Debug the 6 rows where the response schema was slightly different from what you expected and the count extraction fails
By the time the script works reliably, you've spent longer writing it than the report itself will take to review.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook. It reads your connection data and uses Nango's proxy to make authenticated API calls on your behalf. Launch SheetXAI from the sidebar and run this prompt.
Use Nango to retrieve credentials for each connection in my Excel sheet column A, then make a proxied GET request to the configured API endpoint in column B and write the response data into column C
What You Get
- SheetXAI iterates every row in sequence
- For each row: uses the connection_id and provider_config_key to make a proxied GET request through Nango
- Extracts the relevant data from the response
- Writes the result into column C
- Rows where the proxy call fails (expired connection, rate limit, wrong endpoint) get an error note in column C so you know exactly which ones need attention
What If the Data Is Not Quite Ready
Some connections have been revoked and should be flagged before making API calls
For each row in my workbook, first verify the Nango connection in column A is still valid — write INVALID in column C and skip the proxy call for any that aren't; for valid connections, make the proxied GET request and write the result in column C
You need to pull multiple metrics per connection, not just contact count
For each row in my workbook with a connection_id in column A and provider_config_key in column B, use the Nango proxy to call HubSpot and write the total contact count in column C and the total deal count in column D
The endpoint path differs by provider — some rows use HubSpot, others use Salesforce
For each row in my workbook, use the provider_config_key in column B to determine which endpoint to call via Nango proxy — write the result count in column C for each row based on the appropriate API for that provider
Validate connections, make proxied calls for valid ones, write counts, and flag any connection where the count dropped more than 20% since last month
For each row with a connection_id in column A, verify the connection is active and proxy GET the contact count into column C; then compare column C to the previous month count in column D — write FLAG in column E for any row where the new count is more than 20% lower than the previous count, and OK otherwise
One prompt that validates, fetches, and runs the comparison logic in a single pass.
Try It
Get the 7-day free trial of SheetXAI and open the Excel workbook with your Nango connection IDs, then ask it to proxy the API calls and write the results. For setup context, see how to export your full connection inventory or bulk-import credentials as connections if you're still migrating to Nango.