SERP competitor research with Scrape.do API & Google Sheets

🔍 Extract Competitor SERP Rankings from Google Search to Sheets with [Scrape.do](https://scrape.do/) This template requires a self-hosted n8n instance to run.

A complete n8n automation that extracts competitor data from Google search results for specific keywords and target countries using [Scrape.do](https://scrape.do?fpr=99aed) SERP API, and saves structured results into Google Sheets for SEO, competitive analysis, and market research.

---

📋 Overview This workflow provides a lightweight competitor analysis solution that identifies ranking websites for chosen keywords across different countries. Ideal for SEO specialists, content strategists, and digital marketers who need structured SERP insights without manual effort.

Who is this for? - SEO professionals tracking keyword competitors - Digital marketers conducting market analysis - Content strategists planning based on SERP insights - Business analysts researching competitor positioning - Agencies automating SEO reporting

What problem does this workflow solve? - Eliminates manual SERP scraping - Processes multiple keywords across countries - Extracts structured data (position, title, URL, description) - Automates saving results into Google Sheets - Ensures repeatable & consistent methodology

---

⚙️ What this workflow does 1. Manual Trigger → Starts the workflow manually 2. Get Keywords from Sheet → Reads keywords + target countries from a Google Sheet 3. URL Encode Keywords → Converts keywords into URL-safe format 4. Process Keywords in Batches → Handles multiple keywords sequentially to avoid rate limits 5. Fetch Google Search Results → Calls [Scrape.do](https://scrape.do?fpr=99aed) SERP API to retrieve raw HTML of Google SERPs 6. Extract Competitor Data from HTML → Parses HTML into structured competitor data (top 10 results) 7. Append Results to Sheet → Writes structured SERP results into a Google Sheet