Workflow Library
← LibraryPricingLog in
📝 Content & PublishingAdvanced● Active🧠 AI-powered

Part 5 - Keyword Research, Outline & First Article Draft

A 60-step content & publishing automation, triggered by webhook, error handler, connecting Google Sheets, Google Gemini, Webhook, Perplexity, WordPress, HTTP / REST API and more, with built-in AI reasoning.

⬇ Download workflow JSON
💡

What this does for your business

In plain terms: this writes and publishes content for you. It uses AI to understand and generate content, so it handles judgement-style work, not just moving data. It runs whenever it receives a request or form submission, creates the piece, and pushes it to Google Sheets, Google Gemini, Perplexity, WordPress — replacing hours of manual writing and posting.

60
Nodes
10
Integrations
61
Connections
Webhook, Error handler
Trigger

🚀 Deploy this workflow

Deploy this automation in minutes

Log in and we'll walk you through every key step by step, then deploy it for you.

Get started free Log in

🏗️ Architecture diagram

The real node graph exported from n8n — triggers (green), AI nodes (violet), services and logic — laid out as they run.

•Get Business DatadataTable•get_business_DatadataTableTool🧠Get_business_ranked_K…toolWorkflow•get_eeat_citationsdataTableTool📊Update ProcessinggoogleSheets•SessioN Data 👀set✨Outline CreatorgoogleGemini🔗Sheets Webhookwebhook•Filter Actionfilter🔎online_searchperplexityTool🧠serp_searchtoolWorkflow🧠suggested_keywordstoolWorkflow✨2.5 FlashlmChatGoogleGemini✨Keyword StrategistgoogleGemini•Article Dataset•HTML Formatcode✨Generate an imagegoogleGemini📝Create a postwordpress🌐Upload ImagehttpRequest🌐Set Featured ImagehttpRequest🌐Update image metahttpRequest•Prepare Wordpressset🧠Article Metadata Gene…agent•Convert to WebPeditImage•Get WP Dataset•Get Topic Dataset•eeat_agentagentTool•mergemerge•get_business_datadataTableTool•get_internal_LinksdataTableTool📊Research LinkgoogleSheets📊Outline LinkgoogleSheets✨Content CreatorgoogleGemini🧠get_business_ranked_k…toolWorkflow🧠think_tooltoolThink🧠Think_tooltoolThink🧠keyword_overviewtoolWorkflow•Arrange by sectionscode•Get First Draftset•Get Researchset•HTMLcode🗂️Create ResearchgoogleDrive•Get Outlineset•htmlcode🗂️Create OutlinegoogleDrive•<-noOp🧠Think_TooltoolThink🧠ThinktoolThink🧠OutputoutputParserStructu…📊Insert Blog DatagoogleSheets▶Error TriggererrorTrigger•Get Articleset🗂️Create ArticlegoogleDrive•Convert to HTMLcode🧠Anthropic Chat ModellmChatAnthropic🧠AI Agentagent🧠OpenAI Chat ModellmChatOpenAi•Get a post in Wordpre…wordpressTool•Update a post in Word…wordpressTool📧Send a messagegmail

⚙️ How it works

  1. get_business_Data · dataTableTool
  2. Get_business_ranked_Keywords · toolWorkflow
  3. get_eeat_citations · dataTableTool
  4. Sheets Webhook · webhook
  5. online_search · perplexityTool
  6. serp_search · toolWorkflow
  7. suggested_keywords · toolWorkflow
  8. 2.5 Flash · lmChatGoogleGemini
  9. get_business_data · dataTableTool
  10. get_internal_Links · dataTableTool
  11. get_business_ranked_keywords · toolWorkflow
  12. think_tool · toolThink
  13. Think_tool · toolThink
  14. keyword_overview · toolWorkflow

💼 Business analysis

🎯

Business use case

An end-to-end content production line — research, generation, formatting and publishing (Google Sheets, Google Gemini, Webhook, Perplexity, WordPress, HTTP / REST API and more) — that lets one operator ship the output of a whole content team. It turns a keyword or brief into a published, SEO-ready asset.

📈

Market need

Content is the #1 demand-gen channel and the most time-expensive. Automating the pipeline collapses cost-per-article from hours to minutes.

💰

Market value

Content pipelines replace retainers of $1,500–$8,000/mo. Sold as a service or template, they carry strong recurring value tied to output volume.

🧩 Integrations & stack

📊Google Sheets✨Google Gemini🔗Webhook🔎Perplexity📝WordPress🌐HTTP / REST API🗂️Google Drive🧠Anthropic Claude🧠OpenAI (LLM)📧Gmail
Node typesdataTable, dataTableTool, toolWorkflow, googleSheets, set, googleGemini, webhook, filter, perplexityTool, lmChatGoogleGemini, code, wordpress, httpRequest, agent, editImage, agentTool, merge, toolThink, googleDrive, noOp, outputParserStructured, errorTrigger, lmChatAnthropic, lmChatOpenAi, wordpressTool, gmailWorkflow IDV59OloOWPmBojUQP
⬇ Download workflow JSON ← Back to library