AI guest post generator with OpenAI & Google Sheets automation
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 12 nodes and runs manually, when you click “Execute workflow”. Along the way it connects OpenAI Chat Model, Google Sheets and Gmail.
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Read Config Sheet (Google Sheets): uses Google Sheets
- Check if Status is Start (If): checks a condition and branches into true / false
- Read Guest Post Input (Google Sheets): uses Google Sheets
- Read Writting Rules (Google Sheets): uses Google Sheets
- Read Portfolio Requirements (Google Sheets): uses Google Sheets
- Notify When No Action is Taken (Gmail): send and wait for a reply
- Merge: merges the data from its input branches
- Generate post with AI (German) (AI Agent): runs an AI agent, with model: OpenAI Chat Model
- Save Generated Content to Outreach (Google Sheets): append
- Mark Config Row as Finished (Google Sheets): update
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (7)
- OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Manual Trigger
n8n-nodes-base.manualTrigger - Google Sheets
n8n-nodes-base.googleSheets - If
n8n-nodes-base.if - Merge
n8n-nodes-base.merge - AI Agent
@n8n/n8n-nodes-langchain.agent - Gmail
n8n-nodes-base.gmail
From the author
✨ About this Template This n8n template automates the process of writing SEO guest post content using OpenAI, based on rules and topics provided in a Google Sheet. The generated articles are saved into a separate sheet for outreach or publishing. Use cases…