n8n Weekly SERP & AI Visibility Tracker to Google Sheets

Track Google rankings and AI visibility every week—automatically

This n8n workflow runs weekly to pull Google SERP positions and AI visibility signals (ChatGPT and Perplexity) for your domain and keyword list, then appends the results into a Google Sheets dashboard tab for ongoing SEO and AI tracking.

What this workflow does

• Weekly scheduled run: Executes every Sunday at 11pm using a schedule trigger.
• Launches an Apify SERP + AI Visibility Tracker run: Starts an Apify Actor to check Google SERP positions and AI mentions for your configured domain, brand name, keywords, and locale.
• Fetches results from Apify: Retrieves the completed dataset using the run’s default dataset ID.
• Formats metrics for your dashboard: For each keyword, it prepares fields including Google position, position change, featured snippet and AI Overview flags, per-engine mention/context (ChatGPT and Perplexity), and an AI visibility score.
• Updates Google Sheets: Appends one row per keyword into the “Weekly Visibility Tracker” tab.

Use cases

• Monitor whether SEO improvements move your Google positions and impact visibility in AI Overview and featured snippets.
• Track brand and keyword presence in ChatGPT and Perplexity over time using consistent weekly reporting.
• SaaS SEO teams and automation engineers maintain a single source of truth in Google Sheets for weekly SEO + AI reporting.

Technical details

• Nodes/stack: code, sticky note, HTTP Request, Google Sheets, schedule trigger
• Integrations: Apify (SERP + AI Visibility Tracker), Google Sheets (OAuth2)
• Required credentials: Apify API token, OpenAI (ChatGPT) API key, Perplexity API key

Tip: Create a Google Sheet tab named “Weekly Visibility Tracker” with columns matching the formatted fields (e.g., Date, Keyword, Google Position, Position Change, Has Featured Snippet, Has AI Overview, ChatGPT Mentioned/Context, Perplexity Mentioned/Context, Claude Mentioned, AI Visibility Score).