{"product_id":"track-google-local-pack-rankings-in-google-sheets-n8n-apify","title":"Track Google Local Pack Rankings in Google Sheets (n8n + Apify)","description":"\u003ch3\u003eTrack Google Local Pack rankings automatically in Google Sheets (n8n + Apify)\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow checks your \u003cstrong\u003eGoogle Local Pack\u003c\/strong\u003e positions every Monday morning and logs each local listing—complete with \u003cstrong\u003erank (position), rating, and address\u003c\/strong\u003e—directly into your \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e tab.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns on a schedule:\u003c\/strong\u003e a scheduled trigger executes every Monday morning.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLoads configuration:\u003c\/strong\u003e it uses a configured list of keywords, a target location, your business name, and optional \u003cem\u003eGoogle country\/domain\u003c\/em\u003e settings.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eQueries Google Local Pack via Apify:\u003c\/strong\u003e for each keyword, it runs the \u003cstrong\u003eApify actor\u003c\/strong\u003e \u003cstrong\u003ejohnvc~google-local-api\u003c\/strong\u003e to fetch Google local pack results for your query and location.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSkips empty results:\u003c\/strong\u003e if a keyword returns no local pack listings, that search is skipped.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eExpands listings into rows:\u003c\/strong\u003e each local pack business becomes a separate item.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFormats spreadsheet columns:\u003c\/strong\u003e outputs include \u003cstrong\u003edate, keyword, position, business name, category, rating, reviews, address\u003c\/strong\u003e and flags rows that match your business name.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAppends to Google Sheets:\u003c\/strong\u003e it writes the formatted results into the selected spreadsheet document ID and sheet tab.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eLocal SEO teams monitoring weekly movement for multiple target keywords.\u003c\/li\u003e\n  \u003cli\u003eSaaS operators wanting a simple \u003cstrong\u003eGoogle Local Pack tracking\u003c\/strong\u003e dashboard in Sheets.\u003c\/li\u003e\n  \u003cli\u003eAgencies comparing competitors by logging rank, rating, and address over time.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n workflow category:\u003c\/strong\u003e n8n automation workflow\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNodes\/blocks used:\u003c\/strong\u003e \u003ccode\u003eset\u003c\/code\u003e, \u003ccode\u003efilter\u003c\/code\u003e, \u003ccode\u003esplit out\u003c\/code\u003e, \u003ccode\u003esticky note\u003c\/code\u003e, \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, and \u003cstrong\u003eApify (apifyn8n-nodes-apify)\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eApify integration:\u003c\/strong\u003e uses your \u003cstrong\u003eApify API token\u003c\/strong\u003e as an n8n credential.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOutput:\u003c\/strong\u003e appended rows per listing (keyword × local pack businesses) in Google Sheets.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003cp\u003e\u003cstrong\u003eSetup reminder:\u003c\/strong\u003e update your keyword list, location, business name, and (optionally) \u003cstrong\u003egoogleDomain\/country\u003c\/strong\u003e before activating the workflow.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45738602299571,"sku":"N8N-17523","price":59.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/7fh4KVXr-xd2rKvJhzySP_raejeqSb.png?v=1785230293","url":"https:\/\/buyflowscripts.com\/products\/track-google-local-pack-rankings-in-google-sheets-n8n-apify","provider":"N8N Commerce","version":"1.0","type":"link"}