Apify to Google Docs, competitor reports ready to share
Competitor research starts out simple. Then it turns into a messy pile of tabs, half-copied notes, and “final_v7” docs that still don’t feel client-ready.
This Apify report automation hits agency strategists first, but marketing managers building launch plans and consultants prepping audits feel it too. You need something you can ship, not another “research dump” that takes all afternoon to turn into a story.
This workflow pulls competitor data, runs a structured AI analysis, writes a clean report into Google Docs, then drops it into Slack for your team to review. Here’s what it does, why it matters, and how to make it yours.
How This Automation Works
The full n8n workflow, from trigger to final output:
n8n Workflow Template: Apify to Google Docs, competitor reports ready to share
flowchart LR
subgraph sg0["When clicking ‘Execute workflow’ Flow"]
direction LR
n0@{ icon: "mdi:play-circle", form: "rounded", label: "When clicking ‘Execute workf..", pos: "b", h: 48 }
n1["<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/httprequest.dark.svg' width='40' height='40' /></div><br/>Apify"]
n2["<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/code.svg' width='40' height='40' /></div><br/>Data Aggregation"]
n3@{ icon: "mdi:robot", form: "rounded", label: "The Report Generator", pos: "b", h: 48 }
n4@{ icon: "mdi:robot", form: "rounded", label: "The Strategic Analyst", pos: "b", h: 48 }
n5["<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/slack.svg' width='40' height='40' /></div><br/>Deliver Report to Team"]
n6@{ icon: "mdi:cog", form: "rounded", label: "Create Report", pos: "b", h: 48 }
n1 --> n2
n6 --> n5
n2 --> n4
n3 --> n6
n4 --> n3
n0 --> n1
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 n3,n4 ai
class n1 api
class n2 code
classDef customIcon fill:none,stroke:none
class n1,n2,n5 customIcon
The Problem: Competitor Research Takes Too Long to Turn Into a Deliverable
You can scrape competitor sites, skim their ads, read reviews, and gather positioning notes in an hour or two. The painful part is what comes next. Someone still has to stitch the raw info into a strategy you can defend, format it into something a client will actually read, and then route it to the team for review. It’s easy to miss details when you’re jumping between tools, and honestly, the “analysis” part often gets rushed because formatting and copying eat the clock.
It adds up fast. Here’s where it usually breaks down.
- Raw competitor notes live in too many places, so your final report ends up inconsistent from client to client.
- Copying findings into a Google Doc template takes about an hour per report, and small errors slip in when you’re tired.
- SWOT and audience insights get watered down because there’s no repeatable analysis structure.
- Internal review is slow since the team doesn’t see the report until you remember to send it.
The Solution: Apify Research In, Google Docs Report Out (Plus Slack Delivery)
This n8n workflow turns competitor research into a shareable report without you doing the glue work. You trigger it with a client business name and industry. Then it uses an HTTP request to pull external research data (typically from Apify actors you configure for scraping and discovery). Next, the workflow cleans and compiles the raw findings so the AI has something coherent to work with. Two OpenAI-powered agents handle the heavy thinking: one produces structured strategic analysis (messaging, audience, and a SWOT), and the next rewrites that analysis into a polished, persuasive report. Finally, n8n fills a Google Docs template with your placeholders and posts the finished doc to Slack so your team can review immediately.
The workflow starts with a manual launch in n8n, which keeps testing simple while you dial in your template. After data is scraped and normalized, the AI agents convert it into strategy and then into writing. The last mile is automated too: Google Docs becomes the deliverable, and Slack becomes the handoff.
What You Get: Automation vs. Results
| What This Workflow Automates | Results You’ll Get |
|---|---|
|
|
Example: What This Looks Like
Say you deliver 5 competitor reports per month for retainers. Manually, it’s easy to spend about 30 minutes gathering notes, another 60 minutes writing and formatting in Google Docs, then 10 minutes packaging and sending it to your team. Call it roughly 8 hours a month. With this workflow, you trigger the run in a minute or two, wait for the research and AI processing, and your Google Doc shows up in Slack ready to review. You’re mostly spending time on decisions, not assembly.
What You’ll Need
- n8n instance (try n8n Cloud free)
- Self-hosting option if you prefer (Hostinger works well)
- Apify for competitor scraping and discovery.
- OpenAI to analyze findings and write the report.
- Google Docs to generate a client-ready deliverable.
- Slack to deliver the finished report to your team.
- Apify API Key (get it from your Apify account settings).
Skill level: Intermediate. You’ll paste IDs/keys, map template placeholders, and do light troubleshooting if your scrape output changes.
Don’t want to set this up yourself? Talk to an automation expert (free 15-minute consultation).
How It Works
A manual launch kicks things off. You start the run in n8n and pass in the client’s business name and industry so the workflow knows what to research.
External research is pulled in. An HTTP Request node fetches competitor data (commonly from an Apify actor), and the workflow compiles it into a cleaner set of inputs so the AI isn’t guessing what’s important.
Two AI agents turn data into strategy. The first OpenAI agent produces structured analysis like messaging themes, audience takeaways, and a SWOT. The second agent transforms that analysis into a readable report, so it doesn’t sound like a pile of notes.
The deliverable is created and routed. n8n fills your Google Docs template using placeholders (for example, client name, industry, and report content), then posts the document to the right Slack channel for review.
You can easily modify the scraping target and the report structure to match your niche and your client expectations. See the full implementation guide below for customization options.
Step-by-Step Implementation Guide
Step 1: Configure the Manual Trigger
This workflow starts manually, and the Flowpast Branding sticky note is only for documentation.
- Add the Manual Launch Trigger node to your canvas.
- Leave Manual Launch Trigger parameters as default (no additional fields are required).
- (Optional) Keep Flowpast Branding for on-canvas documentation; it does not affect execution.
Step 2: Connect External Data Request
This step pulls external market data and hands it to the processing logic.
- Add the External Data Request node and connect it after Manual Launch Trigger.
- Configure the HTTP request details in External Data Request based on your data source (URL, method, and headers).
- Connect External Data Request to Compile Insights Logic.
Step 3: Set Up Processing and AI Analysis
These nodes transform raw data into strategic insights, then synthesize a report.
- Open Compile Insights Logic and add your data parsing or normalization logic.
- Connect Compile Insights Logic to Strategy Analysis Agent.
- Configure Strategy Analysis Agent with your preferred model and prompt for strategic analysis.
- Connect Strategy Analysis Agent to Report Synthesis Agent.
- Configure Report Synthesis Agent to summarize findings into a structured report format.
Credential Required: Connect your OpenAI credentials in both Strategy Analysis Agent and Report Synthesis Agent.
Step 4: Configure Output and Team Delivery
This step generates a document and posts it to your team channel.
- Connect Report Synthesis Agent to Generate Document Report.
- Set up Generate Document Report to create or update a Google Doc with the report content.
- Connect Generate Document Report to Post Team Report.
- Configure Post Team Report to send the document link or summary to your Slack channel.
Credential Required: Connect your Google Docs credentials in Generate Document Report.
Credential Required: Connect your Slack credentials in Post Team Report.
Step 5: Test and Activate Your Workflow
Verify the end-to-end path from data collection to reporting.
- Click Execute Workflow from Manual Launch Trigger to run a test.
- Confirm External Data Request returns data and Compile Insights Logic outputs structured items.
- Check that Strategy Analysis Agent and Report Synthesis Agent return coherent content.
- Verify a document is created in Generate Document Report and a Slack message is sent via Post Team Report.
- When satisfied, toggle the workflow to Active for production use.
Common Gotchas
- Google Docs OAuth credentials can expire or lack permission to access the template. If the document won’t generate, check the connected Google account and template sharing settings first.
- 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 an hour if your Google Docs template is already prepared.
No. You’ll mostly paste API keys, connect accounts, and map placeholders to your Google Docs template.
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 OpenAI API usage and any Apify actor costs tied to your scraping volume.
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, and you should. Most teams customize the Google Docs “Generate Document Report” step by changing the template placeholders and the fields you inject (like adding pricing notes or a “recommended positioning” section). You can also tweak the AI agent prompts so the report matches your tone, structure, and level of aggressiveness. If your Apify actor returns different fields, update the compile/cleanup logic so the Strategy Analysis Agent always receives the same input shape.
Usually it’s an expired or incorrect Apify API key, or the Actor ID is wrong. Confirm the actor runs successfully in Apify first, then update the key in n8n credentials and re-test the HTTP Request. If it works sometimes and fails in bursts, you may be hitting rate limits or the target site is blocking scraping, which means you’ll need to adjust the actor settings.
On self-hosted n8n, there’s no fixed execution limit (it mainly depends on your server). On n8n Cloud, your monthly execution cap depends on the plan. Practically, you can run this for dozens of reports a week as long as your Apify actor and OpenAI usage stay within budget.
Often, yes, because this workflow needs multi-step processing, branching logic, and “agent-style” AI generation that’s clunky in simpler tools. n8n also gives you the option to self-host, which is useful when you’re generating lots of reports and don’t want every run priced like a premium task. Zapier or Make can be fine if you only want “scrape something, send a message,” but once you care about repeatable report quality, you’ll want more control over prompts, data shaping, and templating. If you’re torn, Talk to an automation expert and you can sanity-check the best setup for your volume.
Once this is set up, competitor research stops being a “production task” and becomes a repeatable input to better strategy. The workflow handles the busywork so your team can focus on the parts clients actually pay for.
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.
