Frankenstein v4.

0 N8N Workflow
Thank you so much for purchasing the SEO Frankenstein v4.0 N8N Workflow! I'm excited for you to
automate your content creation process.

This document provides all the necessary instructions on how to set up and use this powerful N8N
workflow to generate high-quality, SEO-focused articles.

Below you will find the core workflow file. Please download the .json file to get started.

🎬 Video Walkthrough
A comprehensive video guide provides essential context and detailed setup instructions. It's highly
recommended to watch this video before you start!

➡️ Watch the Video Walkthrough: https://youtu.be/d-4iJkYl4bc

Overview
SEO Frankenstein v4.0 is an advanced, multi-stage N8N workflow designed to automate the complex
process of creating top-ranking articles. It takes user input (like a topic and primary keyword) and
orchestrates a series of research, AI generation, and quality assurance steps to produce a polished article
draft.

Core Technologies Used:

N8N (Automation Platform: https://n8n.io/)

DataforSEO (SEO Data & SERP Analysis: https://app.dataforseo.com/) - PAID API (requires credits)
Tavily API (Web Search: https://tavily.com/) - API Key Required (Check their plans)
Google Gemini 2.5 Pro (AI Model via Google AI Studio / Vertex AI) - API Key Required (Check usage
costs)
Google Sheets (Data Storage & Output - OAuth2 Authentication)
Google Docs (via md2doc service for final document - OAuth2 Authentication)

Features & Capabilities

This workflow automates the following key stages:

1. Automated Deep Research:

Fetches Keyword Suggestions (DataforSEO)
Analyzes Primary Keyword SERP Data (DataforSEO)
Gathers General Keyword Context via Web Search (Tavily)
Retrieves Google Search Volume Data (DataforSEO)
Performs Parsed SERP Analysis (Top Organic Results, SERP Features, Refinement Chips)
(DataforSEO)
Consolidates all research into a structured Google Sheet row identified by a unique Reference
Code.
2. Advanced AI Content Generation (Multi-Agent System with Gemini 2.5 Pro):
Keyword Summary & Insights Agent: Analyzes the collected research to brief the subsequent AI
agents.
 Outline Agent: Generates a comprehensive, SEO-informed article outline based on the insights.
Drafting Agent: Writes the full first draft following the generated outline.
E-E-A-T Agent: Enhances the draft specifically for Experience, Expertise, Authoritativeness, and
Trustworthiness signals, crucial for SEO.
3. AI-Assisted Quality Assurance:
Fact-Checking Agent: Reviews the E-E-A-T enhanced draft, comparing claims against source data
snippets and flagging potential inaccuracies or unsourced statements.
Final Editor Agent: Performs a final polish for grammar, style, clarity, flow, and consistency,
referencing the original outline.
4. Formatting & Delivery:
Formats the final edited content into clean Markdown.
Uses the md2doc service (requires Google Docs API access) to convert Markdown into a Google
Doc.
Generates basic HTML format using a Code node.
Updates the original Google Sheet row with a link to the final Exported Google Doc.

📄 Prerequisites & Requirements

⚠️ IMPORTANT: This workflow relies on several external services, some of which require paid accounts
and API credits. Please ensure you have the following before proceeding with the setup:

1. N8N Instance:
A running N8N instance (Self-hosted or N8N Cloud).
For self-hosting locally: How to install n8n locally (Video Guide)
2. API Credentials & Accounts: This workflow REQUIRES API keys/credentials for the following services.
You MUST add these credentials in the corresponding nodes within the N8N workflow editor.
DataforSEO Account:
You MUST have a DataforSEO account with sufficient API credits. This workflow uses multiple
endpoints extensively.
Sign up and get API credentials here: https://app.dataforseo.com/
Tavily API Account:
An API key is required.
Check their website for current pricing and plan details: https://tavily.com/
Google Gemini 2.5 Pro API Access (or compatible model):
You need API access, typically obtained via:
Google AI Studio (https://aistudio.google.com/)
Google Cloud Vertex AI (https://cloud.google.com/vertex-ai)
Ensure you understand any potential costs associated with API usage.
Google Account with API Access:
Google Sheets API Access: Requires OAuth2 authentication setup in N8N.
Google Docs API Access: Requires OAuth2 authentication setup in N8N (used by the Markdown
Format HTTP Request node targeting the md2doc service).
3. Google Sheet:
A Google Sheet ready to store data and receive output.
You can use the example sheet as a template: SEO Frankenstein Example Sheet
4. (Recommended): Basic understanding of N8N concepts (nodes, credentials, importing workflows) and
how API keys work.

💡 Setup Instructions
1. Download Workflow File: Download the SEO_FRANKENSTEIN_v4_0.json workflow file provided with your
purchase.
2. Import Workflow:
 Open your N8N instance.
Go to "Workflows".
Click "Import" and choose "Import from File".
Upload the SEO_FRANKENSTEIN_v4_0.json file.
3. Configure Credentials (Crucial Step!):
You MUST add your API credentials in the corresponding nodes. Refer to the node names mentioned
below or in the video guide.
DataforSEO Credentials:
Locate the DataforSEO nodes (e.g., Keyword Suggestions, Get Primary Keyword SERP, etc.).
In the "Credentials" section of each node, select or create a DataforSEO credential using your
API Login and Password from DataforSEO. The JSON uses a credential named "DataForSEO
account".
Local N8N & DataforSEO Community Server: This workflow can work with a local N8N setup
using the DataforSEO community server (mcp). For more information: DataforSEO Node in
N8N (Community)
Cloud N8N & DataforSEO: If using N8N cloud or a different setup, you might need to configure
DataforSEO nodes to use HTTP requests as shown in your DataforSEO dashboard.
Tavily API Key:
Locate the General Keyword Data (HTTP Request) node.
Inside the "JSON Body" (or "Body Parameters" if not raw JSON), find the API key field. The pre-
filled example might be "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". Replace this with your
actual Tavily API key.
Google Gemini Credentials:
Locate the Gemini 2.5 PRO node (or similar named Langchain Chat Model node).
In the "Credentials" section, select or create a Google PaLM/Gemini credential using your API
key obtained from Google AI Studio or Vertex AI. The JSON uses a credential named "Google
Gemini(PaLM) Api account 4".
Google Sheets Credentials:
Locate all Google Sheets nodes (e.g., Create Datasheet, Insert Keyword Data, Insert Doc in Sheets,
etc.).
In the "Credentials" section of each, select or create a Google Sheets OAuth2 credential,
authorizing N8N to access your Google Sheets. The JSON uses a credential named "Google
Sheets account".
Google Docs Credentials (for md2doc service):
Locate the Markdown Format (HTTP Request) node responsible for converting Markdown to
Google Docs.
In the "Authentication" section, ensure "Predefined Credential Type" is selected and "Node
Credential Type" is googleDocsOAuth2Api.
Select or create a Google Docs OAuth2 credential, authorizing access. The JSON uses a
credential named "Google Docs account".
4. Google Sheet Configuration:
The workflow is pre-configured to use a specific Google Sheet ID. It is highly recommended to use
your own sheet.
Update the Document ID and Sheet Name/ID in all Google Sheets nodes (Create Datasheet, Insert
Keyword Data, etc., and Insert Doc in Sheets) to point to your desired Google Sheet.
Ensure the target sheets (e.g., "Keyword Research 1" and "Frankenstein Export" by default) exist in
your Google Sheet.
Make sure these sheets have the necessary column headers (e.g., Reference Code, Keyword
Suggestions, Primary Keyword Sep, General Keyword Data, Google Search Volume, Parsed SERP,
Exported Doc, etc.).
You can use the provided example sheet as a template: SEO Frankenstein Example Sheet. Copy
this template to your own Google Drive.
5. Activate Workflow:
 Once all credentials and sheet details are correctly configured and saved, toggle the workflow to
"Active" in the top right corner of the N8N editor.

How to Use
1. Trigger Workflow:
The workflow is triggered by the On form submission node (Webhook node).
In the N8N editor, select this trigger node and find its "Production URL".
2. Open Form:
Copy the Production URL and open it in your web browser. This will display a simple form.
3. Fill Form:
Complete the form fields:
Article Topic: The main subject of the article (e.g., "Benefits of Shower Filters").
Article Type: Select from the dropdown (e.g., "Blog Post").
Keyword: Enter the primary keyword you want to target (e.g., "shower filter hard water").
Notes: Add any specific instructions, angles, or details for the AI (e.g., "Focus on health benefits
for skin and hair, mention eco-friendly aspects").
4. Submit Form:
Click the submit button on the form.
5. Monitor Execution:
N8N will now execute the entire workflow. This process can take several minutes due to the
multiple API calls and AI generation steps.
You can monitor the progress in the N8N "Executions" tab.
6. Access Output:
Research data will populate the "Keyword Research 1" sheet (or your configured sheet) in your
Google Sheet.
The final Google Doc link will be added to the "Frankenstein Export" sheet (or your configured
sheet) and also in the Exported Doc column of the "Keyword Research 1" sheet, under the
corresponding Reference Code.
The HTML_Format1 node (or similar) within the workflow contains the basic HTML version of the
article, viewable in N8N execution data.

Understanding the Output (Google Sheet)

The Google Sheet serves as both a data store for research and an overview of the generated content:

Reference Code: A unique ID linking the form submission to the research data and final output.
Keyword Suggestions: List of related keywords, their difficulty, and search intent.
Primary Keyword SERP: Top 10 organic results (Rank, Domain, Title, Description, URL) for the main
keyword.
General Keyword Data: Summary, answer, and top web results from Tavily search for general context.
Google Search Volume: Volume, competition, CPC, and monthly breakdown for the primary keyword.
Parsed SERP: Top 10 organic results, identified SERP features (e.g., people_also_ask, video), and
refinement chip titles.
Exported Doc: Direct link to the final Google Document generated by the workflow.

Customization Ideas
Trigger: Replace the Form Trigger (Webhook) with a different trigger like a Google Sheet trigger, a
schedule trigger, or another node based on your specific needs.
AI Model: Change the model in the Gemini 2.5 PRO node (or equivalent Langchain Chat Model node) if
you prefer a different LLM. Ensure it's compatible with the Langchain Agent setup and prompting.
 Prompts: Carefully modify the System Messages within the AI Agent nodes (Keyword Summary &
Insights, Outline, Drafting, E-E-A-T, Fact-Checking, Final Editor) to fine-tune the output style, tone, or
focus. Always back up your workflow before making significant prompt changes!
Sheet Structure: Adjust the Google Sheets nodes to write to different sheets, columns, or to structure
the data differently.
Output Format: Modify or remove the Markdown Format or HTML_Format1 nodes if you only need the
Google Doc, or if you want to add other output formats (e.g., direct WordPress posting).
Alternative Research Tools: If you wish to use other search or keyword research tools, you could
adapt the workflow to integrate APIs from services like Jina AI, or various tools available on RapidAPI,
as alternatives or additions to Tavily or DataforSEO for specific tasks.

❓ Troubleshooting
Credential Errors: Most common issue. Double-check that all API keys and OAuth connections are
correctly configured, selected in the respective nodes, and that the accounts have necessary
permissions.
API Limit Errors: DataforSEO, Tavily, and Google Gemini services have usage limits or quotas. Monitor
your credit/quota usage on their respective platforms. You may need to upgrade your plans or
introduce delays between API calls in N8N if you hit these limits frequently.
Google Sheets Errors:
Ensure the Google Sheet ID and individual Sheet Names/GIDs are correct in all Google Sheets
nodes.
Verify that your N8N Google OAuth credential has permission to edit the specified sheet.
Check that column headers in your sheet match what the workflow expects to write.
Timeout Errors: Complex AI generation or extensive research steps can sometimes time out. Consider
increasing timeout settings in N8N's global configurations or in specific nodes if possible. For very
long article requests, you might explore breaking the process into smaller, chained workflows.
Node Errors: Check the "Executions" log in N8N for specific error messages on failed nodes. These
messages often indicate missing input data, incorrect configuration for that node, or an issue with the
API service itself.
Re-watch the video guide: The video covers many common setup steps and potential pitfalls.

Need Help?
If you run into issues during setup or have questions about the workflow logic:

1. Re-watch the video guide: https://youtu.be/d-4iJkYl4bc

2. Double-check all API credentials and Google Sheet configurations as outlined in the "Setup
Instructions" and "Troubleshooting" sections.
3. If you still need assistance, please contact support at: forthousoul@gmail.com

⭐ Liked It?
If you find this workflow valuable and it helps streamline your content creation, please consider leaving a
rating on Gumroad! Your feedback helps immensely.

Disclaimer
API Costs: You are solely responsible for all costs associated with the required API services
(DataforSEO, Tavily, Google Gemini/AI Platform). Please review their pricing structures carefully before
extensive use.
 AI Output Quality: While this workflow incorporates multiple AI agents and quality assurance steps,
AI-generated content always requires human review, editing, and fact-checking for accuracy, nuance,
and to ensure it aligns with your brand voice and standards before publication.
SEO Results: This workflow is designed based on current SEO best practices to assist in creating
content that has a higher potential to rank. However, rankings are not guaranteed, as many external
factors (domain authority, backlinks, competition, algorithm updates, etc.) influence search engine
results.
Service Changes & Maintenance: APIs and external services may change their endpoints, features,
pricing, or terms of service. Some workflow maintenance or adjustments may be required over time to
ensure continued functionality.
Workflow Usage: This workflow is a tool. Its effectiveness depends on proper setup, appropriate
inputs, and understanding its capabilities and limitations.

Thanks again, and happy automating!