# 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.

Section: AI Agents

Page: https://mburhan.com/case/ai-agent-ai-powered-social-post-generator-from

## 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

Image: n8n workflow (https://mburhan.com/uploads/5b2d8ac3cc502d09241ff352.png)

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

## 5. Workflow

Image (https://mburhan.com/uploads/a530fcedf6976bf8f8966cb1.png)

## 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.
