Collect keyword clusters for URLs in Google Sheets with DataForSEO


This workflow automatically fetches up to 100 ranked keywords for specific URLs based on Google search data and stores your full ranking history in Google Sheets.

On each scheduled run, the workflow reads a list of URLs and related input from your Google Sheets, and uses the DataForSEO Labs API to collect ranking keywords together with all relevant SEO metrics, such as position, search volume, keyword difficulty, CPC, competition, intent, result type, and estimated traffic.

The workflow then saves the results in a separate Spreadsheet tab corresponding to each URL. Table rows contain your keywords, columns store ranking positions by run date, and keyword metrics. Every execution creates a new historical snapshot without replacing previous data.

As a result, you get a clean historical table by URL that lets you easily compare keyword coverage between runs, detect ranking changes, and analyze organic search trends without manual exports.

Who’s it for

This workflow is ideal for SEO specialists, content marketers, agencies, and website owners who want to automatically collect and store historical data on ranked keyword clusters for specific URLs.

What it does