Score niche tool site ideas from keyword, SERP and market data

An n8n builder runs a pipeline that expands keywords, checks live search results and sale comps, then has OpenAI write briefs for 40+ ranked tool ideas in Notion for about $5 a run.

Done withn8ninNotionApifyOpenAI· Nov 11, 2026

What they did

Naved, posting on the n8n community forum, built a workflow to find small single-purpose web tools worth building, such as calculators and converters. Given a niche, it expands seed queries through the Twinword keyword API, filters to tool-shaped queries and merges aliases, then scores each on volume, CPC, build simplicity and cluster strength with per-category quotas. For the shortlist it pulls the live top ten results from Serper and penalises strong incumbents, checks Chrome Web Store competition through Apify, and pulls sale comps from a Flippa scraper. Only then does OpenAI, with a strict JSON schema, name the site and write a brief per tool. A validation step drops any tool whose keyword is not in the scored data, and results are written to Notion with dedup keys.

How it went

Each run takes about 20 minutes, costs about $5 and produces a ranked blueprint of more than 40 tools with real volumes, CPCs and evidence. Per-node retries with continue-on-error kept single dead sources from killing long runs. The keyword API's rate limit needed a 7 second batch interval; 5 seconds failed intermittently. He nearly shipped a scoring bug by misreading an ad-density field as SEO difficulty. A second workflow with the same shape scans launch sites for traction. He gives no figures on whether any tool was built from the output.

Worth knowing

The design keeps every number in deterministic code and uses the model only at the end for naming and briefs, plus a check that rejects briefs citing keywords not in the data. Field names from the keyword API are odd (one has a literal space), so validate them before scoring.

Try it

With n8n· 7 parts to fill in

Build me a workflow in [n8n or my automation tool] that researches [niche] for small single-purpose tool ideas. Expand my seed queries with [keyword API], respecting its rate limit. Filter out branded queries and merge aliases. Score each keyword on volume, CPC, build effort and cluster size, with a cap per category. For the top [number], check the live top ten results with [SERP API] and penalise strong incumbent domains. Only after all scoring is done, send the shortlist to [LLM] to write a brief per tool, and reject any brief whose keyword is not in the scored data. Write rows to [Notion database] with dedup keys so reruns are safe. Show me the first run's output before scheduling it.

Square brackets are the parts to fill in. The prompt is ours; the story is theirs.

Where they said it

Related