Comprehensive SEO Keyword Research & Analysis with DataForSEO and Google Sheets
Overview
This n8n workflow, named Keyword Search for Blogs, automates the process of gathering and organizing keyword research data for SEO purposes. It integrates with Google Sheets and Google Drive to manage input and output data and leverages the DataForSEO API to fetch comprehensive keyword-related information, including related keywords, keyword suggestions, keyword ideas, autocomplete suggestions, subtopics, and SERP (Search Engine Results Page) analysis. The workflow is designed to streamline SEO research by collecting, processing, and storing data in an organized manner for blog content creation.
Workflow Functionality
The workflow performs the following key functions:
- **Trigger**: Initiated manually via the "When clicking" test workflow node, allowing users to start the process on-demand.
- **Input Data Retrieval**: Reads primary keywords, location, and language data from a specified Google Sheet (SEO PRO).
- **Spreadsheet Creation**: Creates a new Google Sheet with a dynamic title based on the current date (e.g., YYYY-MM-DD-seo pro) and predefined sheet names for organizing different types of keyword data (e.g., keyword, SERP, Content, related keyword, keyword ideas, suggested keyword, subtopics, autocomplete).
- **Google Drive Integration**: Moves the newly created spreadsheet to a designated folder (seo pro) in Google Drive for organized storage.
- **API Data Collection**:
- **Related Keywords**: Fetches related keywords using the DataForSEO API (/v3/dataforseo_labs/google/related_keywords/live), including SERP information and keyword metrics like search volume, CPC, and competition.
- **Keyword Suggestions**: Retrieves keyword suggestions via the DataForSEO API (/v3/dataforseo_labs/google/keyword_suggestions/live).
- **Keyword Ideas**: Collects keyword ideas using the DataForSEO API (/v3/dataforseo_labs/google/keyword_ideas/live).
- **Autocomplete Suggestions**: Gathers Google autocomplete suggestions through the DataForSEO API (/v3/serp/google/autocomplete/live/advanced).
- **Subtopics**: Generates subtopics for the primary keyword using the DataForSEO API (/v3/content_generation/generate_sub_topics/live).
- **People Also Ask & Organic Results**: Pulls People Also Ask questions and organic SERP results via the DataForSEO API (/v3/serp/google/organic/live/advanced).
- **Data Processing**:
- Uses Split Out nodes to break down API responses into individual items for processing.
- Employs Edit Fields nodes to map and format data, extracting relevant fields like keyword, search intent, search volume, CPC, competition, keyword difficulty, and SERP item types.
- Filters SERP results to separate People Also Ask and organic results for targeted processing.
- **Data Storage**: Appends processed data to multiple sheets in the destination Google Sheet (2025-06-08-seo pro) across different tabs:
- **Master Sheet**: Stores comprehensive data including keywords, search intent, related keywords, SERP analysis, and more.
- **Related Keywords**: Stores related keyword data with metrics.
- **Suggested Keywords**: Stores suggested keyword data.
- **Keyword Ideas**: Stores keyword ideas with relevant metrics.
- **Autocomplete**: Stores autocomplete suggestions.
- **Subtopics**: Stores generated subtopics.
- **Organic Results**: Stores organic SERP data with details like domain, URL, title, and description.
Key Features
- **Automation**: Eliminates manual keyword research by automating data collection and organization.
- **Scalability**: Processes multiple keywords and their related data in a single workflow run, with a limit of 100 related items per API call.
- **Dynamic Organization**: Creates and organizes data in a new Google Sheet with a timestamped title, ensuring easy tracking of research over time.
- **Comprehensive SEO Insights**: Collects diverse SEO metrics (e.g., keyword difficulty, search intent, SERP item types) to inform content strategy.
- **Error Handling**: Uses filters to ensure only relevant data (e.g., people_also_ask or organic results) is processed and stored.
Use Case
This workflow is ideal for SEO professionals, content creators, and digital marketers who need to perform in-depth keyword research for blog content. It provides a structured dataset that can be used to identify high-potential keywords, understand search intent, analyze SERP competition, and generate content ideas, all of which are critical for optimizing blog posts to rank higher on search engines.
Inputs
- **Google Sheet (SEO PRO)**: Contains primary keywords, location names, and language names.
- **Google Drive Folder**: Destination folder (seo pro) for storing the output spreadsheet.
- **DataForSEO API Credentials**: Requires HTTP Basic Authentication credentials for accessing DataForSEO API endpoints.
Outputs
- A new Google Sheet titled with the current date (e.g., 2025-06-08-seo pro) containing multiple tabs:
- **Master Sheet**: Aggregated data for all keyword types.
- **Related Keywords**: Detailed metrics for related keywords.
- **Suggested Keywords**: Suggested keyword data.
n8nFree