📝 Content & PublishingAdvanced🧠 AI-powered

MKM Blog Generation v9.2 Part 2

A 84-step content & publishing automation, triggered by form, webhook, error handler, connecting Google Sheets, Google Gemini, Webhook, 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, WordPress, Google Drive — replacing hours of manual writing and posting.

84
Nodes
8
Integrations
83
Connections
Form, 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.

On form submissionformTriggerGet Business datadataTableGet_Business_daTadataTableTool🧠serp_SearcHtoolWorkflow📊insert_topic_in_sheetsgoogleSheetsToolTopic IdeatorgoogleGeminiForm DatasetGet Business DatadataTableget_business_DatadataTableToolget_eeat_citationsdataTableTool📊Update ProcessinggoogleSheetsOutline CreatorgoogleGemini🔗Sheets WebhookwebhookFilter Actionfilter🧠serp_searchtoolWorkflowArticle DatasetHTML Formatcode📝Create a postwordpress🌐Upload ImagehttpRequest🌐Set Featured ImagehttpRequest🌐Update image metahttpRequestPrepare Wordpressset🧠Article Metadata Gene…agentGet WP DatasetGet Topic Datasetmergemergeget_business_datadataTableToolget_internal_LinksdataTableTool📊Research LinkgoogleSheets📊Outline LinkgoogleSheetsContent CreatorgoogleGeminiArrange by sectionscodeGet First DraftsetGet ResearchsetHTMLcode🗂️Create ResearchgoogleDriveGet Outlinesethtmlcode🗂️Create OutlinegoogleDrive🧠OutputoutputParserStructu…📊Insert Blog DatagoogleSheetsGet Articleset🗂️Create ArticlegoogleDriveConvert to HTMLcode🪣Cloudflare Uploads3Get Featured Image Li…set🌐firecrawl_searchhttpRequestTool🧠Scrape_URLtoolWorkflowGet_Internal_LinksdataTableToolget_page_ranked_keywo…dataTableToolSessioN ID👀setSession id 👀setGet_page_ranked_keywo…dataTableToolGet_internal_linksdataTableToolGet_page_ranked_Keywo…dataTableToolGemini 3lmChatGoogleGemini🧠llm_scrapertoolWorkflow🧠ai_keyword_search_vol…toolWorkflowGet_eeat_citationsdataTableTool🧠keyword_overviewtoolWorkflow<-noOpContent StrategistgoogleGemini🧠llm_ScrapertoolWorkflowCover Image Nano Bana…googleGeminiget_business_dAtadataTableToolConvert to .webPeditImageConnect MenoOp🧠Tag & Blog IDagent🌐Get Blog IDhttpRequestTool🌐Get TagshttpRequestTool2.5 flashlmChatGoogleGemini🧠Structured OutputoutputParserStructu…🌐Create BloghttpRequestPrepare json bodycodePrepare article inputsetSet Shopify Dataset🌐Get Cover ImagehttpRequest📊Insert Blog Data WPgoogleSheetsGet Linkset📊Insert Blog Data Shop…googleSheetsPrepare Linksset📧Send a messagegmailError TriggererrorTrigger📧Send a message1gmail

⚙️ How it works

  1. On form submission · formTrigger
  2. Get_Business_daTa · dataTableTool
  3. serp_SearcH · toolWorkflow
  4. insert_topic_in_sheets · googleSheetsTool
  5. get_business_Data · dataTableTool
  6. get_eeat_citations · dataTableTool
  7. Sheets Webhook · webhook
  8. serp_search · toolWorkflow
  9. get_business_data · dataTableTool
  10. get_internal_Links · dataTableTool
  11. firecrawl_search · httpRequestTool
  12. Scrape_URL · toolWorkflow
  13. Get_Internal_Links · dataTableTool
  14. get_page_ranked_keywords · dataTableTool

💼 Business analysis

🎯

Business use case

An end-to-end content production line — research, generation, formatting and publishing (Google Sheets, Google Gemini, Webhook, 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 SheetsGoogle Gemini🔗Webhook📝WordPress🌐HTTP / REST API🗂️Google Drive🪣AWS S3📧Gmail
Node typesformTrigger, dataTable, dataTableTool, toolWorkflow, googleSheetsTool, googleGemini, set, googleSheets, webhook, filter, code, wordpress, httpRequest, agent, merge, googleDrive, outputParserStructured, s3, httpRequestTool, lmChatGoogleGemini, noOp, editImage, gmail, errorTriggerWorkflow IDRozZ4tOW8Y4Yi7Zt
⬇ Download workflow JSON ← Back to library