Keyflow

Search Keyflow

Find a shortcut, workflow, MCP server or skill

Author and Publish Blog Posts From Google Sheets

n8n template #2873
What it is: An automation to plan→draft→finalize and publish your textual blog post ideas to your wordpress blog Works in stages and hand back control to you in between those You can use a Google Spreadsheet for planning topics and configuring LLM models and prompts What it does: plans→drafts→finalizes blog post topics you specify in a Google Spreadsheet using an LLM with prompts that also ar configured in that spreadsheet (even which model to use) savs the results in the corresponding columns of the "Schedule" sheet in the spreadsheet hands control back to the user for inspecting or changing the results and for setting the next "Action" for th workflow Finally publishes the blog post to you

How to set it up

  1. Open template #2873 on n8n.io and click Use for free, or copy the template JSON and paste it onto an empty canvas in n8n.
  2. Create 2 credentials under Credentials → Add credential: Google Sheets, OpenAI Chat Model. Then open each of those nodes and pick the credential.
  3. Check the model in the OpenAI Chat Model node. The template may point at a model your account can't use; swap it for one you have access to.
  4. Click Execute workflow and step through each node's output to confirm the data looks right.
  5. Toggle the workflow to Active so its trigger runs on its own.

Hand off to your agent

Prompt

Help me set up the n8n workflow "Author and Publish Blog Posts From Google Sheets" (https://n8n.io/workflows/2873). It uses: Google Sheets, HTTP Request, Code, Basic LLM Chain, OpenAI Chat Model. Import the template JSON into my n8n instance, list every credential I need to create, and walk me through testing it.

Paste into Claude Code and it will do the rest.

Apps and nodes

Questions

Yes. Daniel Nolde published it free on n8n.io as a verified creator, and it has 6,266 views. It runs on n8n Cloud or a self-hosted n8n instance.

Google Sheets, OpenAI Chat Model. The other 3 nodes are built into n8n.

Similar workflows

NameViews
  1. AI-Powered Information Monitoring with OpenAI, Google Sheets, Jina AI and Slack18K
  2. Automated Invoice Processing with Telegram, GPT-4o, OCR and SAP Integration13K
  3. Automate SEO blog content creation with GPT-4, Perplexity AI and WordPress6,949
  4. Automate SEO blog creation + social media with GPT-4, Perplexity and WordPress5,798
  5. Explore n8n Nodes in a Visual Reference Library5,197
  6. Generate AI Viral Videos with Seedance and Upload to TikTok, YouTube & Instagram215K
  7. Host Your Own AI Deep Research Agent with n8n, Apify and OpenAI o348K
  8. Automate sales cold calling pipeline with Apify, gpt-5.6-terra, and WhatsApp34K