AcademyWorkflowsMarketing

Author and Publish Blog Posts From Google Sheets

Content teams that plan articles in a shared sheet and want a review step before each post goes live.

Use it nowWant it running at your company?
  • Recommendedour rating
  • 6,266views on n8n

Use it now

Open inClaudeChatGPTGeminiPerplexity
Open on n8n.io ↗

Paste it straight onto an n8n canvas with Ctrl+V or Cmd+V.

Third party software. By copying, downloading or installing it you accept the Academy legal notice: you are responsible for reviewing its code and permissions before use.

author-and-publish-blog-posts-from-google-sheets.json

Loading the file...

What it does

This n8n workflow moves blog topics from a Google Spreadsheet through planning, drafting and final stages with an LLM. Prompts and model choices live in the spreadsheet, and each result is saved back to its row. The workflow returns control to you between stages so you can review the text, then publishes the final post to WordPress.

Use cases

  1. 01Plan a month of topics in one shared spreadsheet
  2. 02Review each draft before it moves to the next stage
  3. 03Publish approved articles to a WordPress blog

Connects

Google Sheets · HTTP Request · Code · Basic LLM Chain · OpenAI Chat Model

Questions about
Author and Publish Blog Posts From Google Sheets.

What is Author and Publish Blog Posts From Google Sheets used for?

Content teams that plan articles in a shared sheet and want a review step before each post goes live. This n8n workflow moves blog topics from a Google Spreadsheet through planning, drafting and final stages with an LLM. Prompts and model choices live in the spreadsheet, and each result is saved back to its row. The workflow returns control to you between stages so you can review the text, then publishes the final post to WordPress.

How do I import Author and Publish Blog Posts From Google Sheets into n8n?

Copy the workflow JSON from this page and paste it onto the n8n canvas with Ctrl+V or Cmd+V. Then connect your credentials in each node.

Is Author and Publish Blog Posts From Google Sheets safe to use?

It passed our automatic scan for credential theft, hidden instructions and risky install commands. Third party open source software. Sabemos AI does not maintain it. Check the code and permissions before you connect it to company data.

Related resources

Read the guide: AI marketing content systems ↗

  1. 001Brand GuidelinesMarketing and design teams who need materials styled consistently with Anthropic's brand.OfficialSkill
  2. 002HumanizerMarketing and communications teams use it to polish drafts that sound too much like AI before publishing.RecommendedSkill · ★ 55k
  3. 003Marketing Skills for AI AgentsMarketing teams and founders use it to give their AI agent a repeatable method for CRO, copy and SEO tasks.RecommendedSkill · ★ 54k
  4. 004AI videos with Seedance, posted to TikTok, YouTube, InstagramContent and social media teams that want to automate short video production and publishing across several platforms.RecommendedWorkflow · 215k views
  5. 005Multi-platform social media content with AISocial media managers and marketing teams who want drafts and publishing for several channels in one reviewed workflow.RecommendedWorkflow · 205k views
  6. 006AI video generation and multi-platform publishingContent creators, agencies and marketing teams who produce short-form video for several social channels.RecommendedWorkflow · 191k views