The Scenario
You work on the network security team at a mid-size SaaS company. The threat intelligence lead asked you to pull a current ASN ranking — the top 200 Autonomous Systems by IPv4 address announcement volume — into a Google Sheet for a quarterly infrastructure risk review. They need ASN number, organization name, country of registration, and rank.
You've got the BigDataCloud API key. You've got a blank sheet. You've never called the ASN ranking endpoint before, and the documentation describes a JSON response with nested fields you'd need to flatten before anything lands usably in a spreadsheet.
The risk review presentation is Monday. It's Friday afternoon.
The bad version:
- Open BigDataCloud's API reference, find the ASN rank list endpoint, authenticate, run a test call.
- Realize the response is paginated and you need to handle multiple pages to get to 200 entries.
- Write a script, parse the nested fields, flatten the array, paste the output into the sheet — then discover the organization name field has encoding issues for certain international ASNs and spend an hour normalizing the text.
The one thing between you and leaving early on Friday is an API response you've never parsed before.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It connects to BigDataCloud on your behalf and pulls structured data directly into your sheet based on a plain-language request — no endpoint configuration or JSON parsing required.
Open SheetXAI from the Extensions menu and type:
Pull the top 200 ASNs ranked by IPv4 count from BigDataCloud and fill my sheet with ASN number, organization name, country, and rank
What You Get
- Column A: ASN number (e.g., "AS15169")
- Column B: organization name
- Column C: country of registration
- Column D: rank by IPv4 announcement volume
- 200 rows filled, sorted by rank ascending, starting at row 2 with a header row at row 1
What If the Data Is Not Quite Ready
You need more entries than 200 — the team expanded the scope to 500
Fetch the top 500 ASNs ranked by IPv4 count from BigDataCloud and write ASN number, organization name, country, and rank into columns A through D on a sheet called "ASN Research"
The sheet already has data and you want the new pull to append rather than overwrite
Pull the current top 200 ASN rankings from BigDataCloud — skip the first 5 rows (already filled with last quarter's data) and write the new results starting at row 6 with the same column format: ASN number, organization name, country, rank
You need the data filtered to a specific set of countries
Fetch the top 500 ASNs by IPv4 count from BigDataCloud, write all results to column A through D, then on a separate sheet called "Filtered" copy only rows where the country is US, CN, RU, or DE
Full threat landscape setup in one pass
Pull the top 200 ASNs ranked by IPv4 volume from BigDataCloud into columns A through D — then add a column E that flags any ASN whose organization name matches entries in my "Known Bad Actors" tab (column A on that tab), and sort flagged rows to the top
One prompt handles the data pull, the cross-tab lookup, the flag column, and the sort.
Try It
Get the 7-day free trial of SheetXAI and open a blank Google Sheet — paste the prompt above and have your ASN ranking ready for Monday's infrastructure review. See the IP threat scan spoke if you also need to run hazard reports against specific ASN-linked IP addresses.