Find internal linking opportunities with SerpAPI and Google Sheets
Ready for 3.0Ready 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. It also calls serpapi.com over HTTP.
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Get URLs and keywords (Google Sheets): uses Google Sheets
- Loop Over Items (Loop Over Items (Split in Batches)): loops over the items in batches
- Get search results using SerpAPI (HTTP Request): calls serpapi.com
- Extract links from JSON (Edit Fields (Set)): sets 2 fields: URL, organic_results
- Add internal URL to Google Sheet (Google Sheets): update
Services it uses
HTTP calls to: serpapi.com
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 (5)
- Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - HTTP Request
n8n-nodes-base.httpRequest - Edit Fields (Set)
n8n-nodes-base.set - Google Sheets
n8n-nodes-base.googleSheets - Manual Trigger
n8n-nodes-base.manualTrigger
From the author
Overview Use this workflow to spot internal linking ideas on your site and improve your search performance. It takes your target URLs and keywords, finds related pages, and suggests where to add links. Strong internal linking helps search engines understand…