AI-Generated LinkedIn Posts with OpenAI, Google Sheets & Email Approval Workflow
VerifiedAutomates AI-generated LinkedIn posts from Google Sheets with email approval.
What this workflow does
This workflow pulls pending post ideas from Google Sheets, uses OpenAI to generate professional LinkedIn content, and routes it via Gmail for manual approval before optional posting.
It is designed for marketing teams and content creators who need structured AI assistance with review gates to maintain brand quality on LinkedIn.
Who is this for?
Marketing teams, social media managers, and content creators who regularly produce LinkedIn posts and need a structured approval step before publishing.
What problem it solves
Manually drafting LinkedIn content, formatting it, and routing it for approval is repetitive and slow. This workflow pulls ideas from a sheet, generates drafts with AI, and handles email approval in one automated flow.
What it automates
Weekly thought-leadership posts
A founder keeps post ideas in Google Sheets; the workflow generates professional drafts every Monday and emails them for quick approval before posting.
Campaign content batching
A marketing team adds campaign descriptions to a shared sheet; AI creates on-brand LinkedIn posts that go through email review before going live.
Consistent personal branding
An executive uses the sheet to store topics and instructions; the workflow produces ready-to-post content on a set schedule with built-in approval.
How the workflow works
The 6 nodes in this automation, in order.
- 1Google SheetsgoogleSheets
- 2HTTP RequesthttpRequest
- 3Gmailgmail
- 4LinkedInlinkedIn
- 5Basic LLM Chain@n8n/n8n-nodes-langchain.chainLlm
- 6OpenAI Chat Model@n8n/n8n-nodes-langchain.lmChatOpenAi
Apps & integrations used
How to set up AI-Generated LinkedIn Posts with OpenAI, Google Sheets & Email Approval Workflow
- 1Add a Schedule Trigger node and set your desired interval.
- 2Connect the Google Sheets node to read the first row where Status equals Pending.
- 3Add a Basic LLM Chain node using the OpenAI Chat Model to generate the post from description and instructions.
- 4Use a Set or Function node to format the generated text for the approval email.
- 5Connect the Gmail node to send the formatted content to the approver.
- 6Add the LinkedIn node (or HTTP Request) after approval to publish the post.
How to customize this workflow
- →Swap OpenAI Chat Model for another supported LLM provider
- →Change Schedule Trigger to a Webhook or Manual trigger
- →Replace Gmail approval with Slack or another notification node
- →Add an If node to skip posting for certain topics
AI-Generated LinkedIn Posts with OpenAI, Google Sheets & Email Approval Workflow: pros & cons
Pros
- +Combines AI generation with human approval in one flow
- +Uses familiar Google Sheets as the input source
- +Clear separation between draft creation and publishing
Cons
- –Still requires manual email approval for each post
- –LinkedIn posting step needs valid API credentials
- –OpenAI usage adds per-run cost
Frequently asked questions
It reads pending rows from Google Sheets, generates LinkedIn post text with OpenAI, emails it for approval, and can post to LinkedIn after approval.
User reviews
Verified reviews from the community shape this listing's rating.
Loading reviews…
Similar workflows
Other ai & llm automations worth a look.