Automatic Keyword Research SEO | GSheets + GDrive -> DataForSEO

Automated SEO Keyword Research Report Workflow Overview This workflow automates the process of comprehensive SEO keyword research. It takes a single "main keyword" from a Google Sheet, uses the DataForSEO API to gather a wide array of related data, and then organizes and saves this information into a newly created, structured Google Sheet report. The primary goal is to eliminate the manual, time-consuming tasks of gathering keyword ideas, analyzing SERPs, and finding related questions. By simply inputting one keyword, the user receives a multi-tabbed spreadsheet filled with actionable SEO data, dramatically speeding up content strategy and planning. Technologies Used - n8n: The automation platform coordinating the entire process. - Google Sheets: Used as both the input source for the main keyword and the final destination for the organized research data. - Google Drive: Manages the file system by creating a dedicated folder for each keyword report and copying a template sheet into it. - DataForSEO: A powerful SEO data provider whose API is the core engine for fetching all keyword metrics, SERP data, and related content ideas. AI Integration The workflow integrates AI through the DataForSEO Content Generation API. Specifically, the HTTP Subtopics node calls the /content_generation/generate_sub_topics/live endpoint. Instead of just pulling existing keyword data, this function uses a generative model to brainstorm and produce a list of relevant subtopics for the main keyword. This helps users understand the broader context of a topic and identify key themes to cover in their content, moving beyond simple keyword matching to true topical authority. --- Node-by-Node Analysis This workflow provides a powerful, multi-faceted keyword research report triggered from a single entry in a Google Sheet. H2: Phase 1: Initiation and Setup This phase reads the user's input and prepares the environment in Google Drive for the final report. - When clicking ‘Test workflow’: This is a Manual Trigger node, allowing the user to start the workflow on demand. - Google Sheets KW Research Template: The workflow begins by reading a specific Google Sheet.