Apify + Google Docs, SERP based outlines for briefs
Competitor research is the quiet time-killer. You open 10 tabs, skim headings, copy notes into a doc, then realize half the “top results” were product pages, videos, or PDFs you can’t even use.
This SERP outline automation hits content marketers first, because briefs pile up fast. SEO specialists feel it during content sprints. And writers end up stuck staring at a blank doc when the “research” never turns into a usable structure.
This workflow turns a keyword into a clean, data-backed outline in Google Docs, then logs the request in Google Sheets so you can track what got briefed, when, and for whom.
How This Automation Works
The full n8n workflow, from trigger to final output:
n8n Workflow Template: Apify + Google Docs, SERP based outlines for briefs
flowchart LR
subgraph sg0["SEO Keyword Input Form Flow"]
direction LR
n0["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/form.svg' width='40' height='40' /></div><br/>SEO Keyword Input Form"]
n1@{ icon: "mdi:swap-vertical", form: "rounded", label: "Workflow Configuration", pos: "b", h: 48 }
n2@{ icon: "mdi:swap-horizontal", form: "rounded", label: "Google Search SERP", pos: "b", h: 48 }
n3@{ icon: "mdi:swap-horizontal", form: "rounded", label: "Filter Non-Article URLs", pos: "b", h: 48 }
n4@{ icon: "mdi:swap-horizontal", form: "rounded", label: "Scrape Article Headings", pos: "b", h: 48 }
n5@{ icon: "mdi:cog", form: "rounded", label: "Aggregate Competitor Data", pos: "b", h: 48 }
n6@{ icon: "mdi:robot", form: "rounded", label: "AI Content Structure Analysis", pos: "b", h: 48 }
n7@{ icon: "mdi:cog", form: "rounded", label: "Create Google Doc", pos: "b", h: 48 }
n8@{ icon: "mdi:database", form: "rounded", label: "Store Form Responses", pos: "b", h: 48 }
n2 --> n3
n0 --> n1
n0 --> n8
n1 --> n2
n3 --> n4
n4 --> n5
n5 --> n6
n6 --> n7
end
%% Styling
classDef trigger fill:#e8f5e9,stroke:#388e3c,stroke-width:2px
classDef ai fill:#e3f2fd,stroke:#1976d2,stroke-width:2px
classDef aiModel fill:#e8eaf6,stroke:#3f51b5,stroke-width:2px
classDef decision fill:#fff8e1,stroke:#f9a825,stroke-width:2px
classDef database fill:#fce4ec,stroke:#c2185b,stroke-width:2px
classDef api fill:#fff3e0,stroke:#e65100,stroke-width:2px
classDef code fill:#f3e5f5,stroke:#7b1fa2,stroke-width:2px
classDef disabled stroke-dasharray: 5 5,opacity: 0.5
class n0 trigger
class n6 ai
class n2,n3,n4 decision
class n8 database
classDef customIcon fill:none,stroke:none
class n0 customIcon
The Problem: SERP Research Turns Into Tab Chaos
Creating a “good” SEO brief usually means doing the same dance every time. Search the keyword. Open the top results. Pull out H1s, H2s, and H3s. Try to spot patterns. Then stitch it into an outline that a writer can actually follow. In theory, it’s straightforward. In practice, it’s messy, repetitive, and easy to get wrong when you’re rushing. One missed competitor angle can turn into a rewrite later, and honestly, that’s the expensive part.
It adds up fast. Here’s where it breaks down in real teams.
- Manual SERP review usually means 10–15 tabs open, and the “outline” ends up scattered across notes, docs, and chat messages.
- Non-article results slip in (YouTube, Amazon, PDFs), so you waste time extracting structure from pages you never wanted to analyze.
- Headings get copied inconsistently, which means your brief quality depends on who did the research that day.
- Nothing is logged cleanly, so you can’t answer basic questions like “Which keywords did we brief last week?” without digging.
The Solution: Turn SERPs Into Google Docs Briefs Automatically
This workflow automates the entire “research to outline” loop using Apify, OpenAI, Google Docs, and Google Sheets. You start by entering a target keyword and a quick note about the target audience in an n8n form. From there, Apify pulls the current top Google results for that query, then the workflow filters out obvious non-articles so your input data stays clean. Next, it visits each remaining competitor URL and extracts the page’s heading structure (H1 through H3) and basic metadata. Finally, OpenAI analyzes the combined structure to generate a practical outline based on what’s already ranking, and n8n creates a fresh Google Doc with the result. The request gets logged in Google Sheets for tracking and repeatability.
The workflow starts when you submit the n8n form with a keyword and audience. Apify handles SERP scraping and on-page extraction, then OpenAI turns those patterns into a ready-to-write outline. Google Docs receives the finished brief, while Google Sheets stores your request details so nothing disappears into “someone’s notes.”
What You Get: Automation vs. Results
| What This Workflow Automates | Results You’ll Get |
|---|---|
|
|
Example: What This Looks Like
Say you brief 5 articles a week. Manually, you might open 10 competitor pages per brief, spend maybe 10 minutes skimming each, then another 30 minutes turning notes into an outline. That’s about 2 hours per brief, or roughly 10 hours a week. With this workflow, you submit the form in about 2 minutes, wait while Apify and OpenAI do the heavy lifting (often around 10–15 minutes), and your Google Doc outline is ready. You get most of that week back.
What You’ll Need
- n8n instance (try n8n Cloud free)
- Self-hosting option if you prefer (Hostinger works well)
- Apify to scrape SERPs and competitor headings
- Google Docs to store the generated outline
- OpenAI API key (get it from your OpenAI dashboard)
Skill level: Intermediate. You’ll connect accounts, paste a Sheet ID, and adjust a couple settings like region and max results.
Don’t want to set this up yourself? Talk to an automation expert (free 15-minute consultation).
How It Works
Form submission trigger. You enter a target keyword and target audience in the built-in n8n form. That single input becomes the brief “job ticket” for everything that follows.
SERP scraping and cleanup. Apify fetches the top Google results for the keyword, then the workflow filters out non-article URLs (product pages, videos, PDFs) so you don’t pollute your analysis with the wrong page types.
Competitor structure extraction and AI outline generation. For each competitor article, Apify pulls the heading structure (H1 to H3) and related metadata. OpenAI reviews the combined patterns and generates a comprehensive outline that reflects what’s ranking, without copying any single competitor.
Google Docs output plus a tracking record. n8n creates a new Google Doc containing the outline, and logs the keyword (and other request details) in Google Sheets for reporting and reuse.
You can easily modify the country/region settings to match your market based on your needs. See the full implementation guide below for customization options.
Common Gotchas
- Google Docs and Google Sheets credentials can expire or need specific permissions. If things break, check the credential status inside n8n and confirm the connected Google account can create Docs and edit the target Sheet.
- If you’re using Wait nodes or external rendering, processing times vary. Bump up the wait duration if downstream nodes fail on empty responses.
- Default prompts in AI nodes are generic. Add your brand voice early or you’ll be editing outputs forever.
Frequently Asked Questions
About 30 minutes if your Apify, Google, and OpenAI accounts are ready.
No. You’ll connect credentials and edit a few fields like region and max results.
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 Apify usage and OpenAI API costs (usually a few cents per outline).
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.
Yes. You can change the region by editing the countryCode setting in the Workflow Configuration node, and you can adjust maxResults to analyze more (or fewer) competitors. Many teams also tweak the Filter Non-Article URLs step to exclude domains like wikipedia.org, or to remove specific publishers they don’t want influencing the outline. If you want a different outline style, swap the model or rewrite the system prompt in the AI Content Structure Analysis node.
Most of the time it’s an invalid or expired Apify token in your n8n credentials. It can also happen if your Apify account doesn’t have access to the Google Search Scraper or Cheerio Scraper actors, or if you hit usage limits while running larger batches. If failures look random, check the Apify run logs for the actor and confirm the workflow isn’t sending empty or malformed input after filtering.
On n8n Cloud Starter you can run thousands of executions a month, and self-hosting has no hard execution limit (your server is the real constraint). In practice, most teams comfortably generate a few dozen briefs a day as long as Apify and OpenAI usage limits are sized appropriately. The “speed limit” usually comes from scraping and page fetch time, not n8n.
Often, yes. n8n is better when you need branching logic (like filtering out non-articles), merging competitor data, and running multi-step processing without paying extra per path. It also gives you the option to self-host, which can matter a lot once you scale briefs across many keywords. Zapier or Make can be simpler for tiny workflows, but they get awkward when you need scraping actors, structured filtering, and larger payload handling. If you want help choosing, Talk to an automation expert.
Once this is running, briefs stop being a bottleneck. The workflow handles the repetitive research so you can spend your time on strategy and writing that actually ships.
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.
