{"product_id":"compare-google-serps-by-market-in-n8n-hasdata-sheets","title":"Compare Google SERPs by Market in n8n (HasData + Sheets)","description":"\u003ch3\u003eCompare Google SERPs by Market—Automatically in n8n (HasData + Sheets)\u003c\/h3\u003e\n\u003cp\u003eWant to see how the same English search topic performs across two countries before you localize? This n8n workflow fetches paired Google SERPs by market, samples the ranking pages, extracts titles\/headings\/excerpts with HasData, and saves everything to Google Sheets for an editor’s localization review.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReads topics and paired queries:\u003c\/strong\u003e The workflow loads topic IDs and two market-specific queries from the \u003cem\u003eTopics\u003c\/em\u003e tab, validates market settings, and rejects duplicate topics or oversized batches before making paid requests.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eChecks existing results:\u003c\/strong\u003e It reads prior \u003cem\u003eResults\u003c\/em\u003e and checks saved keys to avoid rework.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCollects paired SERPs:\u003c\/strong\u003e For each topic, it searches both markets using the configured location and country code, desktop device, and English interface language. It retains both SERPs, but failed searches—or fewer than five usable results in either market—produce insufficient evidence for an intent conclusion.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSelects comparable pages:\u003c\/strong\u003e It chooses unique pages from the \u003cstrong\u003etop three results\u003c\/strong\u003e in round-robin order. A shared page limit applies across all topics and markets (not separately per query).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReads pages with HasData:\u003c\/strong\u003e Using HasData, it extracts main text, titles, and headings. Source URLs stay attached to the output; failed reads and truncated excerpts remain visible. If the sample is empty, page requests are skipped without discarding the SERPs.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSaves an editor-friendly review sheet:\u003c\/strong\u003e Results, paired comparisons, page samples, unvisited URLs, and editorial questions are written to Google Sheets so localization decisions are grounded in real SERP evidence.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eCompare what ranks in two countries before adapting English content for SEO.\u003c\/li\u003e\n  \u003cli\u003eCollect shared URLs\/domains and evidence for editorial localization planning.\u003c\/li\u003e\n  \u003cli\u003eSurface unvisited ranking URLs that an editor may need to review manually.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCore nodes:\u003c\/strong\u003e if, set, code, html, sticky note, http request.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eHasData:\u003c\/strong\u003e Used to read selected ranking pages and extract page content (titles\/headings\/excerpts).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets:\u003c\/strong\u003e Stores SERP comparisons, page samples, unvisited URLs, and editorial questions.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46164221395123,"sku":"N8N-20475","price":49.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/8niQPlGeXfY-AcwxqWtck_l9xhgHLw.png?v=1791278445","url":"https:\/\/buyflowscripts.com\/products\/compare-google-serps-by-market-in-n8n-hasdata-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}