n8n's featured template checks your Google rankings every morning and writes the report itself. The data costs a few dollars a month, and local businesses could pay for a 'where you rank in your town' report
A free n8n template tracks where you rank on Google every morning and emails an AI-written report on competitors and what to do next. Aim it at one trade in one town and it becomes a cheap monthly service owners actually read.
Published Oct 31, 2026
The Wow
What someone built
A free n8n workflow template (by Dr. Firas), featured by n8n on Oct 30, 2026: a daily Apify Google search per keyword, every position logged to Google Sheets, and an OpenAI-written HTML report on positions, top competitors and prioritized opportunities, emailed through Gmail.
- Original source
- n8n template: Track Google keyword rankings with Apify, OpenAI, Google Sheets and Gmail
- License
- n8n template library; free to use in n8n. Link to the template rather than copying its JSON
- What you need
- An n8n instance (self-hosted or n8n Cloud)
- An Apify account and API token
- A Google account for Sheets and Gmail
- An OpenAI API key
- Install
- Open the template page and choose "Use for free" to import it into n8n. Add an Apify API token, a Google Sheets connection (sheet columns: checked_at, keyword, rank, title, url, domain, description, is_target_domain), an OpenAI key and a Gmail connection, then set keywords, domain, country, language and recipient in the Configuration step.
- A business you could build on it
- Monthly 'where you rank in your town' reports for one local trade
Why it's remarkable
It's a recurring deliverable that runs itself: the sheet builds a ranking history on its own, the report writes itself, and Apify lists the search data at $1.80 per 1,000 result pages, about a dollar a month for 20 daily keywords.
The Opportunity
The business it reveals
Pick one trade in one city, track the searches that bring those businesses jobs, and sell owners a plain-English monthly report on where they rank and who beats them. Every report also tells you who to pitch next.
Who would pay
Plumbers, HVAC and roofing companies, dental and law offices, med spas, and the freelancers and small agencies who look after their marketing.
The Flip
2 ways you could turn this into a business
Monthly 'where you rank in your town' reports for one local trade
- Who pays
- Plumbers, HVAC and roofing companies, dental and law offices, med spas
- How it would earn
- A small monthly fee per business for tracking plus a plain-English summary (our hypothesis; price untested)
- Why it might work
- Owners rarely see their rankings, the report is easy to read, and the data cost per client is a few dollars a month.
- What already exists
- Free Google Search Console, the owner searching by hand, an SEO agency's paid plan, or self-serve rank trackers.
White-label rank reports for freelancers and small agencies
- Who pays
- Freelance web designers and small marketing agencies with local clients
- How it would earn
- A per-client monthly fee for running and branding the reports they resell (our hypothesis)
- Why it might work
- Agencies need a recurring, visible deliverable for care plans and don't want to build the workflow themselves.
- What already exists
- Agencies importing the free template themselves, or paying for a rank-tracking SaaS.
Why we'd try "Monthly 'where you rank in your town' reports for one local trade" first: The data costs almost nothing, the report sells itself when an owner sees the competitor above them, and one trade in one city gives you a ready list of the next prospects.
Build It
How you could build it
A rank-report service for one local trade: daily tracking of 10–30 searches per client, a running sheet, and a reviewed monthly summary.
First step: Import the template, pick one trade in your city, and track the five searches that bring that trade jobs for two weeks. Then show one owner you know where they rank and who beats them.
Agents and tools
- n8n with the featured rank-tracker template
- Apify Google Search Scraper
- Google Sheets
- OpenAI or another model for the report
- Gmail
Setup
- Import the template and connect Apify, Sheets, OpenAI and Gmail.
- Choose one trade and city and list the searches customers actually use.
- Run it for your own or a friend's business first and check the results by hand.
- Edit the report prompt so it writes for an owner, not an SEO, and states the country and language used.
- Offer two weeks of free tracking to three owners and ask what they'd pay to keep it.
What the agent does
- Checks rankings every morning
- Logs positions and competitors to the sheet
- Drafts the report on positions, competitors and next steps
What you do
- Picks the searches for each client
- Reviews each report before it's sent
- Explains results and sells the next step
Your first customer: A local business owner you already know who gets jobs from Google, offered two weeks of free tracking on their top five searches.
Test demand first: Track one trade in one city for five businesses over two weeks. Success: three owners read the report and one agrees to pay a monthly fee to keep it.
Your starter instructions
Paste this into the AI agent you use (ChatGPT, Claude, Gemini, Grok Bot or another) as your first message. Copying it starts work in your own agent; it doesn't create or deploy a business by itself.
Running it
What stays human: Choosing the searches that actually bring each client jobs, checking the AI-written report before it goes out, explaining what the numbers mean, and selling the next step (content, reviews, site fixes) or handing it to someone who does it.
- Startup cost (estimate)
- Under $25 to start (estimate) (Estimate: the template is free; Apify's free plan includes $5 of monthly credit and lists the Google Search Scraper at $1.80 per 1,000 result pages; self-hosted n8n is free, n8n Cloud is a paid plan; OpenAI usage for a short daily report is a few cents)
- Running cost
- Roughly $1–$5 per client a month in data and model costs, plus your time (estimate) (Estimate: 20 keywords checked daily is about 600 result pages a month, about $1.08 at Apify's listed $1.80 per 1,000; model costs for one short report a day are small. Your review time per client is unmeasured)
- How much the agent runs
- Agents run one core part; people run the rest.
Pricing your own version? Use the free startup-cost worksheet.
The evidence
What the source shows: The n8n template page (steps and setup), n8n's Oct 30, 2026 post featuring it, and Apify's listed price, all loaded on Oct 31, 2026. No usage or earnings figures are published.
What's ours: The local report service, its buyers, its pricing and the flips are our application.
Worth planning around
- Local results vary by the searcher's exact location and the map pack, which a country-level search won't fully show.
- AI-written reports need a human check before they go to a client.
- Owners may expect you to improve rankings, not only report them.
Sources
- n8n template: Track Google keyword rankings with Apify, OpenAI, Google Sheets and Gmail (template page with steps and setup; checked Oct 31, 2026)
- n8n on X featuring the template, Oct 30, 2026
- Apify Google Search Scraper: $1.80 per 1,000 result pages, $5 free monthly credit (list price; checked Oct 31, 2026)
Sources reopened Oct 31, 2026. Spot a mistake? Tell us and we'll correct it in public.
Keep reading
- AI services a local marketing agency can sell (guide)
- AI automation specialist salary: what employers post (guide)
- How people make money with n8n (guide)
- He still can't write code. His five-person ad agency now runs on about 270 tools he built with Claude. Every owner-run firm needs its first five
- A marketer who doesn't code built an elk-call coaching app with Claude Code and says it hit a $650K run rate in 110 days. Every skill learned by sound is the same opening
- A free n8n workflow flags fake supplier invoices before anyone pays them — and Germany's e-invoice switch makes it a service bookkeepers can sell
- Marc Lou's agent chased a broken-shoe refund through three support desks and got his 850 AED back. Small stores now need a claims desk that can answer agents
- Every discovery and launch plan