Turn Web Traffic into Sales Signals - Without Leaving Google Sheets

You’ve got a list of prospects… but are they actually active?
Is their site getting real traffic - or is it just a static brochure?
Should you reach out - or move on?

With Similarweb Insight inside Derrick App, you instantly detect signs of life (or weakness) from any website - directly in your Google Sheet.
No extension. No code. No Similarweb API key required.

Feature used in this playbook

• Similarweb Insight - Enriches each domain with traffic metrics, rankings, acquisition channels & more
• Sheets Native - Automatically adds data next to your URLs inside Google Sheets

→ Try Derrick for free →

What Derrick auto-generates

Derrick automatically enriches each row with the following columns:

• siteName - domain name
• siteTitle - Similarweb page title
• siteDescription - site’s meta description
• globalRank, countryRank, categoryRank - global, country, and industry rankings
• category - industry classification (Similarweb)
• monthlyVisits - estimated total traffic
• bounceRate - bounce rate
• pagesPerVisit - average pages per visit
• timeOnSite - average visit duration
• directTraffic, searchTraffic, socialTraffic, referralTraffic - traffic source breakdown
• topCountries - main countries by traffic share
• topKeywords - top organic & paid search keywords
• similarweb_status - shows if enrichment succeeded (useful for filtering errors)

Use Case #1: Prioritize high-traffic, high-engagement sites

Easily find top leads by filtering:

• monthlyVisits > 10,000
• bounceRate < 40%
• pagesPerVisit > 3

This gives you a shortlist of companies with an active, engaging website - likely in growth mode.

Use Case #2: Spot struggling websites

Running a Growth or SEO agency?
Use traffic trends or spot high traffic with low timeOnSite to find poorly optimized but high-potential websites.

Prospecting prompt:

“I saw your site gets an estimated 50k monthly visits - but average session time is quite low. We help B2B companies turn that traffic into revenue through better content & structure. Want to chat?”

Tips to get the most from Similarweb Insight

Filter by category to create industry-specific campaigns
Combine with LinkedIn enrichment to add context to the persona
Use topKeywords to match your cold emails to their audience language
Sort by countryRank to find local leaders
Create alerts when traffic drops - and offer a free audit

In Summary

No code
Fully in Google Sheets
Works out of the box, right now

With Similarweb Insight, you go from guessing to data-driven prospecting - in seconds.

Try Derrick App for free today →