Find internal linking opportunities with SerpAPI and Google Sheets

Description

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 your site.

How it works
You provide a list of target URLs and the keywords you want to rank for
The workflow uses the SERP API to search your site for related pages, skipping the target URL
It filters the results and pulls relevant URLs
It writes the suggestions to a Google Sheet, and adds “N/A” if no good matches are found

Setup steps
Turn on the Google Sheets API and create a sheet with your domain, target URLs, and keywords
Create a SERP API account and get an API key
Optional: Set up a Google Programmable Search Engine if you prefer not to use the SERP API
Add your SERP API key and Google Sheets credentials to n8n.
Run the workflow to generate internal link suggestions in your Google Sheet