{"id":531,"date":"2026-04-30T06:31:07","date_gmt":"2026-04-30T06:31:07","guid":{"rendered":"https:\/\/dataforseo.com\/templates\/?p=531"},"modified":"2026-05-07T11:24:27","modified_gmt":"2026-05-07T11:24:27","slug":"collect-keyword-cluster-by-url-in-google-sheets-with-dataforseo-n8n","status":"publish","type":"post","link":"https:\/\/dataforseo.com\/templates\/collect-keyword-cluster-by-url-in-google-sheets-with-dataforseo-n8n\/","title":{"rendered":"Collect keyword cluster 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=\"320\" src=\"https:\/\/dataforseo.com\/templates\/wp-content\/uploads\/2026\/04\/Collect-keyword-cluster-by-URL-in-Google-Sheets-with-DataForSEO-1024x320.png\" alt=\"\" class=\"wp-image-532\" srcset=\"https:\/\/dataforseo.com\/templates\/wp-content\/uploads\/2026\/04\/Collect-keyword-cluster-by-URL-in-Google-Sheets-with-DataForSEO-1024x320.png 1024w, https:\/\/dataforseo.com\/templates\/wp-content\/uploads\/2026\/04\/Collect-keyword-cluster-by-URL-in-Google-Sheets-with-DataForSEO-300x94.png 300w, https:\/\/dataforseo.com\/templates\/wp-content\/uploads\/2026\/04\/Collect-keyword-cluster-by-URL-in-Google-Sheets-with-DataForSEO-768x240.png 768w, https:\/\/dataforseo.com\/templates\/wp-content\/uploads\/2026\/04\/Collect-keyword-cluster-by-URL-in-Google-Sheets-with-DataForSEO-1536x480.png 1536w, https:\/\/dataforseo.com\/templates\/wp-content\/uploads\/2026\/04\/Collect-keyword-cluster-by-URL-in-Google-Sheets-with-DataForSEO.png 1687w\" 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 automatically reads your list of URLs, collects up to 100 organic keywords each URL ranks for on Google using the DataForSEO Labs API, and saves the results along with all key metrics into a historical Google Sheets dataset.<\/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, content marketers, agencies, and website owners who want to automatically collect data on ranked keyword clusters by URL and store historical records.<\/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.<\/li>\n\n\n\n<li>It retrieves URLs from your Google Sheets input.<\/li>\n\n\n\n<li>The DataForSEO SERP API is used to extract top-100 ranked keywords and relevant metrics from Google search results.<\/li>\n\n\n\n<li>For each URL, a dedicated tab is created (if not present) in the output spreadsheet.<\/li>\n\n\n\n<li>The workflow records the current run date and logs keyword, ranking positions, search volume, keyword difficulty, CPC, competition, search intent, and more..<\/li>\n\n\n\n<li>New columns are added for each run, building a historical 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 powerful system that automatically delivers a clean historical table by URL and lets you easily compare keyword coverage between runs, detect changes, and analyze search trends without manual exports.&nbsp;<\/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>An n8n account with the DataForSEO node installed.<\/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>A spreadsheet in Google Sheets with your URLs.<\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"<p>Quick overview This workflow automatically reads your list of URLs, collects up to 100 organic keywords each URL ranks for on Google using the DataForSEO Labs API, and saves the results along with all key metrics into a historical Google Sheets dataset. Who it\u2019s built for This template is designed for SEO specialists, content marketers, [&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":[32],"tools":[19,20],"class_list":["post-531","post","type-post","status-publish","format-standard","hentry","category-other","tag-dataforseo-labs-api","tools-n8n","tools-google-spreadsheets"],"_links":{"self":[{"href":"https:\/\/dataforseo.com\/templates\/wp-json\/wp\/v2\/posts\/531","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=531"}],"version-history":[{"count":1,"href":"https:\/\/dataforseo.com\/templates\/wp-json\/wp\/v2\/posts\/531\/revisions"}],"predecessor-version":[{"id":533,"href":"https:\/\/dataforseo.com\/templates\/wp-json\/wp\/v2\/posts\/531\/revisions\/533"}],"wp:attachment":[{"href":"https:\/\/dataforseo.com\/templates\/wp-json\/wp\/v2\/media?parent=531"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dataforseo.com\/templates\/wp-json\/wp\/v2\/categories?post=531"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dataforseo.com\/templates\/wp-json\/wp\/v2\/tags?post=531"},{"taxonomy":"tools","embeddable":true,"href":"https:\/\/dataforseo.com\/templates\/wp-json\/wp\/v2\/tools?post=531"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}