Enrich new IP addresses with location and port data

Adding an IP address to a spreadsheet automatically pulls its location and checks which web ports are open.

How the work actually flows

It branches. Every path runs; all paths must finish before it continues.

Pattern: Parallel Split (2) ยท Synchronisation (3)

flowchart TD trig[\"new IP address added"\]:::trigdata s0["start enrichment lookup"]:::task s1[("write results back to row")]:::store trig --> s0 gx{"+ look up location and ports"}:::gate s0 --> gx p00["look up country city provider"]:::task gx -->|"location lookup"| p00 p10["scan common web ports"]:::task gx -->|"port check"| p10 jn{"+ combine results"}:::gate p00 --> jn p10 --> jn jn --> s1 out[/"IP address enriched with details"/]:::out pay{{"always current network intelligence"}}:::pay s1 --> out out --> pay classDef task fill:#e7f6fe,stroke:#34b8f0,color:#2c2a29 classDef svc fill:#f6f8fa,stroke:#7c8795,color:#2c2a29 classDef mi fill:#e7f6fe,stroke:#0079a8,color:#2c2a29,stroke-width:2px classDef human fill:#fff,stroke:#0079a8,color:#0079a8 classDef store fill:#f6f8fa,stroke:#0079a8,color:#2c2a29 classDef trig fill:#00a4eb,stroke:#0079a8,color:#fff,font-weight:bold classDef trigtime fill:#00a4eb,stroke:#0079a8,color:#fff,font-weight:bold classDef trigdata fill:#8ad4f5,stroke:#0079a8,color:#06314c,font-weight:bold classDef gate fill:#fff,stroke:#e8a23d,color:#6b4708,font-weight:bold classDef out fill:#1f9d6b,stroke:#167a53,color:#fff,font-weight:bold classDef pay fill:#06314c,stroke:#021f33,color:#fff
Starts itA stepA record or sheetEvery pathWaits for allResultPayoff
Build size
Standard

A mid-size build with several tools working together.

Business functions
Spreadsheet & Database Ops
Connects
Google Sheets

The problem it solves

When you are tracking IP addresses for network monitoring or security review, looking up location details and checking open ports for each one by hand is slow and easy to forget. Your intelligence list quickly falls out of date.

Who it fits

IT and network teams who maintain an internal list of IP addresses to monitor.

How it works

  1. A new IP address is added to your spreadsheet
  2. The system looks up its country, city, and internet provider
  3. It checks common web ports to see which services respond
  4. The location and port results are written back to the same row
What you get

Network risks caught before they become incidents

Every new IP address you track automatically gets checked for location and open ports, right in your spreadsheet.

What you get

An enriched spreadsheet row showing each IP's location and which web ports are reachable.

What you need

A Google account with access to Google Sheets.

We can build this. But should you?

The hard question is not how to build it. It is whether this is the right thing to build first.

That is what a Fractional Chief AI Officer figures out with you, before anyone writes a line of code.

Let's Talk Strategy

Related automations

Turn RSS news into published Wordpress blog posts automatically

Reads RSS feeds, picks the best stories, writes full articles with AI, and publishes them to Wordpress.

Advanced

Score and route new leads automatically with AI and Slack alerts

Reads new leads from email or web forms, scores them with AI, updates your CRM, and alerts your team on Slack.

Advanced

Run A/B tested email campaigns tracked in Google Sheets

Sends A/B tested email campaigns from Gmail, tracks results in Google Sheets, and reports progress in Slack.

Advanced

Enrich your company list with AI-generated business details

Feeds your spreadsheet of companies through AI to fill in missing details like industry and description automatically.

Advanced
Back to the AI Playbook