Identify B2B Website Visitors for Free
93% of B2B buyers research you silently. Without you knowing.
They read your content, check your pricing, compare you with competitors. And then? They disappear. Without a trace. But there's a solution: identify website visitors with smart tracking tools powered by Google Sheets and enhanced with RIPE WHOIS, BGPView, and 6+ IP intelligence APIs.
What if you could see that ASML used your ROI calculator yesterday? Or that Philips came back three times this week for your enterprise features? You can, and I'll show you exactly how.
Step 1: Google Apps Script
Location: Extensions → Apps Script in Google Sheets
Latest Updated Version 25/9
Step 2: Custom HTML Tag for Tag Manager
Important: Replace YOUR_WEBHOOK_URL with your Apps URL
Latest Updated Version 25/9
Step 3: Configure Your Settings
Don’t know how it works? Send me a DM!
The Enhanced Detection System: What's New
This isn't just another IP lookup tool. The enhanced version uses 7 different data sources for maximum accuracy:
RIPE WHOIS - Excellent for European B2B companies
BGPView.io - Advanced ASN/ISP detection
IP-API.com - Primary free service with reverse DNS
IPWhois.io - Secondary validation
IP2Location.io - Enhanced company detection
IPAPI.co - Additional geographic data
IPInfo.io - Premium accuracy (optional, with token)
The system now filters out 150+ ISPs and hosting providers, including all major Dutch providers like Youfone, Simyo, Ben, HollandsNieuwe, Eurofiber, and dozens more. No more false positives from residential connections.
The Problem with Anonymous Website Traffic
Look at your own numbers. How many percent of your visitors convert? 2%? Maybe 3% on a good day?
The other 97% isn't uninterested. They're just not ready for contact yet. B2B buyers average 27 touchpoints before reaching out. Without identifying website visitors, you're literally missing thousands of warm leads per year.
Here's the interesting part:
Companies have fixed IP addresses. Just like your home address is unique, every corporate network has a digital fingerprint. By matching these with company databases - now enhanced with RIPE, BGPView, and multiple IP intelligence services - you transform anonymous visitors into identifiable companies. From "Visitor from Amsterdam" to "Heineken - viewed pricing page 3 times, spent 12 minutes on ROI calculator".
What You Get with This Enhanced B2B Tracker
Real-time company identification (40-50% of B2B traffic with enhanced detection)
Automatic lead scoring (A-F grades based on behavior)
Hot page alerts (notification when someone views pricing/demo)
Email & Slack notifications for hot leads
UTM parameter tracking for campaign attribution
Conversion event tracking (form submits, demo requests)
Privacy-first approach with client-side IP hashing option
Geographic filtering for target markets
The 15-Minute Installation
Step 1: Google Sheets Configuration
Open a new Google Sheet
Go to Extensions → Apps Script
Delete any existing code
Paste the complete enhanced tracking script
Click Run → initializeSpreadsheet
Grant necessary permissions
Click Deploy → New Deployment
Choose type: Web app
Set execute as: Me
Set access: Anyone
Copy the deployment URL (your webhook)
The system automatically creates 7 tabs:
Dashboard - Real-time metrics and KPIs
Companies - Your identified company database
Live Visitors - Real-time monitoring
Lead Scores - Automatic qualification with behavior signals
IP Database - Cached lookups for performance
Settings - Configuration options
Conversions - Tracked form submissions and events
Step 2: Google Tag Manager Setup
Create a new Custom HTML tag
Paste the optimized tracking code with your webhook URL
Set trigger to All Pages
Configure consent mode for GDPR compliance:
Go to Advanced Settings → Consent Settings
Require additional consent: analytics_storage
Test in Preview mode
Publish your container
Step 3: Settings Configuration
Navigate to the Settings tab in your spreadsheet and configure these values:
IPInfo Token: Get a free token from ipinfo.io/signup. This dramatically improves company detection accuracy from 30% to 45%.
Geographic Focus: Enter "Netherlands, Belgium, Germany" or your target countries. Companies from these countries get higher lead scores.
High-Value Pages: Enter "/pricing, /demo, /contact, /roi-calculator" or your important pages that indicate buying intent.
Lead Score Threshold: Set to "40". This is the minimum score to consider a lead qualified.
Hot Lead Score: Set to "70". This triggers email and Slack notifications.
Excluded IPs: Enter your office IP address to prevent tracking your own visits. Use comma separation for multiple IPs.
Email Recipients: Enter "sales@company.com" or comma-separated emails for hot lead alerts.
Slack Webhook: Create a webhook at api.slack.com/apps for real-time Slack notifications.
Auto Enrich: Set to "FALSE" to stay within free limits.
Track ISPs: Set to "FALSE" unless you specifically sell to internet service providers.
Debug Mode: Set to "FALSE" for normal operation, "TRUE" only for troubleshooting.
Allowed Origins: Enter "yourdomain.com" or use "*" for all domains. This is a security setting.
Data Retention Days: Set to "90" for automatic cleanup of old data.
Track UTM Parameters: Set to "TRUE" to capture campaign data.
Hash IPs: Set to "TRUE" for privacy - this hashes IPs client-side.
Skip Slow Connections: Set to "TRUE" for performance - skips tracking on 2G/3G networks.
Getting an IPInfo Token (Free 50k/month)
IPInfo provides superior company detection, especially for European B2B:
Visit ipinfo.io/signup
Create a free account (no credit card required)
Copy your access token from the dashboard
Paste into Settings → IPInfo Token field
Save the sheet
With IPInfo, detection accuracy improves from approximately 30% to 45% for B2B traffic.
Excluding Incorrectly Identified Companies
Sometimes residential ISPs or VPNs get misidentified as companies. Here's how to clean up:
Method 1: Exclude Specific IPs
Find the incorrectly identified company in the Companies tab
Look up their IP in the Live Visitors tab
Add the IP to Settings → Excluded IPs (comma-separated)
Method 2: Manual Cleanup
In the Companies tab, simply delete rows with incorrect companies
They won't be re-added if the same IP visits again (cached as ISP)
Method 3: Improve ISP Detection
The enhanced script already filters 150+ ISPs including:
All major Dutch providers (KPN, Ziggo, T-Mobile, Vodafone, etc.)
Hosting providers (AWS, Google Cloud, Azure, etc.)
VPN services (NordVPN, ExpressVPN, etc.)
Educational networks (universities, schools)
Understanding the Lead Scoring System
The system calculates four factors for each company:
Behavior Score (0-25 points)
Very long visit (2+ minutes): 18-25 points
Long visit (1+ minute): 12-18 points
Medium visit (30+ seconds): 7-12 points
Active session tracking: 2-5 points
Intent Score (0-30 points)
Contact/demo page visit: 22-30 points
Pricing page visit: 15-23 points
High-value page visit: 8-15 points
Paid traffic source: +5-8 points
Organic search traffic: +3-7 points
Campaign traffic: +2 points
Fit Score (0-25 points)
Identified company: 10-18 points
Target geography match: 4-10 points
Company size/type match: varies
Engagement Score (0-25 points)
5+ visits: 18-25 points (high engagement)
3-4 visits: 12-18 points (returning visitor)
2 visits: 6-11 points (showed interest)
First visit: 2-5 points (new prospect)
Total Score Grade
A (80-100): Hot lead - immediate follow-up
B (65-79): Warm lead - priority outreach
C (50-64): Interested - nurture required
D (35-49): Early stage - monitor activity
F (0-34): Low intent - general marketing
Slack Integration Setup
Get real-time notifications when hot leads visit:
Go to api.slack.com/apps
Click Create New App → From scratch
Name it "B2B Lead Tracker"
Select your workspace
Go to Incoming Webhooks → Enable
Click Add New Webhook to Workspace
Choose your sales channel
Copy the webhook URL
Paste into Settings → Slack Webhook
Killer Use Cases for B2B Visitor Tracking
Personalized Outreach
"Hi Sandra, I noticed your team at Philips spent time on our API documentation and ROI calculator yesterday. Enterprise clients often have questions about custom integrations. Would a brief overview of our implementation process be helpful?"
Response rates? 5x higher than cold email.
Content ROI Measurement
That €2000 whitepaper? It attracted 12 enterprise companies. Three are now customers. ROI: 847%. But without tracking, you'd never know.
Sales Prioritization
Stop random calling. Focus on companies already showing interest. A warm conversation converts 10x better than cold calling.
Account-Based Marketing
See which target accounts are engaging with your content. Trigger personalized campaigns based on their behavior. Adjust messaging based on pages viewed.
Privacy and GDPR Compliance
Is this legal?
Yes, for B2B tracking. You're identifying companies, not individuals. The system uses only IP-matching with public company databases. No cookies, no personal data.
Best Practices
Update your privacy policy to mention B2B visitor identification
Enable IP hashing in Settings (already TRUE by default)
Offer opt-out via IP exclusion
Only use data for legitimate business interest
Don't attempt to identify individuals
Transparency Statement Example
"We use B2B visitor identification technology to understand which companies visit our website. This helps us provide better service and relevant content. We do not track individual visitors or personal data. Companies can opt-out by contacting privacy@yourcompany.com."
Limitations of Free B2B Tracking
Let's be honest about what this free tool can and cannot do:
Identifies 40-50% of B2B visitors (with all enhancements)
Remote workers and VPNs remain anonymous
Small businesses with consumer ISPs won't show
You get company names, not contact persons
Google Sheets limits: ~1000 visits/day maximum
API limits: Some services have monthly quotas
For higher volumes or contact-level data, consider paid alternatives like Clearbit, Leadinfo, or Albacross.
Troubleshooting Common Issues
No data appearing?
Check webhook URL is correct in GTM tag
Verify Apps Script deployment is set to "Anyone"
Test with Debug Mode = TRUE
Check browser console for errors
Too many ISPs showing?
Verify "Track ISPs" = FALSE
Add common ISPs to excluded IPs
Check if IPInfo token is active
Slow tracking performance?
Enable "Skip Slow Connections" = TRUE
Reduce "Data Retention Days" to 30
Clean up old data manually
Getting timeout errors?
Normal for first visit (cold start)
Subsequent visits should be faster
Consider increasing timeout values in GTM tag
Start Today with Enhanced B2B Tracking
Within 15 minutes, you'll see the first companies streaming in. Tomorrow you'll have identified your first hot leads. Next week you'll wonder how you ever lived without it.
The bottleneck in B2B isn't generating traffic. It's knowing WHO that traffic is. This enhanced visitor tracking solves that problem with unprecedented accuracy.
Stop guessing who visits your site. Start identifying them with enterprise-grade detection powered by RIPE WHOIS, BGPView, and 5+ IP intelligence services - all running free in Google Sheets.
The tools and instructions are ready. You just need to begin.
PS: Those 93% silent researchers? They're on your site right now. Time to make them visible.
-
Yes, identifying companies via IP addresses is legal under GDPR because you're collecting business information, not personal data. You identify the company, not the individual employee. Do ensure transparency in your privacy policy.
-
With the enhanced system using RIPE, BGPView, and multiple APIs, you can identify 40-50% of B2B visitors. This is significantly higher than basic IP lookup tools that achieve 20-30%.
-
Google Analytics shows anonymous traffic metrics. This tool identifies actual company names, scores their interest level, and alerts you to hot leads. GA4 tells you "10 visitors from Amsterdam." This tells you "Heineken - 3 visits, viewed pricing, spent 8 minutes."
-
No, you only see the company name. For individual identification, you'd need form fills or integration with tools like LinkedIn Sales Navigator. This respects privacy while still providing valuable B2B intelligence.
-
~1000 tracked visits per day (Google Sheets limit)
50k IP lookups/month with free IPInfo token
30k lookups/month for some free APIs
No individual contact information
Manual lead enrichment required
-
Accuracy depends on the visitor type:
Large enterprises: 85-95% accurate
SMBs with business internet: 60-75% accurate
Remote workers/home offices: Not detected
Mobile/VPN users: Not detected
The enhanced detection with RIPE and BGPView significantly improves European B2B identification.