Workflow Demo

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.

Workflow Demo

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.

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

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

  1. Import the template and connect Apify, Sheets, OpenAI and Gmail.
  2. Choose one trade and city and list the searches customers actually use.
  3. Run it for your own or a friend's business first and check the results by hand.
  4. Edit the report prompt so it writes for an owner, not an SEO, and states the country and language used.
  5. 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.

Get a launch plan

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

Sources reopened Oct 31, 2026. Spot a mistake? Tell us and we'll correct it in public.

Keep reading

The Daily Paycheck: one remarkable AI business at a time, and exactly how you could build around it. Free; unsubscribe anytime.

Get new AI business discoveries by email.