{"product_id":"n8n-google-serp-scraper-rankings-to-google-sheets","title":"n8n Google SERP Scraper: Rankings to Google Sheets","description":"\u003ch3\u003eTrack Google rankings from Google Sheets—automatically parse SERP results back into your spreadsheet\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow manually runs a Google SERP scraper that takes your keywords from Google Sheets, fetches the Google search results pages using \u003cstrong\u003eScrapeUnblocker\u003c\/strong\u003e, extracts the top organic results (rank, title, URL, snippets, and dates), and writes the results back into Google Sheets.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eManually triggered:\u003c\/strong\u003e Starts when you run a \u003cem\u003eManual Trigger\u003c\/em\u003e in n8n.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReads keywords from Google Sheets:\u003c\/strong\u003e Pulls a list from a specified worksheet\/tab and expects a \u003cstrong\u003eKeyword\u003c\/strong\u003e input column.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eBuilds Google SERP URLs:\u003c\/strong\u003e Processes keywords in batches and constructs a Google search URL using \u003ccode\u003enum=10\u003c\/code\u003e for each keyword.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFetches SERPs via ScrapeUnblocker:\u003c\/strong\u003e Downloads the HTML for each Google results page from \u003ccode\u003ehttps:\/\/www.google.com\/search\u003c\/code\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eParses organic results:\u003c\/strong\u003e Extracts organic \u003cstrong\u003erank\u003c\/strong\u003e, \u003cstrong\u003etitle\u003c\/strong\u003e, \u003cstrong\u003eURL\u003c\/strong\u003e, \u003cstrong\u003emeta description snippet\u003c\/strong\u003e, an \u003cstrong\u003eoptional published date\u003c\/strong\u003e, and includes a \u003cstrong\u003escrape date\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUpdates Google Sheets:\u003c\/strong\u003e Writes the extracted SERP data back to your target worksheet and continues until all keywords are processed.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eMonitor keyword ranking changes for an SEO campaign and keep a running SERP log in Google Sheets.\u003c\/li\u003e\n  \u003cli\u003eValidate whether your pages appear in the top organic results for high-priority keywords.\u003c\/li\u003e\n  \u003cli\u003eSupport SaaS reporting by exporting SERP ranks, titles, and snippets for client-facing spreadsheets.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations\/Nodes:\u003c\/strong\u003e Google Sheets, Manual Trigger, batch splitting, \u003cstrong\u003en8n-nodes-scrapeunblockerscrape unblocker\u003c\/strong\u003e, and \u003cem\u003ecode\u003c\/em\u003e parsing logic.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSetup requirements:\u003c\/strong\u003e Configure Google Sheets credentials, spreadsheet ID, worksheet\/tab, and the input column name (\u003cstrong\u003eKeyword\u003c\/strong\u003e).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eScrapeUnblocker:\u003c\/strong\u003e Add ScrapeUnblocker credentials and ensure access to \u003ccode\u003ehttps:\/\/www.google.com\/search\u003c\/code\u003e from your environment.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSheet columns:\u003c\/strong\u003e At minimum \u003cstrong\u003eKeyword\u003c\/strong\u003e, \u003cstrong\u003eRank\u003c\/strong\u003e, \u003cstrong\u003eTitle\u003c\/strong\u003e, \u003cstrong\u003eMeta Description\u003c\/strong\u003e, and \u003cstrong\u003eDate\u003c\/strong\u003e (optionally \u003cstrong\u003eURL\u003c\/strong\u003e).\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45738535452851,"sku":"N8N-17540","price":69.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/HPNQPliAgNhNsBHLh4tjO_kuDn5A0l.png?v=1785229862","url":"https:\/\/buyflowscripts.com\/products\/n8n-google-serp-scraper-rankings-to-google-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}