{"product_id":"n8n-weekly-serp-ai-visibility-tracker-to-google-sheets","title":"n8n Weekly SERP \u0026 AI Visibility Tracker to Google Sheets","description":"\u003ch3\u003eTrack Google rankings and AI visibility every week—automatically\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow runs weekly to pull Google SERP positions and AI visibility signals (ChatGPT and Perplexity) for your domain and keyword list, then appends the results into a Google Sheets dashboard tab for ongoing SEO and AI tracking.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWeekly scheduled run:\u003c\/strong\u003e Executes every Sunday at \u003cstrong\u003e11pm\u003c\/strong\u003e using a schedule trigger.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLaunches an Apify SERP + AI Visibility Tracker run:\u003c\/strong\u003e Starts an Apify Actor to check \u003cstrong\u003eGoogle SERP positions\u003c\/strong\u003e and \u003cstrong\u003eAI mentions\u003c\/strong\u003e for your configured \u003cstrong\u003edomain, brand name, keywords, and locale\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFetches results from Apify:\u003c\/strong\u003e Retrieves the completed dataset using the run’s \u003cstrong\u003edefault dataset ID\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFormats metrics for your dashboard:\u003c\/strong\u003e For each keyword, it prepares fields including \u003cstrong\u003eGoogle position\u003c\/strong\u003e, \u003cstrong\u003eposition change\u003c\/strong\u003e, \u003cstrong\u003efeatured snippet\u003c\/strong\u003e and \u003cstrong\u003eAI Overview\u003c\/strong\u003e flags, per-engine mention\/context (ChatGPT and Perplexity), and an \u003cstrong\u003eAI visibility score\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUpdates Google Sheets:\u003c\/strong\u003e Appends \u003cstrong\u003eone row per keyword\u003c\/strong\u003e into the \u003cstrong\u003e“Weekly Visibility Tracker”\u003c\/strong\u003e tab.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eMonitor whether SEO improvements move your \u003cstrong\u003eGoogle positions\u003c\/strong\u003e and impact visibility in \u003cstrong\u003eAI Overview\u003c\/strong\u003e and featured snippets.\u003c\/li\u003e\n  \u003cli\u003eTrack brand and keyword presence in \u003cstrong\u003eChatGPT\u003c\/strong\u003e and \u003cstrong\u003ePerplexity\u003c\/strong\u003e over time using consistent weekly reporting.\u003c\/li\u003e\n  \u003cli\u003eSaaS SEO teams and automation engineers maintain a single source of truth in \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e for weekly SEO + AI reporting.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNodes\/stack:\u003c\/strong\u003e code, sticky note, HTTP Request, Google Sheets, schedule trigger\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations:\u003c\/strong\u003e Apify (SERP + AI Visibility Tracker), Google Sheets (OAuth2)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRequired credentials:\u003c\/strong\u003e Apify API token, OpenAI (ChatGPT) API key, Perplexity API key\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003cp\u003e\u003cstrong\u003eTip:\u003c\/strong\u003e Create a Google Sheet tab named \u003cstrong\u003e“Weekly Visibility Tracker”\u003c\/strong\u003e with columns matching the formatted fields (e.g., Date, Keyword, Google Position, Position Change, Has Featured Snippet, Has AI Overview, ChatGPT Mentioned\/Context, Perplexity Mentioned\/Context, Claude Mentioned, AI Visibility Score).\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45923078799539,"sku":"N8N-18870","price":30.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/mI3FjZYy2PWPycqU5M-G2_MEJPZ9uO.png?v=1788167918","url":"https:\/\/buyflowscripts.com\/products\/n8n-weekly-serp-ai-visibility-tracker-to-google-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}