SERP competitor research with Scrape.do API & Google Sheets

Ready for 3.0

by Onur ✓ · 358 views · created 2025-09-25 · Market Research

Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.

What this workflow does

This workflow has 6 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Google Sheets.

How it runs

Trigger: Manually, when you click “Execute workflow”.

Get Keywords from Sheet (Google Sheets): uses Google Sheets
URL Encode Keywords (Code): runs custom JavaScript code
Fetch Google Search Results (HTTP Request): calls an HTTP API
Extract Competitor Data from HTML (Code): runs custom JavaScript code
Append Results to Sheet (Google Sheets): append

Services it uses

Google Sheets

Before you upgrade to n8n 3.0

Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.

Nodes used (4)

Manual Triggern8n-nodes-base.manualTrigger
Google Sheetsn8n-nodes-base.googleSheets
Coden8n-nodes-base.code
HTTP Requestn8n-nodes-base.httpRequest

From the author

🔍 Extract Competitor SERP Rankings from Google Search to Sheets with 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…
Excerpt from Onur's description on n8n.io.

View the original on n8n.io → Check your own copy

SERP competitor research with Scrape.do API & Google Sheets

What this workflow does

How it runs

Services it uses

Before you upgrade to n8n 3.0

Nodes used (4)

From the author

Get the weekly “what broke” email