Workflow Library
← LibraryPricingLog in
📝 Content & PublishingIntermediate● Active

2 - Daily Publisher (4 PM)

A 30-step content & publishing automation, triggered by manual, schedule, connecting Google Sheets, HTTP / REST API.

⬇ Download workflow JSON
💡

What this does for your business

In plain terms: this writes and publishes content for you. It runs on a set schedule (e.g. daily), creates the piece, and pushes it to Google Sheets — replacing hours of manual writing and posting.

30
Nodes
2
Integrations
33
Connections
Manual, Schedule
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 Pending PostsgoogleSheets▶When clicking ‘Execut…manualTrigger🌐check_tokenhttpRequest•Facebook: Check Platf…code•Facebook: Should Post?if•Facebook: Has Image?if🌐Facebook: Post with I…httpRequest🌐Facebook: Post Text O…httpRequest•Facebook: Merge Resultcode•Facebook: Mark Skippedcode•LinkedIn: Check Platf…code•LinkedIn: Should Post?if•LinkedIn: Has Image?if🌐LinkedIn: Fetch Image…httpRequest🌐LinkedIn: Post with I…httpRequest🌐LinkedIn: Post Text O…httpRequest•LinkedIn: Merge Resultcode•LinkedIn: Mark Skippedcode•Get Todaycode•Loop PostsplitInBatches•No PostnoOp🌐LinkedIn: Get Person …httpRequest•Any Posts Today?if🌐LinkedIn: Init Img_Up…httpRequest🌐LinkedIn: Upload_ImghttpRequest•Post to X (disabled)code•Prepare Status Updatecode📊update_statusgoogleSheets▶7 amscheduleTrigger▶4 PMscheduleTrigger

⚙️ How it works

  1. When clicking ‘Execute workflow’ · manualTrigger
  2. check_token · httpRequest
  3. Post to X (disabled) · code
  4. 7 am · scheduleTrigger
  5. 4 PM · scheduleTrigger
  6. Get Today · code
  7. LinkedIn: Get Person URN (img path) · httpRequest
  8. Prepare Status Update · code
  9. Get Pending Posts · googleSheets
  10. update_status · googleSheets
  11. Any Posts Today? · if
  12. Loop Post · splitInBatches
  13. Facebook: Check Platform · code
  14. No Post · noOp

💼 Business analysis

🎯

Business use case

An end-to-end content production line — research, generation, formatting and publishing (Google Sheets, HTTP / REST API) — 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🌐HTTP / REST API
Node typesgoogleSheets, manualTrigger, httpRequest, code, if, splitInBatches, noOp, scheduleTriggerWorkflow IDOKP4xbqb8DgPDJ5L-_okJ
⬇ Download workflow JSON ← Back to library