👉 n8n No Limits Access :

https://www.hostg.xyz/SHHAd

Hébergement VPS n8n | Automatisation sécurisée et évolutive

coupon -15% : DRFIRAS15

👉 Formation n8n en Français

Formation n8n en Français : Automatisation & Agents IA

coupon -20% : LANCEMENT : HERE

Introduction

This course page lets you rebuild the workflow manually, node by node, live on camera. Everything is copy-paste ready: expressions, JSON bodies, prompts and code.

The workflow tracks where any website ranks on Google for a list of keywords, every day. It scrapes the real SERP through the Apify Google Search Scraper, flattens the results into clean rows, logs them into Google Sheets to build a ranking history, then asks OpenAI to write a short SEO report that lands in your inbox.

Key difference with the original template: the AI does NOT scrape and does NOT invent rankings. It only analyses real SERP data.

Flow diagram

Run daily at 8 AM (Schedule Trigger)
        ↓
Configuration (Set)
        ↓
Prepare keyword list (Set)
        ↓
Split keywords into items (Split Out)
        ↓
Scrape Google results with Apify (HTTP Request)
        ↓
Extract and rank SERP results (Code)
        ↓
Log rankings to Google Sheets (Google Sheets - append)
        ↓
Combine rankings for AI analysis (Aggregate)
        ↓
Generate AI SEO report (Basic LLM Chain)  ←— OpenAI Chat Model (sub-node)
        ↓
Email the SEO report (Gmail)

Prerequisites & credentials

Service	Credential type	Where to get the key
Apify	Header Auth (`httpHeaderAuth`)	apify.com → Settings → Integrations → Personal API token
OpenAI	OpenAI API (`openAiApi`)	platform.openai.com → API keys
Google Sheets	Google Sheets OAuth2	n8n → Credentials → Google Sheets OAuth2 → Sign in with Google
Gmail	Gmail OAuth2	n8n → Credentials → Gmail OAuth2 → Sign in with Google

Create the Apify credential

Create a free account on apify.com.
Go to Settings → API & Integrations → Personal API tokens and copy your token.
In n8n: Credentials → New → Header Auth, name it Apify API.