Generate and schedule LinkedIn posts with Google Sheets, OpenAI
Go to Workflow
SpaGreen Creative
Description
Who is this for?
This workflow is designed for content creators, social media managers, digital marketers, and business owners who want to automate their LinkedIn content creation and publishing process. It's especially valuable for those who struggle with consistently creating engaging content or want to maintain a regular posting schedule without manual effort.
What this Workflow Does / Key Features
Automatically runs every 6 hours to generate and post LinkedIn content
Retrieves content topics from a Google Sheet that haven't been processed yet
Uses AI to research trending topics and create detailed content frameworks
Generates engaging LinkedIn post content based on those topics
Creates professional images to accompany posts using AI
Develops optimized hashtags to improve post visibility
Posts the complete content package to both LinkedIn profiles and company pages
Updates the Google Sheet to track which topics have been processed
Requirements
Google Sheets OAuth2 API credentials for accessing your content spreadsheet
LinkedIn OAuth2 API credentials for posting to profiles and pages
OpenAI API credentials for content generation and image creation
Google Gemini (PaLM) API credentials for AI processing
Mistral Cloud API credentials for trend analysis
A Google Sheet with specific columns: SL, Topic, Status, row_number
Workflow Components Explained
Schedule Trigger**: Automatically starts the workflow every 6 hours
Get row(s) in sheet**: Retrieves topics from your Google Sheet that haven't been processed
Loop Over Items**: Processes topics one at a time to avoid overwhelming the system
Content topic generator**: Creates detailed content topics with titles, rationale, and hooks
AI Agent Tool**: Gathers trending topics from external sources
Content creator**: Writes the actual LinkedIn post content based on the topic
OpenAI**: Creates images to accompany the LinkedIn posts
SEO**: Generates relevant hashtags for the LinkedIn posts
Merge**: Combines the post content, image, and hashtags into a single package
LinkedIn page & LinkedIn profile**: Posts the content to both a LinkedIn company page and personal profile
Update row in sheet**: Marks the processed topic as "checked" in the Google Sheet
Support & Help
For n8n workflow questions: n8n Community
For LinkedIn API issues: LinkedIn Developer Portal
For Google Sheets integration: Google Sheets API Documentation
Support & Help
WhatsApp**: Chat on WhatsApp
Discord**: SpaGreen Community
Facebook Group**: SpaGreen Support
Website**: https://spagreen.net
Developer Portfolio**: Codecanyon SpaGreen