Write and approve social posts from Google Sheets with PostWire and Gmail
UnknownUnknown. This template uses community nodes we can't verify statically. Uses community nodes that can't be verified statically (unverified community packages are off by default in 3.0). Static check, last run 2026-10-19.
What this workflow does
This workflow has 16 nodes and runs on a schedule (cron 0 9 * * 1-5). Along the way it connects Google Sheets, Gmail and Postwire (community).
How it runs
Trigger: On a schedule (cron 0 9 * * 1-5).
- Your voice and email (Edit Fields (Set)): sets 2 fields: voice, email
- Read the topics (Google Sheets): read
- Has a topic (Filter): keeps only the items that match a condition
- Take the next topic (Limit): keeps the first few items
- Mark the topic as drafting (Google Sheets): update
- Write the drafts (Post Wire): generate (post)
- Ask me to approve (Gmail): send and wait for a reply
- Approved? (If): checks a condition and branches into true / false
- Post the approved drafts (Post Wire): publish (post)
- Mark the topic as skipped (Google Sheets): update
…plus 5 more steps. See the full node list below.
Services it uses
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-postwire is verified or supports 3.0 (used in Write the drafts, Post the approved drafts).
Nodes used (9)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Edit Fields (Set)
n8n-nodes-base.set - Google Sheets
n8n-nodes-base.googleSheets - Filter
n8n-nodes-base.filter - Limit
n8n-nodes-base.limit - Post Wire
n8n-nodes-postwire.postWire - Gmail
n8n-nodes-base.gmail - If
n8n-nodes-base.if - Aggregate
n8n-nodes-base.aggregate
From the author
Quick Overview This workflow runs every weekday and pulls the next “ready” topic from Google Sheets, uses PostWire to generate draft posts for LinkedIn, Facebook, and Bluesky, then emails the drafts via Gmail for approval before publishing the approved text…