Scrape Google search rankings into Google Sheets with ScrapeUnblocker
UnknownWhat this workflow does
This workflow has 8 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Google Sheets and Scrapeunblocker (community).
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Get Keywords (Google Sheets): uses Google Sheets
- Process Keywords (Loop Over Items (Split in Batches)): loops over the items in batches
- Build Google Search URL (Code): runs custom JavaScript code
- Fetch Google Search Results (Scrape Unblocker): uses Scrape Unblocker
- Extract Search Results (Code): runs custom JavaScript code
- Format SERP Data (Code): runs custom JavaScript code
- Save Search Results (Google Sheets): update
Services it uses
Scraping pages by hand? Firecrawl is a simpler option (10% off for new users).
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-scrapeunblocker is verified or supports 3.0 (used in Fetch Google Search Results).
Nodes used (5)
- Google Sheets
n8n-nodes-base.googleSheets - Manual Trigger
n8n-nodes-base.manualTrigger - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Code
n8n-nodes-base.code - Scrape Unblocker
n8n-nodes-scrapeunblocker.scrapeUnblocker
From the author
Quick Overview This workflow manually runs a Google SERP scraper that reads keywords from Google Sheets, fetches Google search result pages via ScrapeUnblocker, extracts the top organic results, and writes the parsed ranks, titles, and snippets back to Google…