System generates a new post based on category rotation (Category → Tips → Use Case → repeat)
n8n + Internal DBSocial Media
LinkedIn Post Automation System
End-to-end LinkedIn pipeline that generates, reviews, schedules, and publishes posts with 75–80% less manual work.
Overview
What we built
The LinkedIn Post Generator automates the entire process of creating, reviewing, scheduling, and publishing posts for Portable Partitions. Before automation, every post was manually written, reviewed, and scheduled—taking significant time from the marketing team each week. The system is now end-to-end automated, powered by n8n, Google Docs, Airtable, and the LinkedIn API.
The challenge
Why automation was needed
Manual posting was eating into the marketing team's week:
- Marketing team spending 40–45 minutes per post to create, review, and publish
- Posting was irregular—dependent on someone having time to do it manually
- No structured content rotation system
- Frequent scheduling errors and missed publish times
- Creative energy wasted on repetitive formatting and copy-pasting
The solution
How the workflow runs
A category-driven content engine with a human approval gate and automatic publishing.
Post text and image pulled from internal content database
Internal DBDraft saved to Google Docs for easy team review
Google Docs APIDraft synced to Airtable where the user approves and sets a publish date
Airtable APIPost auto-published to LinkedIn at the scheduled time
LinkedIn APIAirtable status updated to "Published" after posting
Airtable APITech stack
Tools that power it
Workflow Automationn8n
Draft ReviewGoogle Docs API
Approval & SchedulingAirtable API
PublishingLinkedIn API
Content StorageInternal Database (categories, industries, use cases, images)
Impact & results
What changed after launch
MetricBeforeAfterImprovement
Time to create & publish 1 post~40–45 minutes~10 minutes75% reduction
Weekly manual effort~4–5 hours<1 hour80% time saved
Posting consistencyIrregular100% consistentImproved
Scheduling errorsFrequentNoneEliminated
~15–18 hours saved per month
Equivalent to 2 full working days of manual effort eliminated
Outcome
The bottom line
This automation delivers a consistent, hands-free posting process with 75–80% less manual work—ensuring every LinkedIn post aligns with brand messaging and schedule.