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

Part 5 - Keyword Research, Outline & First Article Draft thetechabc.com

A 61-step content & publishing automation, triggered by error handler, webhook, connecting Google Sheets, Google Gemini, Perplexity, WordPress, HTTP / REST API, Google Drive 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.

61
Nodes
10
Integrations
62
Connections
Error handler, Webhook
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_ranked_K…toolWorkflow•get_eeat_citationsdataTableTool📊Update ProcessinggoogleSheets•SessioN Data 👀set✨Outline CreatorgoogleGemini•Filter Actionfilter🔎online_searchperplexityTool🧠serp_searchtoolWorkflow🧠suggested_keywordstoolWorkflow✨Keyword StrategistgoogleGemini•Article Dataset•HTML Formatcode✨Generate an imagegoogleGemini📝Create a postwordpress🌐Upload ImagehttpRequest🌐Set Featured ImagehttpRequest🌐Update image metahttpRequest🧠Article Metadata Gene…agent•Convert to WebPeditImage•Get WP Dataset•Get Topic Dataset•eeat_agentagentTool•mergemerge•get_business_datadataTableTool📊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📧Send a messagegmail•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🌐HTTP RequesthttpRequest▶Error TriggererrorTrigger•get_internal_LinksdataTableTool•Prepare Wordpressset✨2.5 FlashlmChatGoogleGemini🔗Sheets Webhookwebhook•get_business_DatadataTableTool

⚙️ How it works

  1. Get_business_ranked_Keywords · toolWorkflow
  2. get_eeat_citations · dataTableTool
  3. online_search · perplexityTool
  4. serp_search · toolWorkflow
  5. suggested_keywords · toolWorkflow
  6. get_business_data · dataTableTool
  7. get_business_ranked_keywords · toolWorkflow
  8. think_tool · toolThink
  9. Think_tool · toolThink
  10. keyword_overview · toolWorkflow
  11. Think_Tool · toolThink
  12. Think · toolThink
  13. Get Article · set
  14. Anthropic Chat Model · lmChatAnthropic

💼 Business analysis

🎯

Business use case

An end-to-end content production line — research, generation, formatting and publishing (Google Sheets, Google Gemini, Perplexity, WordPress, HTTP / REST API, Google Drive 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🔎Perplexity📝WordPress🌐HTTP / REST API🗂️Google Drive📧Gmail🧠Anthropic Claude🧠OpenAI (LLM)🔗Webhook
Node typesdataTable, toolWorkflow, dataTableTool, googleSheets, set, googleGemini, filter, perplexityTool, code, wordpress, httpRequest, agent, editImage, agentTool, merge, toolThink, googleDrive, noOp, outputParserStructured, gmail, lmChatAnthropic, lmChatOpenAi, wordpressTool, errorTrigger, lmChatGoogleGemini, webhookWorkflow IDX1QbmRS5jJYrvbKo
⬇ Download workflow JSON ← Back to library