IP geolocation & HTTP port scanning with Google Sheets

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:

1. Fetches geolocation data using the ip-api.com service to get country, city, coordinates, ISP, and organization information 2. Updates the spreadsheet with the geolocation details 3. Scans common HTTP ports (80, 443, 8080, 8000, 3000) to check service availability 4. 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.