n8n Social Media Agent: OpenAI + PostWire + Google Sheets

Publish and schedule social posts with an OpenAI agent—safely approved and logged to Google Sheets

This n8n Social Media Agent workflow drafts, publishes, and schedules posts across your connected networks using an OpenAI-powered agent and PostWire—then records every approved publish/schedule action to Google Sheets for clear auditing and reporting.

What this workflow does

• Starts in the n8n Chat interface when you send a message.
• Detects your PostWire-connected social accounts and limits posting options to those networks only.
• Generates native post drafts for the requested networks inside PostWire.
• Uses an optional public media URL for Instagram, TikTok, or YouTube when provided (e.g., for richer post creation).
• Waits for your explicit approval before any action is taken.
• Publishes immediately or schedules the approved drafts in PostWire.
• Can create a one-week plan of text-only posts when requested, then schedules accordingly.
• Helps you manage the queue: lists queued scheduled posts in PostWire when you ask to review pending items.
• Supports cancellation: removes a queued PostWire scheduled post by ID after you confirm.
• Audits outcomes: appends a row to Google Sheets after each publish or schedule action with date, action type, networks, a text snippet, and result links or errors.

Use cases

• SaaS teams drafting campaign posts and approving them before publishing to avoid mistakes.
• Automation engineers building a controlled social publishing pipeline with PostWire and n8n.
• Operators who need a reliable posting log in Google Sheets for compliance and performance tracking.

Technical details

• n8nnodes-langchainchat trigger for chat-based workflow start.
• n8nn8n-nodes-langchainagent with OpenAI (tool-calling chat model) for agent-driven drafting and routing.
• n8n-nodes-postwirepost tool nodes to create drafts, publish, schedule, list queued items, and cancel by ID.
• Google Sheets tool to write `date, action, networks, text, result` to your configured spreadsheet.
• Credentials required: PostWire API credential, OpenAI API credential, and Google Sheets credentials.