AutomationMart
Home/Browse/AI guest post generator with OpenAI & Google Sheets automation
n8n

AI guest post generator with OpenAI & Google Sheets automation

n8nn8n12 modulesv1.0
GmailGoogle SheetsOpenAI

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
AI guest post generator with OpenAI & Google Sheets automation workflow diagram

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.

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

Send a new client in Harvest as a new row to Google Sheets

When a new client is created in Harvest, a new row with their credentials is added in Google Sheets.

Free

Add Google Sheets rows from Netlify form submissions after verifying email with MailboxValidator

Every time a new Netlify form is submitted, Make will automatically validate the email address from that form output using MailboxValidator. If the email is verified, it will add the output of the form to a Google Sheet. This example uses [this sheet](https://docs.google.com/spreadsheets/d/1KGDXEcM2tkplGyzDfJJ16G_pYkSXPNawnnNcjN7kWl0/edit#gid=0).

Free

Synchronizing WooCommerce inventory and creating products with Google Gemini AI and BrowserAct

Synchronize WooCommerce Inventory & Create Products with Gemini AI & BrowserAct This sophisticated n8n template automates WooCommerce inventory management by scraping supplier data, updating existing products, and intelligently creating new ones with AI-formatted descriptions. This workflow is essential for e-commerce operators, dropshippers, and inventory managers who need to ensure their product pricing and stock levels are synchronized with multiple third-party suppliers, minimizing overselli

Free

Create playlists and control your Spotify player with GPT-4

This n8n template provides a powerful AI-powered chatbot that acts as your personal Spotify DJ. Simply tell the chatbot what kind of music you're in the mood for, and it will intelligently create a custom playlist, give it a fitting name, and populate it with relevant tracks directly in your Spotify account. The workflow is built to be flexible, allowing you to easily change the underlying AI model to your preferred provider, making it a versatile starting point for any AI-driven project. W

Free

AI-powered Scrum Master assistant with OpenAI, Slack and Asana integration

What is This? This automation simulates Scrum Master role on daily meetings. Essentially it is an AI Scrum Master using different sources of data. As intelligent support system for Scrum Masters that leverages data from Asana, Slack, and direct developer responses for comprehensive sprint status analysis and identification of areas requiring intervention. As such it is usable for Scrum Masters (of course) but Scrum Team aswell, Product Owner and possibly Business Owner. Who is it For?

Free

Create a task in Teamwork from an e-mail in Gmail, attach attachment zipped by CloudConvert

In specified intervals, Make check if there is a new e-mail in Gmail account. If so, a new task in a specified project is created in Teamwork Projects. If the e-mail contains an attachment, it is zipped by CloudConvert and uploaded at the same time as the creation of the task.

Free

Send crypto price alerts, daily digests and /price replies with CoinGecko, Telegram and Sheets

Quick overview This workflow tracks a configurable crypto watchlist using the CoinGecko API, sends Telegram alerts when price, % change, or volume-spike conditions are met (with optional RSI filtering), optionally logs triggered alerts to Google Sheets, and also provides a daily Telegram digest plus a /price command bot. How it works 1. Runs every hour on a schedule, loads your watchlist, and loops through each configured asset. 2. Fetches current price, 24h change, 24h volume, and market cap fr

Free

Parse incoming invoices from Outlook using AI Document Understanding

This n8n template monitors an Outlook mailbox for invoices, automatically parses/extracts data from them and then uploads the output to an Excel Workbook. One of my top workflow requests, this template can save many hours of manual labour for you or your finance/accounts team. How it works A scheduled trigger is set to fetch recent Outlook messages to the Accounts receivable mailbox. Each message is analysed to determine whether or not it from a supplier and is issuing/contains an

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