Create LinkedIn posts and WordPress blogs with OpenAI and Google Sheets
Ready for 3.0What this workflow does
This AI workflow has 21 nodes and runs when someone submits an n8n form (“AI Content Studio”) (plus 1 other trigger). Along the way it connects OpenAI, Google Drive, Google Sheets and LinkedIn.
How it runs
Trigger: When someone submits an n8n form (“AI Content Studio”) (plus 1 other trigger).
- ⚙️ Workflow Configuration (Edit Fields (Set)): sets 7 fields: imageSize, brandStyleNotes, publishWebhookUrl…
- ⚙️ Publish Configuration (Edit Fields (Set)): sets 3 fields: wordpressSiteUrl, google_spreadsheet_id, google_sheet_name
- Write the Content (OpenAI): uses OpenAI
- Find Draft by ID (Google Sheets): uses Google Sheets
- Create Thumbnail Image (OpenAI): work with image
- Already Processed or Not Found? (If): checks a condition and branches into true / false
- Convert Thumbnail to Base (Extract from File): extracts data from a file (binary to propery)
- Respond Already Processed (Respond to Webhook): sends the response back to the webhook caller
- Download Thumbnail from Drive (Google Drive): download
- Upload Thumbnail to Drive (Google Drive): uses Google Drive
…plus 9 more steps. See the full node list below.
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 (13)
- n8n Form Trigger
n8n-nodes-base.formTrigger - Edit Fields (Set)
n8n-nodes-base.set - OpenAI
@n8n/n8n-nodes-langchain.openAi - Extract from File
n8n-nodes-base.extractFromFile - Google Drive
n8n-nodes-base.googleDrive - Google Sheets
n8n-nodes-base.googleSheets - n8n Form
n8n-nodes-base.form - Webhook
n8n-nodes-base.webhook - If
n8n-nodes-base.if - Respond to Webhook
n8n-nodes-base.respondToWebhook - Switch
n8n-nodes-base.switch - LinkedIn
n8n-nodes-base.linkedIn - HTTP Request
n8n-nodes-base.httpRequest
From the author
Quick Overview This workflow collects a content brief via an n8n form, uses OpenAI to generate a LinkedIn post or WordPress blog plus a matching thumbnail, saves the draft to Google Sheets and Google Drive, then publishes on approval to LinkedIn or creates a…