# Find out which companies visited your website yesterday

> Turn yesterday's anonymous website traffic into a ranked list of real companies, checked against your CRM and posted to Slack every weekday morning.

- Workflow type: agent
- Services: IPinfo, Google Sheets, HubSpot, Slack
- Categories: Sales, Marketing
- Published: 2026-08-04

## What it does

- Reads yesterday's visitor log every weekday morning and looks up every address in one batch rather than one at a time
- Filters out home broadband, mobile networks, VPNs, bots and cloud hosting so only genuine organisations remain
- Checks each surviving company against your CRM so you can tell existing customers and open deals apart from brand new accounts
- Posts a single Slack digest ranked by how much of your site each company read, and stays quiet on days when nothing identifiable turns up

## What you'll need

- A Google Sheet that your website appends visitor addresses and page paths to
- An IPinfo account (basic network owner data works on the free tier; the richer company and hosted domain details need a paid plan)
- A HubSpot login with access to your company records
- A Slack workspace and a channel for the digest

## Prompt

Every weekday at 8am, tell me which real companies visited our website yesterday.

Start in Google Sheets. Use Get Values to read our visitor log, the sheet our site appends a row to for every pageview with the visitor IP address, the page path and a timestamp. Keep only yesterday's rows, then build the distinct list of IP addresses along with the pages each one viewed and how many pageviews it accounted for.

Resolve that entire list in a single IPinfo Batch IP Lookup rather than looking addresses up one at a time. The batch operation accepts up to 1000 entries in one request. Each address in the array counts as one request against the IPinfo quota, but the batch call itself is free, so one call per day is the right shape even for a busy log.

Now do the filtering, which is the part that needs judgement. Discard addresses that resolve to consumer ISPs and mobile carriers, to VPNs, proxies and Tor exit nodes, to known bots and crawlers, and to hosting and cloud providers. Keep the ones whose network owner looks like a genuine organisation that came to look at us. Note that IPinfo returns the owner as a single string combining the ASN and the organisation name, for example "AS15169 Google LLC", so read it carefully: a large technology company's name sitting on a consumer or cloud range is usually noise, while a mid-size manufacturer, agency or bank on its own corporate ASN is a real signal.

When an owner name is ambiguous and you cannot tell whether it is a real company or a reseller, use Get Hosted Domains for an IP to see which domains sit behind that address and confirm the company behind the range. Treat this as an optional confirmation step. The data is plan gated and paginated, so if it is unavailable, fall back to the network owner name rather than failing the run.

Cross-reference every surviving company against our CRM using HubSpot Search Companies, matching on company name and on domain wherever you have one. Label each company as an existing customer, an open opportunity, or net new, so I can tell them apart at a glance.

Post one digest to Slack with Send a Message, ranked by how many pages each organisation viewed, highest first. For each company show the company name, the country, the pages they looked at and their CRM status. Keep it to a single message rather than one message per company. If nothing identifiable turns up after filtering, skip the post entirely and do not send an empty digest.

## How to customize

- Change the timing or the destination, such as running Monday only or sending the digest as a direct message instead of to a channel
- Loosen or tighten the filtering, for example keeping agency and cloud traffic instead of discarding it
- Cap how many rows are read per day if your site gets heavy traffic, since every address looked up counts against your IPinfo quota
- Rank by intent instead of volume, so companies that hit your pricing or demo pages rise to the top

## FAQ

### Can this tell me which individual person visited my site?

No. It identifies the organisation that owns or leases the network address, not a named person. Most visitors browsing from home broadband or a phone cannot be identified at all, and that is expected.

### What share of my visitors will actually be identified?

Realistically a small slice. Home internet, mobile networks and VPNs make up the bulk of consumer traffic and all get discarded. The value is in the handful of real companies that do turn up, not in the overall match rate.

### Do I need a paid IPinfo plan for this to work?

Basic network owner information is available on the free tier, which is enough to spot many organisations. The richer company and hosted domain details are paid features, so the workflow treats the hosted domain check as an optional confirmation step rather than a requirement.

### What happens on a quiet day with no real companies?

Nothing gets posted. If no identifiable organisation survives the filtering the digest is skipped entirely, so your channel does not fill up with empty reports.

### Is looking up visitor addresses like this allowed?

Resolving an address to the company that owns the network is a long standing business practice and is exactly what commercial visitor identification tools do. It surfaces organisations rather than individuals. It is still worth checking your own privacy notice and logging practices with whoever handles privacy at your company.

Use this prompt in General Input: https://www.generalinput.com/prompts/find-out-which-companies-visited-your-website-yesterday