{"id":355,"date":"2026-03-03T10:26:28","date_gmt":"2026-03-03T10:26:28","guid":{"rendered":"https:\/\/dataforseo.com\/templates\/?p=355"},"modified":"2026-03-05T15:05:16","modified_gmt":"2026-03-05T15:05:16","slug":"track-new-ranked-keywords-in-google-sheets-with-dataforseo-and-slack-alerts-n8n","status":"publish","type":"post","link":"https:\/\/dataforseo.com\/templates\/track-new-ranked-keywords-in-google-sheets-with-dataforseo-and-slack-alerts-n8n\/","title":{"rendered":"Track new ranked keywords in Google Sheets with DataForSEO and Slack alerts + n8n"},"content":{"rendered":"\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"569\" src=\"https:\/\/dataforseo.com\/templates\/wp-content\/uploads\/2026\/03\/Get-new-ranked-keywords-in-Slack-DM-and-Google-Sheets-with-DataForSEO-1024x569.png\" alt=\"\" class=\"wp-image-356\" srcset=\"https:\/\/dataforseo.com\/templates\/wp-content\/uploads\/2026\/03\/Get-new-ranked-keywords-in-Slack-DM-and-Google-Sheets-with-DataForSEO-1024x569.png 1024w, https:\/\/dataforseo.com\/templates\/wp-content\/uploads\/2026\/03\/Get-new-ranked-keywords-in-Slack-DM-and-Google-Sheets-with-DataForSEO-300x167.png 300w, https:\/\/dataforseo.com\/templates\/wp-content\/uploads\/2026\/03\/Get-new-ranked-keywords-in-Slack-DM-and-Google-Sheets-with-DataForSEO-768x427.png 768w, https:\/\/dataforseo.com\/templates\/wp-content\/uploads\/2026\/03\/Get-new-ranked-keywords-in-Slack-DM-and-Google-Sheets-with-DataForSEO.png 1217w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">Quick overview<\/h3>\n\n\n\n<p>This workflow automates the tracking of newly ranked keywords using the DataForSEO API and logs results into Google Sheets while sending alerts via Slack when new rankings are found. Instead of manually checking order changes or exported keyword lists, this workflow keeps your sheet updated and notifies your team in when opportunities arise.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Who it\u2019s built for<\/h3>\n\n\n\n<p>This template is ideal for SEO specialists, digital marketing teams, and content strategists who need to stay informed about new keyword rankings without manual monitoring. It works especially well for teams collaborating on search performance, content prioritization, and growth tracking.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Workflow breakdown<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>The scenario is scheduled to run at regular intervals (e.g., weekly).<\/li>\n\n\n\n<li>It calls the DataForSEO Labs API for your specified domain.<\/li>\n\n\n\n<li>The workflow identifies newly ranked keywords not previously logged.<\/li>\n\n\n\n<li>New keywords are added as rows in a Google Sheets spreadsheet.<\/li>\n\n\n\n<li>A Slack message is sent with details of the new rankings to notify your team instantly.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">What you get<\/h3>\n\n\n\n<p>You get an automated system that continuously watches for new keyword rankings and writes them into Google Sheets while delivering real\u2011time Slack alerts. This keeps both your data platform and your team aligned with the latest search performance changes without manual effort.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">What you need to get started<\/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\">your API login and password<\/a>).<\/li>\n\n\n\n<li>A spreadsheet in Google Sheets with your keywords that matches the required column structure (as in\u00a0<a href=\"https:\/\/docs.google.com\/spreadsheets\/d\/1FO9Btg5y5TmE56La4O-QzJbEjGAZLe3zG0phB7eXnqs\/edit?pli=1&amp;gid=1681593026#gid=1681593026\" target=\"_blank\" rel=\"noreferrer noopener\">the example<\/a>).<\/li>\n\n\n\n<li>A spreadsheet in Google Sheets with your target domains that matches the required column structure (as in\u00a0<a href=\"https:\/\/docs.google.com\/spreadsheets\/d\/1FO9Btg5y5TmE56La4O-QzJbEjGAZLe3zG0phB7eXnqs\/edit?pli=1&amp;gid=0#gid=0\" target=\"_blank\" rel=\"noreferrer noopener\">the example<\/a>).<\/li>\n\n\n\n<li>A Slack workspace with a channel connected in n8n.<\/li>\n\n\n\n<li>An n8n instance configured with DataForSEO, Google Sheets, and Slack integrations.<\/li>\n<\/ol>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Quick overview This workflow automates the tracking of newly ranked keywords using the DataForSEO API and logs results into Google Sheets while sending alerts via Slack when new rankings are found. Instead of manually checking order changes or exported keyword lists, this workflow keeps your sheet updated and notifies your team in when opportunities arise. [&hellip;]<\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[37,38],"tags":[32],"tools":[19,20,34],"class_list":["post-355","post","type-post","status-publish","format-standard","hentry","category-rank-tracking-alerts","category-keyword-analysis","tag-dataforseo-labs-api","tools-n8n","tools-google-spreadsheets","tools-slack"],"_links":{"self":[{"href":"https:\/\/dataforseo.com\/templates\/wp-json\/wp\/v2\/posts\/355","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=355"}],"version-history":[{"count":1,"href":"https:\/\/dataforseo.com\/templates\/wp-json\/wp\/v2\/posts\/355\/revisions"}],"predecessor-version":[{"id":357,"href":"https:\/\/dataforseo.com\/templates\/wp-json\/wp\/v2\/posts\/355\/revisions\/357"}],"wp:attachment":[{"href":"https:\/\/dataforseo.com\/templates\/wp-json\/wp\/v2\/media?parent=355"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dataforseo.com\/templates\/wp-json\/wp\/v2\/categories?post=355"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dataforseo.com\/templates\/wp-json\/wp\/v2\/tags?post=355"},{"taxonomy":"tools","embeddable":true,"href":"https:\/\/dataforseo.com\/templates\/wp-json\/wp\/v2\/tools?post=355"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}