AutomationMart
Home/Browse/Author and publish blog posts from Google Sheets
n8n

Author and publish blog posts from Google Sheets

n8nn8n22 modulesv1.0
chainLlmcodegoogleSheetshttpRequestiflmChatOpenAimanualTriggerscheduleTriggerset

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 col

At a glance

Author and publish blog posts from Google Sheets is a ready-made n8n workflow you import as a workflow JSON file — no build required. It connects chainLlm, code, googleSheets, httpRequest. It's free to download. Follow the 5-step import below to go live in minutes.

Platform
n8n
Connects
chainLlm, code, googleSheets, httpRequest, if, lmChatOpenAi
Modules
22
Price
Free
Version
v1.0
Author and publish blog posts from Google Sheets workflow diagram

About this workflow

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 your Wordpress instance Limitations Probably slightly over-engineered ;-) No media generation yet some LLM models don't work because of their output format How it works: The Workflow is triggered manually or scheduled every hour It ingests a Google Spreadsheet to get Config for prompts/context tc Blog-Topics and their status and next action Depending on each blog topics "Status" and "Action" it then either uses an LLM for th next action ("plan"→"draft"→"final" actions) or publishes the written content to your Wordpress instance ("publish" actions) Set up steps: Import the workflow Make your own copy of the Google Spreadsheet Update the credentials using your individual credentials for: Google Spreadsheets OpenRouter Edit the "Settings" node and enter your individual values for Your spreadsheet copy URL Your wordpress blog URL Your wordpress blog username Your wordpress blog app password (a 4x4 alphanumeric sequence), that you probably have to create first, for which your wordpress user has to have 2-factor-authentication enabled. In your own copy of the spreadsheet: individualize the "Config" sheet's "Value" column for the prompts/context/etc Populate the "Schedule" sheet with at least one line in which you specify a "Topic" a "Schedulded" date (YYYY-MM-DD HH:mm:ss) a "Status" of "idea" an "Action" of "plan" (to kick off that action)

n8n

How to import this n8n workflow

  1. 1

    Download the workflow JSON file after purchase.

  2. 2

    Open n8n → click the menu → Import from File.

  3. 3

    Select the downloaded JSON and import.

  4. 4

    Set up credentials for each node that requires them.

  5. 5

    Click Execute Workflow to test, then activate.

Setup guide

Setup guide included

Purchase to unlock the full step-by-step guide

Related N8n workflows

CYBERPULSE AI GRC: Vendor risk evaluator

Description Automates the intake, classification, and documentation of third-party vendors. Evaluates vendor function, data access level, certification status, and applies AI-driven risk tiering (Low, Standard, Critical). Ensures standardized onboarding and scalable due diligence. Who It’s For Compliance and procurement teams onboarding vendors GRC consultants managing supply chain risk Security leads needing traceable vendor evidence Audit teams validating third-party controls How It Works Trig

Free

Email-based book recommendations with Ollama LLM and OpenLibrary API

This workflow listens for incoming book request emails, extracts the user's intent using the Ollama LLM, queries book data (title, summary, details) via an API, and sends a personalized recommendation email. Ideal for automated book suggestions using LLMs and structured APIs, great for newsletters, reading clubs, and educational bots. How It Works 1. Email Request: Triggers the workflow when a new email with a book request is received. 2. Analyze Email with Ollama: Extracts user intent and book

Free

Daily website data extraction with Firecrawl and Telegram alerts

Automated Daily Firecrawl Scraper with Telegram Alerts Get structured insights scraped daily from the web using Firecrawl’s AI extraction engine — then send them directly to your Telegram chat. 🧰 What this workflow does: This workflow automatically scrapes specific structured data from any webpage every day at a scheduled time using the Firecrawl API, checks if results are returned, and then sends the formatted results to Telegram. For step-by-step video tutorials of n8n builds, check out my

Free

Generate images with realistic inpainting using Simbrams Ri AI

Generate Images with Realistic Inpainting using Simbrams Ri AI This n8n workflow integrates with Replicate’s simbrams/ri model to generate images. It takes an input image and mask, applies transformations based on your parameters, and returns the final generated output automatically. --- 📌 Section 1: Trigger & Authentication ⚡ On Clicking ‘Execute’ (Manual Trigger) Purpose: Starts the workflow manually. Benefit: Useful for testing and running on demand. 🔑 Set API Key (Set Node) Purpose: Store

Free

AI-Powered Zoho CRM Lead Management with OpenAI GPT

Zoho CRM MCP Server Integration (n8n Workflow) 🧠 Overview This n8n flow integrates Zoho CRM with an MCP (Model Context Protocol) Server and OpenAI Chat Model, enabling AI-driven automation for CRM lead management. It allows an AI Agent to create, update, delete, and fetch leads in Zoho CRM through natural language instructions. --- ▶️ Demo Video Watch the full demo here: 👉 YouTube Demo Video --- ⚙️ Core Components | Component | Purpose | | ---------------------- | ------------------------------

Free

Search business prospects with natural language using Explorium MCP

Explorium Prospects Search Chatbot Template Download the following json file and import it to a new n8n workflow: mcp\to\prospects\to\csv.json <br / Overview This n8n workflow creates a chatbot that understands natural language requests for finding business prospects and automatically: Interprets your query using AI (Claude Sonnet 3.7) Converts it to proper Explorium API filters Validates the API request structure Fetches prospect data from Explorium Exports results as a downloadable CSV fi

Free

Automated replies to X threads with Airtop browser automation

Use Case Automatically responding to X (formerly Twitter) posts can help you engage with potential customers at scale, saving time while maintaining a personal touch. What This Automation Does This automation replies to specified X posts using the following input parameters: - airtopprofile: The name of your Airtop Profile connected to X. - threadurl: The URL of the X post to reply to. Example - replytext: The message you want to post as a reply. How It Works 1. Creates a browser session using A

Free

Multilingual WhatsApp translator with OpenAI Whisper & GPT-4 and HubSpot integration

AI WhatsApp Translator + Voice Transcriber with HubSpot Integration Hello! I'm Amanda ❤️, a passionate automation creator and AI enthusiast. With over 2 years of experience in n8n and Make.com, I design robust, intelligent agents that make your operations smarter and smoother. This translator + transcriber assistant is perfect for multilingual communication via WhatsApp. It automatically captures voice or text messages, identifies the customer's region and language, transcribes audio using O

Free

Reviews

No reviews yet

Be the first to buy and share your experience.

Leave a review

Sign in to share your experience with this workflow.

Log in to review
Free
No ratings yet

Create a free account to purchase workflows.

  • JSON blueprint — instant download
  • Setup guide PDF included
  • 5 downloads · valid 30 days
  • Works with n8n

Need help setting this up?

Book a 3-hour live setup session with an Agility consultant.

₹2,499/ session
3 hrs · video call
  • Configure live on Google Meet / Zoom
  • Free follow-up if workflow has defects
  • Platform expert assigned to you
Book installation session
Free