Auto-Generate & Publish LinkedIn Posts from keyword
š¦ What You Get
- Ready-to-import n8n workflow (.json file)
- Complete guide (PDF)
š Why This Workflow Matters
Writing and publishing LinkedIn content consistently takes effort and time. This automation reduces the entire workflow to just one task: entering a keyword or post idea into Google Sheets. From there, everything is handledāwriting, formatting, posting, and updating status.
š Tools Used
- Google Sheets (content input & tracking)
- n8n (workflow automation)
- Gemini AI (for generating posts)
- LinkedIn API (to publish automatically)
- Code block (regex cleaning for proper JSON formatting)
š How It Works
- Add a new post idea (keyword/title) to Google Sheets
- n8n detects the āPost Pendingā status
- Gemini AI writes a 3ā4 paragraph LinkedIn post with emojis, hooks, and hashtags
- Regex Code Node sanitizes the post for LinkedIn API compliance
- Post is published directly to LinkedIn
- Sheet is updated to reflect āPostedā status and log the content
š¬ Included Prompt Logic (Gemini AI)
Your AI assistant is trained to:
- Write a LinkedIn-style post with a hook, content, and closing question
- Include relevant hashtags and emojis
- Avoid formatting characters that break JSON or LinkedIn
- Keep content within 3000 characters
- Escape newlines for API compatibility
ā Features & Benefits
- Fully automated post creation and publishing
- Built-in formatting and error-handling
- Easy-to-manage content pipeline via Google Sheets
- Consistent, high-quality tone using Gemini AI
- Scales easily for brands, creators, and agencies
šÆ Who This Is For
- Busy solopreneurs or founders
- Personal brand managers
- Content creators & freelancers
- LinkedIn VAs & ghostwriters
- Social media marketing teams
ā ļø Built-in Error Handling
- Posts only run if status is āPendingā and title is not blank
- Bad AI responses are filtered out before posting
- Regex code ensures newlines and characters donāt break JSON
- LinkedIn API failures leave post as āPendingā for safe retry
š Final Results Youāll See
- LinkedIn posts written and published with zero writing work
- Sheets act as a command dashboard to track all content
- Posts follow brand tone and formatting
- Perfect for content batching or scaling across multiple brands
š Contact & Learn More
- š Website:www.thinknlink.in
- šø Instagram:instagram.com/thinknlink.in
- ā¶ļø YouTube:Yashraj | AI Solution - Thinknlink Channel
Letās automate your personal brandāone post at a time.
This workflow automates your entire LinkedIn posting processāfrom writing to publishingāusing Google Sheets as the content command center and Gemini AI as your LinkedIn ghostwriter. Designed for solopreneurs, marketers, and content teams who want consistent, on-brand posts without spending hours each week.