Create and schedule LinkedIn posts from Google Sheets with Gemini and DALL·E
UnknownWhat this workflow does
This AI workflow has 18 nodes and runs on Google Sheets events (row added) (plus 1 other trigger). Along the way it connects Google Sheets, OpenRouter Chat Model, OpenAI and Preview Upload Post (community). It also calls api.imgbb.com and api.upload-post.com over HTTP.
How it runs
Trigger: On Google Sheets events (row added) (plus 1 other trigger).
- Filter: keeps only the items that match a condition
- GetPosts (Google Sheets): uses Google Sheets
- Loop Over Items (Loop Over Items (Split in Batches)): loops over the items in batches
- If: checks a condition and branches into true / false
- GetBrandGuide (Google Sheets): uses Google Sheets
- Upload Post: upload photos (uploads)
- Basic LLM Chain: sends a prompt to an LLM, with model: Fallback model, OpenRouter Chat Model; output parser: Structured Output Parser
- Append or update row in sheet (Google Sheets): append or update
- Generate an image (OpenAI): work with image
- UploadImg (HTTP Request): calls api.imgbb.com (POST)
…plus 2 more steps. See the full node list below.
Services it uses
HTTP calls to: api.imgbb.com, api.upload-post.com
Before you upgrade to n8n 3.0
We can't fully verify this one: it relies on 1 community package, and n8n 3.0 turns unverified community packages off by default (N8N_UNVERIFIED_PACKAGES_ENABLED=false).
- Check that n8n-nodes-preview-upload-post is verified or supports 3.0 (used in Upload Post).
Nodes used (13)
- HTTP Request
n8n-nodes-base.httpRequest - Google Sheets
n8n-nodes-base.googleSheets - Basic LLM Chain
@n8n/n8n-nodes-langchain.chainLlm - Google Sheets Trigger
n8n-nodes-base.googleSheetsTrigger - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - OpenRouter Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenRouter - Filter
n8n-nodes-base.filter - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - OpenAI
@n8n/n8n-nodes-langchain.openAi - Schedule Trigger
n8n-nodes-base.scheduleTrigger - If
n8n-nodes-base.if - No Operation, do nothing
n8n-nodes-base.noOp - Upload Post
n8n-nodes-preview-upload-post.uploadPost
From the author
Overview This n8n automation is a complete LinkedIn Content Engine that turns simple topic ideas into fully written, visual, and scheduled posts. It features a "Human-in-the-Loop" design, meaning AI handles the heavy lifting of writing and image creation, but…