
AI-Powered Social Post Generator: From Spreadsheet to Socials in Seconds!
Automatically create short, engaging, and fact-based posts (with emojis!) based on your content ideas, and publish them to the right platform.
- Google Sheets
- Gemini
- n8n
AI-Powered Social Post Generator
Automatically turn content ideas in Google Sheets into engaging, platform-specific social media posts using Google Gemini, with publishing routed to LinkedIn or X.
Category: AI Agents Tools: Google Sheets, Google Gemini, LinkedIn, X (Twitter)
1. Project Overview
This workflow automates social media content creation and publishing. It reads content ideas and the selected platform from Google Sheets, uses Google Gemini to generate a short, fact-based post, and routes the result to the appropriate social network.
2. The Challenge
Creating and publishing social media content manually involves several repetitive steps:
- Reviewing content ideas in a spreadsheet.
- Writing posts suitable for each social platform.
- Checking which ideas have already been published.
- Copying and pasting content into the correct platform.
- Keeping track of publishing status.
These tasks can slow down content production and create unnecessary manual work.
3. The Solution
An AI-powered workflow connects Google Sheets with Google Gemini and social media publishing tools.
The workflow starts manually when the user clicks Test workflow. It reads the spreadsheet, checks publication status, generates content with Gemini, and uses conditional logic to route the post to LinkedIn or X according to the selected platform.
4. How the Workflow Works

- Manual Trigger: The user starts the workflow with a click.
- Read Google Sheets: Retrieve content ideas and their target platforms.
- Check Publishing Status: Select ideas marked
0, indicating they have not yet been published. - Generate Social Content: Google Gemini creates a concise, fact-based post with suitable emojis.
- Route by Platform: Conditional branches determine whether the post should go to LinkedIn or X.
- Publish the Post: The appropriate platform integration handles publishing.
5. Workflow

6. Key Features
- Spreadsheet-Driven Content: Manage content ideas and platform choices in one place.
- AI-Assisted Writing: Generate concise, engaging posts with Google Gemini.
- Publication Status Filtering: Avoid selecting ideas already marked as published.
- Platform-Based Routing: Send content to LinkedIn or X based on the selected destination.
- One-Click Execution: Start the workflow manually when content is ready.
7. Business Value
The workflow reduces repetitive writing and publishing tasks, makes content production more organized, and simplifies the process of turning spreadsheet ideas into social media posts.
8. Final Outcome
A streamlined content workflow that connects Google Sheets, Google Gemini, and social media publishing integrations—helping users move from a content idea to a platform-specific post with less manual effort.