Monitor Google Search rankings with SerpApi and Google Sheets
UnknownUnknown. This template uses community nodes we can't verify statically. Uses community nodes that can't be verified statically (unverified community packages are off by default in 3.0). Static check, last run 2026-10-19.
What this workflow does
This workflow has 10 nodes and runs on a schedule (every day at 10:00). Along the way it connects Google Sheets and Serpapi (community).
How it runs
Trigger: On a schedule (every day at 10:00).
- Get Keywords and Domains to Match (Google Sheets): uses Google Sheets
- Loop Over Keywords (Loop Over Items (Split in Batches)): loops over the items in batches
- Set Page Limit & Match Type (Code): runs custom JavaScript code
- Search Google (Serp Api): uses Serp Api
- Parse Rank for Target Domain or Page (Code): runs custom JavaScript code
- If: checks a condition and branches into true / false
- Update Rank Log (Google Sheets): append
- Update Latest Run (Google Sheets): update
- Wait: waits 4 seconds
Services it uses
Before you upgrade to n8n 3.0
We can't fully verify this one: it relies on 1 community package, and n8n 3.0 turns unverified community packages off by default (N8N_UNVERIFIED_PACKAGES_ENABLED=false).
- Check that n8n-nodes-serpapi is verified or supports 3.0 (used in Search Google).
Nodes used (7)
- Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Google Sheets
n8n-nodes-base.googleSheets - Serp Api
n8n-nodes-serpapi.serpApi - If
n8n-nodes-base.if - Code
n8n-nodes-base.code - Wait
n8n-nodes-base.wait - Schedule Trigger
n8n-nodes-base.scheduleTrigger
From the author
Google Keyword SEO Monitoring What this is about This workflow enables SEO monitoring by checking Google rank positions for a list of keywords and domains. It uses SerpApi's Google Search API, but can be customized to use any of SerpApi's APIs. How it works…