{"id":527,"date":"2026-04-27T08:03:34","date_gmt":"2026-04-27T08:03:34","guid":{"rendered":"https:\/\/dataforseo.com\/templates\/?p=527"},"modified":"2026-04-27T08:03:36","modified_gmt":"2026-04-27T08:03:36","slug":"track-keyword-position-dynamics-by-url-in-google-sheets-with-dataforseo-n8n","status":"publish","type":"post","link":"https:\/\/dataforseo.com\/templates\/track-keyword-position-dynamics-by-url-in-google-sheets-with-dataforseo-n8n\/","title":{"rendered":"Track keyword position dynamics by URL in Google Sheets with DataForSEO + n8n"},"content":{"rendered":"\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"226\" src=\"https:\/\/dataforseo.com\/templates\/wp-content\/uploads\/2026\/04\/Track-keyword-position-dynamics-by-URL-in-Google-Sheets-with-DataForSEO-1024x226.png\" alt=\"\" class=\"wp-image-528\" srcset=\"https:\/\/dataforseo.com\/templates\/wp-content\/uploads\/2026\/04\/Track-keyword-position-dynamics-by-URL-in-Google-Sheets-with-DataForSEO-1024x226.png 1024w, https:\/\/dataforseo.com\/templates\/wp-content\/uploads\/2026\/04\/Track-keyword-position-dynamics-by-URL-in-Google-Sheets-with-DataForSEO-300x66.png 300w, https:\/\/dataforseo.com\/templates\/wp-content\/uploads\/2026\/04\/Track-keyword-position-dynamics-by-URL-in-Google-Sheets-with-DataForSEO-768x170.png 768w, https:\/\/dataforseo.com\/templates\/wp-content\/uploads\/2026\/04\/Track-keyword-position-dynamics-by-URL-in-Google-Sheets-with-DataForSEO-1536x339.png 1536w, https:\/\/dataforseo.com\/templates\/wp-content\/uploads\/2026\/04\/Track-keyword-position-dynamics-by-URL-in-Google-Sheets-with-DataForSEO.png 1812w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Quick overview<\/strong><\/h3>\n\n\n\n<p>This workflow automates keyword rank tracking for specific URLs in Google search and stores the full history in Google Sheets. Using the DataForSEO SERP API, it regularly checks positions, detects ranking changes, and updates your report with fresh data.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Who it\u2019s built for<\/strong><\/h3>\n\n\n\n<p>This template is designed for SEO specialists, digital marketers, agencies, and website owners who want to monitor keyword performance at the URL level. It\u2019s especially valuable for teams managing multiple landing pages and needing a structured, ongoing view of ranking trends over time.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Workflow breakdown<\/strong><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>The workflow runs on a schedule (every two weeks).<\/li>\n\n\n\n<li>It retrieves URLs and keywords from your Google Sheets input.<\/li>\n\n\n\n<li>Only active records are processed (if enabled).<\/li>\n\n\n\n<li>The DataForSEO SERP API is used to check rankings in the top-20 Google search results for your keywords and URLs.<\/li>\n\n\n\n<li>For each URL, a dedicated tab is created (if not already present) in the output spreadsheet.<\/li>\n\n\n\n<li>The workflow records keyword positions for the current run date and calculates ranking changes compared to the previous check.<\/li>\n\n\n\n<li>New columns are added for each run, building a historical ranking dataset.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>What you get<\/strong><\/h3>\n\n\n\n<p>You get an automated rank tracking system that continuously logs keyword positions for each URL into Google Sheets. The data is structured as a historical table where each tab represents a URL, rows list your keywords, and columns show rankings by date, along with position changes. This gives you a clear and organized way to monitor search performance and identify trends with zero manual effort.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>What you need to get started<\/strong><\/h3>\n\n\n\n<ol class=\"wp-block-list\">\n<li>DataForSEO account and API credentials (<a href=\"https:\/\/app.dataforseo.com\/api-access\">API login and password<\/a>).<\/li>\n\n\n\n<li>A Google Sheets account connected to n8n for both input and output data.<\/li>\n\n\n\n<li>An n8n account with the DataForSEO node installed.<\/li>\n\n\n\n<li>A spreadsheet in Google Sheets with your URLs and keywords (should have columns: URL, Keyword, Active).<\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"<p>Quick overview This workflow automates keyword rank tracking for specific URLs in Google search and stores the full history in Google Sheets. Using the DataForSEO SERP API, it regularly checks positions, detects ranking changes, and updates your report with fresh data. Who it\u2019s built for This template is designed for SEO specialists, digital marketers, agencies, [&hellip;]<\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[18],"tools":[19,20],"class_list":["post-527","post","type-post","status-publish","format-standard","hentry","category-other","tag-serp-api","tools-n8n","tools-google-spreadsheets"],"_links":{"self":[{"href":"https:\/\/dataforseo.com\/templates\/wp-json\/wp\/v2\/posts\/527","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dataforseo.com\/templates\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dataforseo.com\/templates\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dataforseo.com\/templates\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/dataforseo.com\/templates\/wp-json\/wp\/v2\/comments?post=527"}],"version-history":[{"count":1,"href":"https:\/\/dataforseo.com\/templates\/wp-json\/wp\/v2\/posts\/527\/revisions"}],"predecessor-version":[{"id":529,"href":"https:\/\/dataforseo.com\/templates\/wp-json\/wp\/v2\/posts\/527\/revisions\/529"}],"wp:attachment":[{"href":"https:\/\/dataforseo.com\/templates\/wp-json\/wp\/v2\/media?parent=527"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dataforseo.com\/templates\/wp-json\/wp\/v2\/categories?post=527"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dataforseo.com\/templates\/wp-json\/wp\/v2\/tags?post=527"},{"taxonomy":"tools","embeddable":true,"href":"https:\/\/dataforseo.com\/templates\/wp-json\/wp\/v2\/tools?post=527"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}