Skip to main content

​
Automated Workflow Guide

Manual keyword research is a trap. Copy-pasting from Answer the Public into Excel is not a scalable strategy. In this guide, we’ll build a Programmatic Content Pipeline that automates the journey from “Keyword Idea” to “Content Brief”.

​
The Stack

  • Source: Apify Actor (Answer the Public Scraper)
  • Orchestration: Make.com (formerly Integromat) or n8n
  • Storage: Airtable or Google Sheets
  • Generation: OpenAI (GPT-4)

​
Step 1: The Trigger

Your workflow starts with a list of seed keywords.
  • Input: A Google Sheet column with broad topics (e.g., “CRM”, “Email Marketing”).
  • Trigger: “Watch Rows” module in Make/n8n.

​
Step 2: Data Extraction

Instead of visiting the ATP website, your workflow calls the Apify API. 
// Apify Actor Input
{
  "keywords": ["{{seed_keyword}}"],
  "country": "us"
}
The Actor spins up, scrapes the data, and returns a JSON array of questions.

​
Step 3: Filtering & Clustering

Raw data needs cleaning. Use a filter in your workflow to keep only high-intent questions:
  • Contains “how to”
  • Contains “best”
  • Contains “vs”
Pro Tip: Use a text classifier (like GPT-3.5-turbo) to tag keywords by intent (Informational, Commercial, Transactional).

​
Step 4: Brief Generation

Pass the filtered questions to GPT-4 to generate a content brief. Prompt:
“You are an SEO strategist. Based on these user questions: , create a comprehensive article outline for ''. Include H2s, H3s, and key talking points.”

​
Step 5: Output

Save the generated brief to your CMS (WordPress, Ghost) as a draft, or to a Notion Kanban board for your writers.

​
The Result

You now have a system that turns a single keyword into a ready-to-write brief without human intervention.
  • Time Saved: 2-3 hours per article.
  • Consistency: Every brief is data-backed.
  • Scale: Run this for 100 keywords overnight.

Start Automating

Get the Apify Actor to power this workflow.