🔓 Unlock all 10,000+ workflows & prompts free Join Newsletter →
✅ Full access unlocked — explore all 10,000 AI workflow and prompt templates Browse Templates →
Home › n8n › Workflow
January 22, 2026

DataForSEO + Google Sheets: keyword research done

DataForSEO + Google Sheets: keyword research done - n8n workflow automation template
Lisa Granqvist Partner Workflow Automation Expert
DataForSEO + Google Sheets: keyword research done - n8n workflow automation template
Get a free AI assessment → Get a free AI assessment → ⬇️ Use template

Your keyword research shouldn’t live in five browser tabs, two CSV exports, and a “final-final” spreadsheet you’re afraid to touch. But that’s how it usually goes. One more manual export, one more copy-paste, one more broken column.

SEO managers feel it when they need fast SERP intel for a content plan. Content leads run into it when writers ask for “just a few more keyword ideas.” And if you run an agency, you’re probably rebuilding the same research workbook for every client. This DataForSEO Sheets automation turns that mess into a clean, repeatable process.

You’ll see what the workflow pulls (related keywords, suggestions, keyword ideas, autocomplete, subtopics, and SERP/PAA), how it organizes everything in Google Sheets, and where the real time savings come from.

How This Automation Works

The full n8n workflow, from trigger to final output:

n8n Workflow Template: DataForSEO + Google Sheets: keyword research done

The Problem: Keyword Research Turns Into Spreadsheet Chaos

Keyword research sounds simple until you try to do it “properly.” You pull related keywords from one place, suggestions from another, then you still need autocomplete, People Also Ask, and a quick SERP gut-check. Now you’re exporting CSVs, pasting into Sheets, cleaning columns, deduplicating, and trying to remember which tab contains the version you trust. And if you’re researching multiple seed keywords, you repeat the whole routine over and over. It’s not hard work. It’s just endless.

The friction compounds. Here’s where it breaks down in real teams.

  • Exports come in different formats, so your “master sheet” becomes a one-off formatting project every time.
  • Manual copying makes errors sneak in, especially for CPC, competition, and keyword difficulty fields.
  • SERP insights and “People Also Ask” questions are often skipped because pulling them is a hassle.
  • Research gets stuck in someone’s laptop folder instead of living in a shared, organized Google Drive location.

The Solution: DataForSEO Research Sent Straight Into a Structured Sheet

This n8n workflow runs your keyword research like a mini pipeline. You start with a simple input sheet (primary keyword, location, language). When you launch the workflow, it creates a brand-new Google Sheet named with today’s date, builds out a set of tabs (master, related keywords, keyword ideas, suggestions, autocomplete, subtopics, SERP, content), then moves that sheet into a dedicated Google Drive folder so it’s easy to find later. From there, it calls multiple DataForSEO endpoints and collects everything you’d normally assemble by hand: related keyword lists, suggestions, keyword ideas, autocomplete queries, subtopics, plus SERP results including “People Also Ask.” Finally, n8n maps the responses into consistent columns and appends rows into the right tabs.

The workflow starts on-demand via a manual trigger, so you run it when you’re planning content. DataForSEO pulls the datasets, n8n splits the responses into individual items, and Google Sheets becomes the destination for every clean, formatted row. You end with a research workbook you can hand to a writer (or import into a briefing system) without apologizing first.

What You Get: Automation vs. Results

Example: What This Looks Like

Say you research 10 seed keywords for a new blog cluster. Manually, you might pull 6 datasets (related keywords, suggestions, ideas, autocomplete, subtopics, plus SERP/PAA), and spend maybe 10 minutes per dataset per seed keyword once you include exporting and cleaning. That’s roughly 10 hours of busywork. With this workflow, you update one input sheet, click “Test workflow,” and wait while DataForSEO fills a dated workbook. Your “work” is mostly review and prioritization, not formatting rows.

What You’ll Need

  • n8n instance (try n8n Cloud free)
  • Self-hosting option if you prefer (Hostinger works well)
  • Google Sheets to store inputs and research outputs.
  • Google Drive to file the generated workbook in a folder.
  • DataForSEO credentials (get HTTP Basic Auth details in your DataForSEO dashboard)

Skill level: Intermediate. You’ll connect accounts, paste credentials, and confirm the right Sheet IDs and folder location.

Don’t want to set this up yourself? Talk to an automation expert (free 15-minute consultation).

How It Works

You launch it when you’re ready. The workflow is triggered manually (click “Test workflow”), which is perfect for content planning sessions and ad-hoc research requests.

Your input sheet becomes the brief. n8n reads primary keywords along with location and language from a Google Sheet, so you’re not editing nodes every time you change a target market.

DataForSEO pulls everything in one run. The workflow calls multiple DataForSEO endpoints to fetch related keywords, suggestions, keyword ideas, autocomplete, subtopics, and SERP results. It then splits large responses into individual rows, maps fields like volume, CPC, competition, difficulty, and item types, and filters SERP data so People Also Ask doesn’t get mixed into organic results.

Google Sheets becomes the single destination. Each dataset is appended into both a master tab and a dedicated tab (related, ideas, suggested, autocomplete, subtopics, SERP details), and the whole workbook is moved into a specific Google Drive folder for neat storage.

You can easily modify the sheet tabs and which fields you save to match your reporting style. See the full implementation guide below for customization options.

Step-by-Step Implementation Guide

Step 1: Configure the Manual Trigger

This workflow starts manually to pull a keyword seed and generate multiple research outputs.

  1. Add the Manual Launch Trigger node as the starting trigger.
  2. Keep the default settings (no parameters required).
  3. Connect Manual Launch Trigger to Retrieve Sheet Data.

Tip: Use the manual trigger for testing before enabling scheduled runs later.

Step 2: Connect Google Sheets Inputs and File Creation

These nodes read the input keyword data and create a new worksheet file for results.

  1. Open Retrieve Sheet Data and set Document to your source spreadsheet (replace [YOUR_ID]).
  2. Set Sheet Name to the list value gid=0 (Sheet1).
  3. Credential Required: Connect your googleSheetsOAuth2Api credentials to Retrieve Sheet Data.
  4. Open Create Worksheet File and set Title to ={{ $now.format('yyyy-MM-dd') }}-seo pro.
  5. Set Resource to spreadsheet, and confirm the sheets list includes keyword, SERP, Content, related keyword, keyword ideas, suggested keyword, sub topics, and auto complete.
  6. Credential Required: Connect your googleSheetsOAuth2Api credentials to Create Worksheet File.

⚠️ Common Pitfall: Ensure the source sheet contains columns named primary keyword, location name, and language name—they are referenced throughout the workflow.

Step 3: Configure Google Drive File Placement

The new spreadsheet is moved into a target Drive folder before data collection begins.

  1. Open Move Drive File and set Operation to move.
  2. Set File ID to ={{ $json.spreadsheetId }} so it moves the newly created spreadsheet.
  3. Select the destination Folder (replace [YOUR_ID]).
  4. Credential Required: Connect your googleDriveOAuth2Api credentials to Move Drive File.

Tip: Keep the Drive folder dedicated to workflow outputs for easier reporting and sharing.

Step 4: Configure DataForSEO HTTP Requests (Parallel Execution)

After the file is moved, the workflow fan-outs into multiple DataForSEO calls that run simultaneously.

  1. Confirm that Move Drive File outputs to Fetch Related Keywords, Fetch Keyword Suggestions, Fetch Keyword Ideas, Fetch Autocomplete, Generate Subtopics, and Fetch SERP Results in parallel.
  2. In Fetch Related Keywords, set URL to https://api.dataforseo.com/v3/dataforseo_labs/google/related_keywords/live and confirm the JSON Body uses {{ $('Retrieve Sheet Data').item.json['primary keyword'] }}, {{ $('Retrieve Sheet Data').item.json['location name'] }}, and {{ $('Retrieve Sheet Data').item.json['language name'] }}.
  3. Credential Required: Connect your httpBasicAuth credentials to Fetch Related Keywords (and optionally httpHeaderAuth if your API requires it).
  4. Repeat the same input mapping for Fetch Keyword Suggestions, Fetch Keyword Ideas, Fetch Autocomplete, and Generate Subtopics, using their respective URLs.
  5. Credential Required: Connect your httpBasicAuth credentials to all DataForSEO HTTP nodes (Fetch Keyword Suggestions, Fetch Keyword Ideas, Fetch Autocomplete, Generate Subtopics, Fetch SERP Results).

⚠️ Common Pitfall: Update Fetch SERP Results URL from https://api.dataforseo.[CONFIGURE_YOUR_API_KEY] to your live endpoint before testing.

Step 5: Configure Split and Mapping for Keyword Outputs

Each API response is expanded and mapped into structured fields before writing to sheets.

  1. For related keywords, set Expand Related Items Field to Split Out to tasks[0].result[0].items, then map with Map Related Metrics using expressions like ={{ $('Retrieve Sheet Data').item.json['primary keyword'] }} and ={{ $json.keyword_data.keyword_info.search_volume }}.
  2. For suggestions and ideas, ensure Expand Suggestions and Expand Idea Items also split tasks[0].result[0].items, then map with Map Suggested Fields and Map Idea Fields (e.g., ={{ $json.keyword_info.cpc }} and ={{ $json.search_intent_info.main_intent }}).
  3. For autocomplete, set Expand Autocomplete to split tasks[0].result[0].items and map with Map Autocomplete Fields, including ={{ $json.suggestion }}.
  4. For subtopics, set Expand Subtopics Field to Split Out to tasks[0].result[0].sub_topics and map with Map Subtopic Fields using ={{ $json.sub_topics }}.

Tip: Keep the field names consistent across Set nodes to avoid mismatches in your sheet column mapping.

Step 6: Configure SERP Parsing and Filters (Parallel Branches)

SERP results are expanded, filtered into two types, and then mapped to different outputs.

  1. Set Expand SERP Items Field to Split Out to tasks[0].result[0].items.
  2. Confirm that Expand SERP Items outputs to both Filter PAA Type and Filter Organic Type in parallel.
  3. In Filter PAA Type, set the condition to ={{ $json.type }} equals people_also_ask.
  4. In Filter Organic Type, set the condition to ={{ $json.type }} equals organic.
  5. Map PAA details through Expand SERP Details (split items) → Map SERP Detail using fields like ={{ $json.expanded_element[0].description }}.
  6. Map organic results through Map SERP Fields using ={{ $json.url }}, ={{ $json.domain }}, ={{ $json.title }}, and ={{ $json.description }}.

⚠️ Common Pitfall: The Map SERP Fields node sets a fixed type value people_also_ask. Adjust if you need a different label for organic results.

Step 7: Configure Google Sheets Outputs (Master + Detailed Sheets)

The workflow appends each dataset to both a master sheet and its specialized sheet.

  1. For related keywords, ensure Map Related Metrics feeds Append Related Master then Append Related Sheet.
  2. For suggestions, ideas, autocomplete, and subtopics, confirm the chains: Map Suggested Fields → Append Suggestions Master → Append Suggested Sheet, Map Idea Fields → Append Ideas Master → Append Ideas Sheet, Map Autocomplete Fields → Append Autocomplete Master → Append Autocomplete Sheet, and Map Subtopic Fields → Append Subtopics Master → Append Subtopics Sheet.
  3. For SERP outputs, confirm Map SERP Fields → Append SERP Master and Map SERP Detail → Append SERP Details.
  4. Credential Required: Connect your googleSheetsOAuth2Api credentials to all Google Sheets append nodes (14+ nodes handle master sheets and output tabs).

Tip: Use the same destination spreadsheet ID across append nodes to keep all outputs in one report file.

Step 8: Test and Activate Your Workflow

Run the workflow end-to-end to confirm all sheets populate correctly before enabling it.

  1. Click Execute Workflow while Manual Launch Trigger is selected.
  2. Verify that a new spreadsheet is created with the title format YYYY-MM-DD-seo pro and moved to your Drive folder.
  3. Check that each output tab (related keywords, keyword ideas, suggested keyword, sub topics, auto complete, SERP) contains rows appended by the corresponding Append nodes.
  4. When the test succeeds, toggle the workflow to Active for production use.
🔒

Unlock Full Step-by-Step Guide

Get the complete implementation guide + downloadable template

Common Gotchas

  • Google Sheets credentials can expire or need specific permissions. If things break, check the Google connection in n8n’s Credentials first, then confirm the sheet is shared with the right account.
  • If you’re using Wait nodes or external rendering, processing times vary. Bump up the wait duration if downstream nodes fail on empty responses.
  • DataForSEO authentication failures are usually basic auth formatting or an account restriction. Re-check username/password in the HTTP Request nodes and look at the DataForSEO response body for rate-limit or permission messages.

Related Workflows

If you like the same research output but your team lives in Airtable instead of spreadsheets, DataForSEO + Airtable: keyword research, organized is a natural partner for building a searchable keyword database.

When you’re doing ongoing SEO for a site and want “we checked this before” visibility, DataForSEO to Google Sheets, keyword history built helps you log research over time instead of treating every run like a one-off.

For agencies that package research into deliverables, DataForSEO to Google Sheets, keyword packs ready is great when you want tidy “topic packs” you can hand to clients or writers.

Need to turn research into briefs and approvals quickly? NocoDB + Slack, keyword briefs ready to publish is a strong follow-up once your Sheets workbook becomes a publishing pipeline.

Finally, if your team relies on Semrush for metrics and wants a similar spreadsheet output, Semrush to Google Sheets, keyword metrics logged pairs well for cross-checking volume and difficulty across providers.


Quick reference:

Frequently Asked Questions

How long does it take to set up this DataForSEO Sheets automation automation?

About an hour if your Google and DataForSEO accounts are ready.

Do I need coding skills to automate DataForSEO Sheets automation?

No. You will mostly connect accounts and paste API credentials. The “hard part” is just confirming your sheet tabs and columns match the workflow’s mappings.

Is n8n free to use for this DataForSEO Sheets automation workflow?

Yes. n8n has a free self-hosted option and a free trial on n8n Cloud. Cloud plans start at $20/month for higher volume. You’ll also need to factor in DataForSEO API usage costs (it depends on endpoints and volume).

Where can I host n8n to run this automation?

Two options: n8n Cloud (managed, easiest setup) or self-hosting on a VPS. For self-hosting, Hostinger VPS is affordable and handles n8n well. Self-hosting gives you unlimited executions but requires basic server management.

Can I customize this DataForSEO Sheets automation workflow for a different workbook layout?

Yes, but keep the logic intact. You can rename or remove tabs when you create the worksheet file, then update the “append to sheet” actions so they write to your new tab names. Common tweaks include adding a “Cluster” column in the master tab, saving only the top 20 related keywords per seed, and storing People Also Ask questions in a dedicated content-brief tab.

Why is my Google Sheets connection failing in this workflow?

Usually it’s an expired Google OAuth session or the workflow is pointing at a sheet the connected account can’t access. Reconnect Google Sheets in n8n, then confirm the input sheet (“SEO PRO”) and the destination spreadsheet permissions are correct. If the sheet was created but rows aren’t writing, the tab names often don’t match what the append nodes expect.

How many keywords can this DataForSEO Sheets automation automation handle?

Practically, dozens per run for most small teams, and you can scale further by running in batches and keeping an eye on DataForSEO rate limits.

Is this DataForSEO Sheets automation automation better than using Zapier or Make?

Often, yes, because this workflow isn’t a simple two-step “send data from A to B.” You’re calling multiple endpoints, splitting big responses into rows, filtering SERP item types, and writing to multiple tabs. n8n handles that kind of branching cleanly, and self-hosting avoids per-task pricing when you scale up. Zapier or Make can still work if you keep the scope narrow (one endpoint, one sheet tab). If you want the full workbook approach without duct tape, n8n is the more comfortable fit. Talk to an automation expert if you want help choosing.

Once this is in place, keyword research stops being a recurring cleanup project. You press run, get a structured workbook, and spend your time on decisions that actually move rankings.

Need Help Setting This Up?

Our automation experts can build and customize this workflow for your specific needs. Free 15-minute consultation—no commitment required.

Talk to Automation Expert →

Lisa Granqvist

Workflow Automation Expert

Expert in workflow automation and no-code tools.

×

Use template

Get instant access to this n8n workflow Json file

Copy and import json workflow into your n8n workflow

💬
Get a free quote today!
Get a free quote today!

Tell us what you need and we'll get back to you within one working day.

Get a free quote today!
Get a free quote today!

Tell us what you need and we'll get back to you within one working day.