AI guest post generator with OpenAI & Google Sheets automation
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 include: SEO guest post generation Content marketing automation for agencies Outreach planning and editorial automation 💡 Good to Know OpenAI API usage costs apply based on the selected model (e.g., GPT-4). This automation uses Google
At a glance
AI guest post generator with OpenAI & Google Sheets automation is a ready-made n8n workflow you import as a workflow JSON file — no build required. It connects Gmail, Google Sheets, OpenAI. It's free to download. Follow the 5-step import below to go live in minutes.
- Platform
- n8n
- Connects
- Gmail, Google Sheets, OpenAI
- Modules
- 12
- Price
- Free
- Version
- v1.0

About this workflow
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 include: SEO guest post generation Content marketing automation for agencies Outreach planning and editorial automation 💡 Good to Know OpenAI API usage costs apply based on the selected model (e.g., GPT-4). This automation uses Google Sheets and OpenAI; credentials are required to connect your accounts. Status filtering ensures only content marked as “Start” is processed — making it safe to use in multi-user workflows. ⚙️ How It Works Trigger the workflow manually (can be changed to schedule/cron or webhook). Reads from a Google Sheet with guest post planning data. Merges the writing prompt, brand guidelines, and posting rules. Sends the merged data to OpenAI (via the AI Agent node) to generate a guest post in German. Saves the result into another Google Sheet. Updates the original row's status from “Start” to “Finished” to prevent duplicates. ▶️ How to Use You must connect your Google Sheets and OpenAI accounts. Customize the AI prompt, tone, or language by editing the input structure. You can modify the filter to run only on certain months or categories. The Gmail node is optional and only used to notify when no action was taken. 🧰 Requirements OpenAI account (API key for GPT-4 or GPT-3.5) Google account with access to the configured Sheets Basic knowledge of how n8n expressions work (optional) 🛠️ Customising This Workflow This guest post writer workflow can easily be adapted to other use cases: Write social media content from a spreadsheet Generate product descriptions from catalog data Automatically translate or rewrite articles in different tones/languages Create personalized outreach emails using AI 🎁 The workflow includes built-in explanations (sticky notes) to guide you through each part of the process.
How to import this n8n workflow
- 1
Download the workflow JSON file after purchase.
- 2
Open n8n → click the menu → Import from File.
- 3
Select the downloaded JSON and import.
- 4
Set up credentials for each node that requires them.
- 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
Send a new client in Harvest as a new row to Google Sheets
Add Google Sheets rows from Netlify form submissions after verifying email with MailboxValidator
Synchronizing WooCommerce inventory and creating products with Google Gemini AI and BrowserAct
Create playlists and control your Spotify player with GPT-4
AI-powered Scrum Master assistant with OpenAI, Slack and Asana integration
Create a task in Teamwork from an e-mail in Gmail, attach attachment zipped by CloudConvert
Send crypto price alerts, daily digests and /price replies with CoinGecko, Telegram and Sheets
Parse incoming invoices from Outlook using AI Document Understanding
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.
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.
- Configure live on Google Meet / Zoom
- Free follow-up if workflow has defects
- Platform expert assigned to you