Route social media content reviews with Google Gemini and Google Sheets
Needs changesWhat this workflow does
This AI workflow has 24 nodes and runs when someone submits an n8n form (“Relay — New Content Brief”). Along the way it connects Google Gemini Chat Model and Google Sheets.
How it runs
Trigger: When someone submits an n8n form (“Relay — New Content Brief”).
- Client DB Lookup (Sheets) (Google Sheets): uses Google Sheets
- Config — Brand + Brief (Edit Fields (Set)): sets 17 fields: brief_id, client, brand_name…
- Sofia Research Agent (AI Agent): runs an AI agent, with model: Google Gemini Chat Model
- Sofia Save Angles (Edit Fields (Set)): sets 2 fields: sofia_angles, sofia_iteration
- Sofia Review Angles (Human Review) (Wait): pauses until form
- Sofia Route Decision (Switch): routes items into 2 branches
- Marcus — Merge Context (Edit Fields (Set)): sets 19 fields: brief_id, client, brand_name…
- Sofia Feedback (Edit Fields (Set)): sets 1 field: lastFeedback
- Marcus — Creative Agent (AI Agent): runs an AI agent, with model: Google Gemini Chat Model
- Save Post Draft (Edit Fields (Set)): sets 4 fields: post_copy, hashtags, visual_direction…
…plus 10 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
1 thing in this workflow is removed in n8n 3.0. Fix it before you upgrade:
- AI Agent v1 (old agent modes) in Sofia Research Agent (v1.7), Marcus — Creative Agent (v1.7), Taylor — Review Agent (v1.7): replace with Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent.
Rather not rewrite it? Many of these flows can be rebuilt in Make (free plan).
| Removed in 3.0 | Replace with |
|---|---|
| AI Agent v1 (old agent modes) Sofia Research Agent (v1.7), Marcus — Creative Agent (v1.7), Taylor — Review Agent (v1.7) | Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent. |
Nodes used (8)
- Google Gemini Chat Model
@n8n/n8n-nodes-langchain.lmChatGoogleGemini - Edit Fields (Set)
n8n-nodes-base.set - Wait
n8n-nodes-base.wait - Switch
n8n-nodes-base.switch - n8n Form Trigger
n8n-nodes-base.formTrigger - Google Sheets
n8n-nodes-base.googleSheets - AI Agent
@n8n/n8n-nodes-langchain.agent - Code
n8n-nodes-base.code
From the author
Quick overview This workflow collects a social media content brief via an n8n form, uses Google Sheets for client brand context, and runs a three-stage human-in-the-loop process powered by Google Gemini (strategy angles, draft writing, and quality audit)…