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 keywords with metrics.
Keyword Ideas: Keyword ideas with metrics.
Autocomplete: Google autocomplete suggestions.
Subtopics: Generated subtopics for content planning.
Organic Results: Organic SERP data including domains, URLs, titles, and descriptions.
Benefits
Time-Saving: Automates repetitive tasks, reducing manual effort in keyword research.
Organized Data: Stores all data in a structured Google Sheet for easy access and analysis.
Actionable Insights: Provides detailed SEO metrics to guide content creation and optimization strategies.
Scalable and Reusable: Can be reused for different keywords by updating the input Google Sheet.
Technical Details
Nodes: Utilizes n8n nodes including manualTrigger, googleSheets, googleDrive, httpRequest, splitOut, set, and filter.
API Integration: Leverages DataForSEO API for real-time keyword and SERP data.
Credentials: Requires Google Sheets OAuth2 and Google Drive OAuth2 credentials, along with DataForSEO HTTP Basic Authentication.
Data Mapping: Uses set nodes to map API response fields to desired output formats, ensuring compatibility with Google Sheets.
Potential Enhancements
Add error handling for API failures or invalid inputs.
Include additional DataForSEO API endpoints for more granular data (e.g., competitor analysis).
Implement deduplication logic to avoid redundant keyword entries.
Add a scheduling node to run the workflow automatically at regular intervals.
This workflow is a powerful tool for SEO-driven content planning, providing a robust foundation for creating optimized blog content.
n8n Workflow: Comprehensive SEO Keyword Research & Analysis
This n8n workflow provides a framework for conducting comprehensive SEO keyword research and analysis, integrating with Google Sheets and potentially external APIs (like DataForSEO, though not explicitly configured in the provided JSON). It allows you to manage keyword lists, enrich them with data, and organize the results.
What it does
This workflow is designed to streamline the process of gathering and managing keyword data. While the specific external API calls (e.g., DataForSEO) are not fully defined in the provided JSON, the structure indicates a clear path for integration.
- Manual Trigger: The workflow is initiated manually, allowing you to control when the keyword research process begins.
- Google Sheets (Input): It's set up to read data from a Google Sheet, likely containing an initial list of keywords or parameters for research.
- Edit Fields (Set): This node is used to manipulate or transform the data retrieved from Google Sheets. This could involve formatting keywords, adding default values, or preparing data for API calls.
- HTTP Request: This node is a placeholder for making external API calls. In a full SEO workflow, this would be configured to query a service like DataForSEO for keyword metrics (search volume, CPC, competition, etc.).
- Split Out: After receiving data from the HTTP Request (or other sources), this node would typically split a single item containing multiple data points (e.g., an array of keyword results) into individual items, allowing subsequent nodes to process each keyword separately.
- Filter: This node enables conditional processing of keywords. You might filter keywords based on certain criteria (e.g., minimum search volume, specific intent, excluding branded terms).
- Google Sheets (Output): Processed and enriched keyword data can then be written back to a Google Sheet, allowing for organized storage and further analysis.
- Google Drive: This node suggests the capability to interact with Google Drive, perhaps to save reports, export data, or manage files related to the keyword research.
- Sticky Note: Used for documentation within the workflow, providing context or instructions for specific nodes.
Prerequisites/Requirements
To use this workflow, you will need:
- n8n Instance: A running n8n instance.
- Google Account: A Google account with access to Google Sheets and Google Drive.
- Google Sheets Credentials: Configured Google Sheets credentials in n8n.
- Google Drive Credentials: Configured Google Drive credentials in n8n.
- External API Credentials (Optional but Recommended): If you intend to integrate with SEO tools like DataForSEO, you will need an API key and credentials for that service. (Note: The HTTP Request node in the provided JSON is generic and would require specific configuration for any external API).
Setup/Usage
- Import the Workflow:
- Download the provided JSON file.
- In your n8n instance, click on "Workflows" in the left sidebar.
- Click "New" and then "Import from JSON".
- Paste the JSON content or upload the file.
- Configure Credentials:
- Locate the "Google Sheets" and "Google Drive" nodes.
- Click on each node and select or create your Google OAuth2 credentials. Ensure they have the necessary permissions for Sheets and Drive.
- If integrating with an external SEO API, configure the "HTTP Request" node with the appropriate URL, headers (for API key), and body (for keyword queries).
- Customize Google Sheets:
- Update the "Google Sheets" nodes to point to your specific spreadsheet and sheet names for input and output.
- Adjust Logic (Optional):
- Modify the "Edit Fields (Set)" node to transform data as needed.
- Configure the "Filter" node with your desired conditions for keyword filtering.
- Execute the Workflow:
- Click the "Execute Workflow" button on the "Manual Trigger" node to run the workflow.
Related Templates
Track competitor SEO keywords with Decodo + GPT-4.1-mini + Google Sheets
This workflow automates competitor keyword research using OpenAI LLM and Decodo for intelligent web scraping. Who this is for SEO specialists, content strategists, and growth marketers who want to automate keyword research and competitive intelligence. Marketing analysts managing multiple clients or websites who need consistent SEO tracking without manual data pulls. Agencies or automation engineers using Google Sheets as an SEO data dashboard for keyword monitoring and reporting. What problem this workflow solves Tracking competitor keywords manually is slow and inconsistent. Most SEO tools provide limited API access or lack contextual keyword analysis. This workflow solves that by: Automatically scraping any competitor’s webpage with Decodo. Using OpenAI GPT-4.1-mini to interpret keyword intent, density, and semantic focus. Storing structured keyword insights directly in Google Sheets for ongoing tracking and trend analysis. What this workflow does Trigger — Manually start the workflow or schedule it to run periodically. Input Setup — Define the website URL and target country (e.g., https://dev.to, france). Data Scraping (Decodo) — Fetch competitor web content and metadata. Keyword Analysis (OpenAI GPT-4.1-mini) Extract primary and secondary keywords. Identify focus topics and semantic entities. Generate a keyword density summary and SEO strength score. Recommend optimization and internal linking opportunities. Data Structuring — Clean and convert GPT output into JSON format. Data Storage (Google Sheets) — Append structured keyword data to a Google Sheet for long-term tracking. Setup Prerequisites If you are new to Decode, please signup on this link visit.decodo.com n8n account with workflow editor access Decodo API credentials OpenAI API key Google Sheets account connected via OAuth2 Make sure to install the Decodo Community node. Create a Google Sheet Add columns for: primarykeywords, seostrengthscore, keyworddensity_summary, etc. Share with your n8n Google account. Connect Credentials Add credentials for: Decodo API credentials - You need to register, login and obtain the Basic Authentication Token via Decodo Dashboard OpenAI API (for GPT-4o-mini) Google Sheets OAuth2 Configure Input Fields Edit the “Set Input Fields” node to set your target site and region. Run the Workflow Click Execute Workflow in n8n. View structured results in your connected Google Sheet. How to customize this workflow Track Multiple Competitors → Use a Google Sheet or CSV list of URLs; loop through them using the Split In Batches node. Add Language Detection → Add a Gemini or GPT node before keyword analysis to detect content language and adjust prompts. Enhance the SEO Report → Expand the GPT prompt to include backlink insights, metadata optimization, or readability checks. Integrate Visualization → Connect your Google Sheet to Looker Studio for SEO performance dashboards. Schedule Auto-Runs → Use the Cron Node to run weekly or monthly for competitor keyword refreshes. Summary This workflow automates competitor keyword research using: Decodo for intelligent web scraping OpenAI GPT-4.1-mini for keyword and SEO analysis Google Sheets for live tracking and reporting It’s a complete AI-powered SEO intelligence pipeline ideal for teams that want actionable insights on keyword gaps, optimization opportunities, and content focus trends, without relying on expensive SEO SaaS tools.
By Ranjan DailataGenerate song lyrics and music from text prompts using OpenAI and Fal.ai Minimax
Spark your creativity instantly in any chat—turn a simple prompt like "heartbreak ballad" into original, full-length lyrics and a professional AI-generated music track, all without leaving your conversation. 📋 What This Template Does This chat-triggered workflow harnesses AI to generate detailed, genre-matched song lyrics (at least 600 characters) from user messages, then queues them for music synthesis via Fal.ai's minimax-music model. It polls asynchronously until the track is ready, delivering lyrics and audio URL back in chat. Crafts original, structured lyrics with verses, choruses, and bridges using OpenAI Submits to Fal.ai for melody, instrumentation, and vocals aligned to the style Handles long-running generations with smart looping and status checks Returns complete song package (lyrics + audio link) for seamless sharing 🔧 Prerequisites n8n account (self-hosted or cloud with chat integration enabled) OpenAI account with API access for GPT models Fal.ai account for AI music generation 🔑 Required Credentials OpenAI API Setup Go to platform.openai.com → API keys (sidebar) Click "Create new secret key" → Name it (e.g., "n8n Songwriter") Copy the key and add to n8n as "OpenAI API" credential type Test by sending a simple chat completion request Fal.ai HTTP Header Auth Setup Sign up at fal.ai → Dashboard → API Keys Generate a new API key → Copy it In n8n, create "HTTP Header Auth" credential: Name="Fal.ai", Header Name="Authorization", Header Value="Key [Your API Key]" Test with a simple GET to their queue endpoint (e.g., /status) ⚙️ Configuration Steps Import the workflow JSON into your n8n instance Assign OpenAI API credentials to the "OpenAI Chat Model" node Assign Fal.ai HTTP Header Auth to the "Generate Music Track", "Check Generation Status", and "Fetch Final Result" nodes Activate the workflow—chat trigger will appear in your n8n chat interface Test by messaging: "Create an upbeat pop song about road trips" 🎯 Use Cases Content Creators: YouTubers generating custom jingles for videos on the fly, streamlining production from idea to audio export Educators: Music teachers using chat prompts to create era-specific folk tunes for classroom discussions, fostering interactive learning Gift Personalization: Friends crafting anniversary R&B tracks from shared memories via quick chats, delivering emotional audio surprises Artist Brainstorming: Songwriters prototyping hip-hop beats in real-time during sessions, accelerating collaboration and iteration ⚠️ Troubleshooting Invalid JSON from AI Agent: Ensure the system prompt stresses valid JSON; test the agent standalone with a sample query Music Generation Fails (401/403): Verify Fal.ai API key has minimax-music access; check usage quotas in dashboard Status Polling Loops Indefinitely: Bump wait time to 45-60s for complex tracks; inspect fal.ai queue logs for bottlenecks Lyrics Under 600 Characters: Tweak agent prompt to enforce fuller structures like [V1][C][V2][B][C]; verify output length in executions
By Daniel NkenchoAuto-reply & create Linear tickets from Gmail with GPT-5, gotoHuman & human review
This workflow automatically classifies every new email from your linked mailbox, drafts a personalized reply, and creates Linear tickets for bugs or feature requests. It uses a human-in-the-loop with gotoHuman and continuously improves itself by learning from approved examples. How it works The workflow triggers on every new email from your linked mailbox. Self-learning Email Classifier: an AI model categorizes the email into defined categories (e.g., Bug Report, Feature Request, Sales Opportunity, etc.). It fetches previously approved classification examples from gotoHuman to refine decisions. Self-learning Email Writer: the AI drafts a reply to the email. It learns over time by using previously approved replies from gotoHuman, with per-classification context to tailor tone and style (e.g., different style for sales vs. bug reports). Human Review in gotoHuman: review the classification and the drafted reply. Drafts can be edited or retried. Approved values are used to train the self-learning agents. Send approved Reply: the approved response is sent as a reply to the email thread. Create ticket: if the classification is Bug or Feature Request, a ticket is created by another AI agent in Linear. Human Review in gotoHuman: How to set up Most importantly, install the gotoHuman node before importing this template! (Just add the node to a blank canvas before importing) Set up credentials for gotoHuman, OpenAI, your email provider (e.g. Gmail), and Linear. In gotoHuman, select and create the pre-built review template "Support email agent" or import the ID: 6fzuCJlFYJtlu9mGYcVT. Select this template in the gotoHuman node. In the "gotoHuman: Fetch approved examples" http nodes you need to add your formId. It is the ID of the review template that you just created/imported in gotoHuman. Requirements gotoHuman (human supervision, memory for self-learning) OpenAI (classification, drafting) Gmail or your preferred email provider (for email trigger+replies) Linear (ticketing) How to customize Expand or refine the categories used by the classifier. Update the prompt to reflect your own taxonomy. Filter fetched training data from gotoHuman by reviewer so the writer adapts to their personalized tone and preferences. Add more context to the AI email writer (calendar events, FAQs, product docs) to improve reply quality.
By gotoHuman