Quick overview
Quick overview This workflow pulls page-query data from Google Search Console, crawls URLs from your sitemap to map existing internal links and identify orphan pages, then uses Claude via OpenRouter to propose high-confidence internal-link opportunities and appends the suggestions to a Google Sheet. How it works Runs manually when you click Execute. Requests the last 90 days of page-and-query performance data from Google Search Console for the configured property. Fetches and parses your sitemap XML, extracts page URLs, and limits the crawl to the configured maximum number of pages. Crawls each page’s HTML and extracts internal links to build an internal link graph and flag orphan pages. Sends the page list (including each page’s top Google Search queries and orphan status) to Claude (OpenRouter) to generate 3–10 internal-link suggestions with query-based anchor text. Validates and deduplicates suggestions by removing invented URLs, enforcing confidence and per-page caps, and flagging links that already exist. Appends each validated suggestion as a new row in Google Sheets for review and tracking. Setup Connect Google Search Console OAuth credentials that have access to the specified Search Console property. Add an OpenRouter API credential and ensure the selected Claude model is available in your account. Connect Google Sheets OAuth credentials and select the target spreadsheet and sheet/tab for output. Update the Config values for your site URL, sitemap URL, Search Console property URL-prefix, maxPages, minConfidence, and maxSuggestionsPerPage. Requirements Google service-account (or OAuth2) credential with Search Console access to the property (webmasters scope); enable the Search Console API OpenRouter credential (or another LLM provider) Google Sheets (OAuth2) credential + a spreadsheet to write to Customization Config node: site URL, sitemap URL, GSC property (URL-prefix), maxPages, minConfidence, maxSuggestionsPerPage Swap the model in the OpenRouter node (default anthropic/claude-sonnet-4.6) Change the trigger from Manual to Schedule for weekly runs Tune the prompt in Suggest Internal Links (e.g., favor anchor-text upgrades) Additional info Contact: Email: salmanmehboob1947@gmail.com Linkedin: https://www.linkedin.com/in/salman-mehboob-pro/. An n8n automation workflow template by Salman Mehboob.
Salman Mehboob
web
free
Others in the same category, ranked by how often they are opened.
