The Problem
B2B teams manually browse online directories (Clutch, G2, Capterra) to find prospects. Copy-pasting company names into spreadsheets takes hours and misses new listings. There is no automated way to search directories and pipe results into a sheet.
The Scavio Solution
Use n8n with Scavio to search for directory listings programmatically, extract company names, descriptions, and URLs, and append them to a Google Sheet on a schedule. Each search query costs $0.005.
Before
Intern spends 4 hours weekly browsing directories and copy-pasting company data into a spreadsheet. Misses new listings between manual checks.
After
n8n workflow runs daily, searches directories via Scavio, and appends new listings to Google Sheets automatically. Zero manual effort.
Who It Is For
B2B sales teams and agencies who prospect from online directories and want to automate the data collection into spreadsheets.
Key Benefits
- Automate directory monitoring for $0.50/week
- New listings appear in your sheet within 24 hours
- Filter by industry, location, or company size signals
- n8n handles scheduling, deduplication, and sheet updates
- Replaces 4+ hours of weekly manual research
Python Example
import requests, os
API_KEY = os.environ["SCAVIO_API_KEY"]
def search_directory(directory: str, category: str) -> list:
"""Search a directory site for business listings."""
query = f"site:{directory} {category}"
resp = requests.post(
"https://api.scavio.dev/api/v1/search",
headers={"x-api-key": API_KEY, "Content-Type": "application/json"},
json={"query": query, "country_code": "us"},
timeout=15,
)
data = resp.json()
return [
{"title": r.get("title", ""), "url": r.get("link", ""), "snippet": r.get("snippet", "")}
for r in data.get("organic_results", [])
]
# Search multiple directories
directories = ["clutch.co", "g2.com", "capterra.com"]
for d in directories:
results = search_directory(d, "marketing automation agencies")
print(f"{d}: {len(results)} listings found")JavaScript Example
const H = {'x-api-key': process.env.SCAVIO_API_KEY, 'Content-Type': 'application/json'};
async function searchDirectory(site, category) {
const r = await fetch('https://api.scavio.dev/api/v1/search', {method:'POST', headers:H, body:JSON.stringify({query:'site:'+site+' '+category, country_code:'us'})});
const d = await r.json();
return (d.organic_results||[]).map(r=>({title:r.title, url:r.link, snippet:r.snippet}));
}
for (const site of ['clutch.co','g2.com','capterra.com']) {
const results = await searchDirectory(site, 'marketing automation agencies');
console.log(site + ': ' + results.length + ' listings');
}Platforms Used
Web search with knowledge graph, PAA, and AI overviews