Comprehensive SEO Keyword Research & Analysis with DataForSEO and Google Sheets — n8n Workflow

High complexity⚡ Trigger38 nodes👩‍💻 IT Opsby rana tamure

Overview

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 st

Nodes used

Google SheetsHTTP RequestGoogle Drive

Workflow Preview

Spreadsheet Creation: Creates a new Google Sh
Google Drive Integration: Moves the newly cre
API Data Collection:
Related Keywords: Fetches related keywords using the Da
⚡
W
When clicking ‘Test work…
Google Sheets
Google Sheets1
Google Drive
S
Split Out
E
Edit Fields
S
Split Out1
E
Edit Fields2
S
Split Out2
E
Edit Fields3
S
Split Out3
E
Edit Fields4
S
Split Out4
related keyword
keyword suggestion
keyword ideas
get autocomplete
get_subtopics
E
Edit Fields6
Google Sheets3
Google Sheets4
Google Sheets5
Google Sheets6
Google Sheets7
Google Sheets8
Google Sheets9
Google Sheets10
Google Sheets11
Google Sheets12
S
Split Out5
E
Edit Fields1
F
Filter
F
Filter1
people also ask
Google Sheets2
S
Split Out6
E
Edit Fields5
Google Sheets13
38 nodes37 edges

How it Works

  1. 1

    Trigger

    The workflow starts with a trigger trigger.

  2. 2

    Process

    Data flows through 38 nodes, connecting filter, googledrive, googlesheets.

  3. 3

    Output

    The workflow completes its automation and delivers the result to the configured destination.

Node Details (38)

GO

Google Sheets

googleSheets

#1
HT

HTTP Request

httpRequest

#2
GO

Google Drive

googleDrive

#3

How to Import This Workflow

  1. 1Click Download JSON button on the right to save the workflow file.
  2. 2Open your n8n instance. Go to Workflows → New → Import from file.
  3. 3Select the downloaded comprehensive-seo-keyword-research-analysis-with-dataforseo-and-google-sheets file and click Import.
  4. 4Set up credentials for each service node (API keys, OAuth, etc.).
  5. 5Click Test Workflow to verify everything works, then activate it.

Or paste directly in n8n → Import from JSON:

{ "name": "Comprehensive SEO Keyword Research & Analysis with DataForSEO and Google Sheets", "nodes": [...], ...}

Integrations

filtergoogledrivegooglesheetshttprequestmanualtriggersetsplitout

Get This Workflow

Download and import in one click

Download JSONView on n8n.io
Nodes38
Complexityhigh
Triggertrigger
CategoryIT Ops

Created by

rana tamure

rana tamure

@tamure

Tags

filtergoogledrivegooglesheetshttprequestmanualtriggersetsplitout
⚡

New to n8n?

n8n is a free, open-source workflow automation tool. Self-host it or use the cloud version.

Get n8n Free →