Automate real-time SEO keyword research with DataForSEO and Google Sheets

This n8n template automates real-time SEO keyword research, delivering comprehensive keyword insights, autocomplete suggestions, subtopics, SERP analysis, and more, straight into your Google Sheet.

Use cases are many: This workflow is perfect for bloggers, SEO professionals, affiliate marketers, e-commerce teams, and content creators who need fresh, actionable keyword data for planning, optimization, and content expansion - without endless manual research.

How It Works Phase 1: Set Google Sheet ID & Input Target Keywords - In n8n, enter the Google Sheet ID in the Set Sheet ID node. - In the connected Google Sheet, for the first tab Main Keyword, you manually add the main keywords that you want the tool to research and generate relevant keyword suggestions for. - Trigger the process by clicking Test Workflow or Execute Workflow. - The workflow automatically reads your main keywords from the Main Keyword tab in your linked Google Sheet, only those marked with the status Ready will be processed.

Phase 2: Automated Research & Data Collection For your input main keyword (considering here you only set Ready for one main keyword in the connected Google Sheet), the workflow runs multiple automated queries in parallel:

1. Get Related Keywords:

- The workflow sends a POST request to the DataForSEO API endpoint to directly retrieve an array of related keywords. - Then, the array of related keywords is parsed out, preparing each keyword as a separate record for further processing. - It appends each extracted related keyword as a new row in the Related KW tab of your connected Google Sheet. The Main Keyword value from your input is included in Column A of the tab to maintain keyword context. - Additionally, the workflow appends the related keywords - along with the associated main keyword - to the All Results tab in your Google Sheet for consolidated tracking and future reference. This ensures you have both a dedicated list of related keywords and a master log of all research results in one place.

2. Get Keyword Suggestions:

- The workflow sends a POST request to the DataForSEO API endpoint to directly retrieve an array of keyword suggestions related to your main keyword. - This array of keyword suggestions is then parsed, splitting out each suggestion as an individual record for further processing. - Each extracted keyword suggestion is appended as a new row in the KW Suggestion tab of your connected Google Sheet. The original Main Keyword value from your input is included in Column A of the tab to maintain clear context. - Additionally, the workflow appends all keyword suggestions - along with the associated main keyword - to the All Results tab in your Google Sheet for consolidated tracking and future reference. This ensures you have both a dedicated list of keyword suggestions and a master log of all research results in one place.