Track new ranked keywords in Google Sheets with DataForSEO and Slack alerts

Once a week, this workflow automatically scans Google for newly ranked keywords for your domains using the DataForSEO API. It pulls the latest data for every target you track, stores a fresh snapshot in Google Sheets, and compares it to the previous run. Any newly ranked keywords are automatically added to a dedicated Google Sheet, creating an easy-to-review log. Lastly, the workflow sends a short summary to Slack, so your team can quickly see what’s changed without manual checks.

Who’s it for

SEO specialists and marketers who want to automatically track newly ranked keywords for their target domains and get quick weekly updates without doing manual Google checks.

What it does

This workflow automatically fetches new keywords your domains started ranking for on Google using DataForSEO Labs API, saves them into Google Sheets, and sends you a Slack summary so you can quickly see what’s changed.

How it works

Triggers on your chosen schedule (default: once a week).
Reads your keywords and target domains from Google Sheets.
Extracts fresh ranking data from Google via DataForSEO API.
Compares the results with the previous run.
Adds newly ranked keywords into a dedicated Google Sheet.
Sends a weekly summary message to Slack.

Requirements

• DataForSEO account
• A spreadsheet in Google Sheets with your keywords that matches the required column structure (as in the example).
• A spreadsheet in Google Sheets with your target domains that matches the required column structure (as in the example).
• Slack account

Customization

You can easily customize the workflow by changing the schedule, exporting results to dashboards and other tools (such as Looker Studio and BigQuery) instead of Google Sheets, and modifying the Slack message text.