active
n8n Social Media Autoposter
Automated social media posting pipeline for a family business — reads scheduled posts from a Google Sheet, routes to LinkedIn and Instagram/Facebook based on platform flags, uploads media, and tracks completion status.
n8nautomationsocial-medialinkedininstagram
n8n Social Media Autoposter
A multi-platform social media automation workflow built in n8n for a family business.
Pipeline
- Scheduled trigger runs every 30 minutes
- Read Google Sheet for rows with Status = Pending
- Route by platform using conditional branches:
- LinkedIn path: Download image as binary → Create image post via LinkedIn API → Update sheet status to Completed
- Instagram/Facebook path: Post via Facebook Graph API → Update sheet status
- Update Google Sheet with completion status after each post
Architecture
Google Sheet serves as the content calendar and status tracker. Each row contains the post content, image URL, and platform flags (LinkedIn, Instagram). The workflow checks platform flags and routes to the appropriate API. LinkedIn posts use OAuth via a registered LinkedIn Developer app. Facebook and Instagram posts use the Facebook Graph API.
Key Features
- Multi-platform posting from a single content calendar
- Google Sheet as a simple CMS (no extra tools needed)
- Conditional routing — post to one or multiple platforms per row
- Binary image handling for LinkedIn media uploads
- Automatic status tracking (Pending → Completed)
- Polling every 30 minutes for hands-off operation