G
GTM Vault
Browse
  • Dashboard
    • Automations
    • Skills
    • Prompts
    • Makers
  • Sign in
All Automations

SEO Research Engine

Automated keyword research and SEO analysis. Pulls from Keywords Everywhere API, analyzes SERP, extracts PAA/PAS, mines Reddit for validation, outputs to Google Sheets.

View on GitHub
workflowContent & SEOAI-PoweredSEOContent
Original
by Roheel Jain
Nodes

44

Triggers

1

Platform

n8n

Tech Stack
Keywords Everywhere API
SERP API
SERP API
Reddit API
Reddit API
Google Sheets
Google Sheets
Perplexity
Perplexity
HTTP API
DeepSeek AI
DeepSeek AI
Workflow

HTTP SearchVolume

httpRequest

HTTP Keyword Suggestions

httpRequest

Extract Organic

code

Extract Suggestions

code

HTTP Related Keywords

httpRequest

HTTP Subtopics

httpRequest

Extract Related Keywords

code

Extract Subtopics

code

Extract Volume Trend

code

Extract PAA/PAS

code

Overview

googleSheets

Search Volume Trend

googleSheets

PAA

googleSheets

Organic Results

googleSheets

Suggestions

googleSheets

Subtopics

googleSheets

Related Keywords

googleSheets

average search volume and CPC

code

Average competition

code

Code

code

Restructure data

code

Merge1

merge

When Executed by Another Workflow

executeWorkflowTrigger

Get Keyword Data

n8n-nodes-keywords-everywhere-api.keApi

Get PASF Keywords

n8n-nodes-keywords-everywhere-api.keApi

Split Out

splitOut

Keywords Everywhere API

n8n-nodes-keywords-everywhere-api.keApi

Split Out1

splitOut

Extract Keyword Ideas

code

HTTP Keyword Ideas

httpRequest

HTTP Google SERP

httpRequest

Code in JavaScript

code

Keywords Ideas1

googleSheets

Call 'XLRATE CORE | BLOG AUTOMATION'

executeWorkflow

Research Topic- Perplexity1

httpRequest

Switch

switch

Enrichment Input

googleSheets

Code1

code

Google Sheets3

googleSheets

Reddit Keyword Search

reddit

Loop Over Items1

splitInBatches

DeepSeek

n8n-nodes-deepseek.deepSeek

Specific Reddit

reddit

Webhook

webhook

Mini Map
Press enter or space to select a node. You can then use the arrow keys to move the node around. Press delete to remove it and escape to cancel.
Press enter or space to select an edge. You can then press delete to remove it or escape to cancel.
How It Works

This automation transforms hours of manual keyword research into a comprehensive SEO report delivered instantly to your Google Sheets. Simply enter a target keyword and receive detailed analysis including search volume, competitor rankings, related keywords, and real audience validation from Reddit discussions.

1

Enter your target keyword

Input the main keyword you want to research. The system will use this as the foundation for all analysis and discovery.

2

Gather comprehensive keyword data

Automatically pulls search volume, cost-per-click data, competition levels, and trend information for your keyword. Also discovers hundreds of related keyword suggestions and subtopics.

3

Analyze competitor rankings

Examines Google search results to identify who's ranking for your keyword, their page titles, and meta descriptions. Captures 'People Also Ask' questions that reveal content opportunities.

4

Validate with real audience discussions

Searches Reddit for conversations about your keyword to understand how real people talk about this topic. Uses AI to analyze these discussions for authentic insights and pain points.

Attached Files
workflow.json
5

Generate organized reports

Compiles all findings into structured spreadsheet tabs including keyword overview, search trends, competitor analysis, content ideas, and audience insights. Everything is ready for your content strategy.

What You'll Need

Keywords EverywhereGoogle SheetsSERP API
  • Keywords Everywhere API subscription and key
  • Google Sheets account with automation access enabled
  • SERP API account for search result analysis
  • Reddit API access for audience research
  • DeepSeek AI account for content analysis

Optional integrations:

RedditDeepSeek AIPerplexity AI

Estimated Cost per Run

USD 0.15 – 0.75 (Costs vary based on keyword competitiveness and number of related terms discovered. Includes API usage for keyword data, search results, and AI analysis.)

This automation has 10 configurable settings you'll customize during setup.