The Scenario
Your network security engineer pulled 800 IP addresses from recent login attempt logs into a Google Sheet. They came from a week of failed authentication events — some may be routine credential stuffing noise, some may be from known malicious infrastructure. Before starting a manual review, you need to know which ones appear on known blocklists.
The engineer is in three other meetings today. You have the sheet and access to Neutrino. You've been asked to get the blocklist results into column B before the security review starts at 3 PM.
The bad version:
- Find a batch blocklist check tool, export the IP column to CSV, upload it
- Wait for results, discover the tool only processed 500 of the 800 rows before timing out
- Re-run the remaining 300, download both result files, merge them, align against the original sheet
It is 1:45 PM. You have until 3.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Google Sheet. Through its built-in Neutrino integration, it checks every IP address in column A against blocklists and writes the flag and category information directly into the columns you specify.
For each IP in column A, check it against Neutrino blocklists and write TRUE or FALSE in column B and the list categories it appears on in column C.
What You Get
- Column B: TRUE or FALSE for every IP — whether it appears on any Neutrino blocklist
- Column C: the specific list categories (malware, TOR, botnet, spam, etc.) for any flagged address
- All 800 rows processed in one pass — no timeout, no partial results, no re-combining
What If the Data Is Not Quite Ready
You want flagged rows highlighted visually for the security review
Check all 800 IPs in column A against Neutrino blocklists. Write TRUE or FALSE in column B and the blocklist type in column C. Highlight any row where column B is TRUE in red.
Some IPs appear more than once in the log and you want deduplication before checking
Remove duplicate IPs from column A first. Then check each unique IP against Neutrino blocklists, write the flag in column B and the category in column C. Add a third column D showing how many times each IP appeared in the original list.
You want to separate TOR exit nodes from other blocklist types
Check all IPs in column A against Neutrino blocklists. Write TRUE or FALSE in column B. In column C, write the specific categories. In column D, write TOR if the IP is specifically flagged as a TOR exit node, and write OTHER for all other blocklist types.
Full threat triage in one shot
Remove duplicate IPs from column A, check each unique one against Neutrino blocklists, write the blocklist flag in column B, the list categories in column C, and the original occurrence count in column D. Highlight all flagged rows red. Then add a summary at the top showing the total count of unique IPs, flagged IPs, and the breakdown by category type.
Try It
Get the 7-day free trial of SheetXAI and open your login attempt IP sheet, then ask SheetXAI to check column A against Neutrino blocklists before your 3 PM security review. See also the IP geolocation spoke if you need country and ISP context alongside the blocklist flags.