IP Geolocation & HTTP Port Scanning with Google Sheets

Description

Automate IP geolocation and HTTP port scanning with Google Sheets trigger

This n8n template automatically enriches IP addresses with geolocation data and performs HTTP port scanning when new IPs are added to a Google Sheets document. Perfect for network monitoring, security research, or maintaining an IP intelligence database.

Who's it for

Network administrators, security researchers, and IT professionals who need to:
Track IP geolocation information automatically
Monitor HTTP service availability across multiple ports
Maintain centralized IP intelligence in spreadsheets
Automate repetitive network reconnaissance tasks

How it works

The workflow triggers whenever a new row containing an IP address is added to your Google Sheet. It then:

Fetches geolocation data using the ip-api.com service to get country, city, coordinates, ISP, and organization information
Updates the spreadsheet with the geolocation details
Scans common HTTP ports (80, 443, 8080, 8000, 3000) to check service availability
Records port status back to the same spreadsheet row, showing which services are accessible

The workflow handles both successful connections and various error conditions, providing a comprehensive view of each IP's network profile.

Requirements

Google Sheets API access** - for reading triggers and updating data
Google Sheets document** with at least an "IP" column header

How to set up

Create a Google Sheet with columns: IP, Country, City, Lat, Lon, ISP, Org, Port_80, Port_443, Port_8000, Port_8080, Port_3000
Configure Google Sheets credentials in both the trigger and update nodes
Update the document ID in the Google Sheets Trigger and both Update nodes to point to your spreadsheet
Test the workflow by adding an IP address to your sheet and verifying the automation runs

How to customize the workflow

Modify port list**: Edit the "Edit Fields" node to scan different ports by changing the ports array
Add more geolocation fields**: The ip-api.com response includes additional fields like timezone, zip code, and AS number
Change trigger frequency**: Adjust the polling interval in the Google Sheets Trigger for faster or slower monitoring
Add notifications**: Insert Slack, email, or webhook nodes to alert when specific conditions are detected
Filter results**: Add IF nodes to process only certain IP ranges or geolocation criteria