# AI Social Media Posting with Approval

**Category:** Marketing  
**Tools:** Google Sheets, OpenAI, n8n  
**Nodes:** 35  
**Built by:** Forgent Systems

Generates posts and images for LinkedIn, X and Instagram with AI, holds them in a Google Sheet for approval, then publishes approved posts and saves the live links.

![Workflow](preview.webp)

## How it works

1. On schedule, topics are read from the sheet and prompts are generated.
2. AI writes platform-specific copy and creates an image.
3. Drafts are saved to the sheet for approval.
4. Approved posts are published to each platform.
5. Post URLs are written back to the sheet.

## Use cases

- Social media agencies
- Founders and personal brands
- Consistent content calendars

## Data setup

**Google Sheets** (tab: columns)

- **Auto social media post → Sheet1**: `Id`, `LinkedIn Content`, `LinkedIn images url`, `Twitter Content`, `Twitter images url`, `Prompt Status`, `Posting Status`, `Linkedin Post URL`, `Posted Date`, `Twitter Post URL`, `LinkedIn images prompt`, `LinkedIn Content Prompt`, `Instagram Content Prompt`, `Instagram images prompt`, `Twitter images prompt`, `Twitter Content Prompt`, `Instagram Content`, `Instagram images url`, `Instagram Post URL`

## Setup

1. In n8n open **Workflows → Import from File** and choose `workflow.json`.
2. Connect these credentials:
   - Facebook Graph account
   - Google Sheets account
   - Http Bearer Auth account
   - LinkedIn account
   - OpenAI account
   - X OAuth account
   - X account
3. Point the Sheets / Airtable / Drive / Slack nodes at your own resources (structure above).
4. Replace placeholder emails, phone numbers and `YOUR-FORM-ID` links with your own.
5. Times use the America/New_York timezone and dates use MM/DD/YYYY. Adjust if needed.
6. Run a test execution, then activate.

## Nodes

- **Schedule Trigger** — `n8n-nodes-base.scheduleTrigger`
- **Create a post** — `n8n-nodes-base.linkedIn`
- **Schedule Trigger1** — `n8n-nodes-base.scheduleTrigger`
- **Loop Over Items** — `n8n-nodes-base.splitInBatches`
- **Prompt Generate** — `@n8n/n8n-nodes-langchain.openAi`
- **Schedule Trigger2** — `n8n-nodes-base.scheduleTrigger`
- **Check Platform** — `n8n-nodes-base.switch`
- **Append LinkedIn Data** — `n8n-nodes-base.googleSheets`
- **Append Twitter Data** — `n8n-nodes-base.googleSheets`
- **Loop** — `n8n-nodes-base.splitInBatches`
- **Loop Over Items2** — `n8n-nodes-base.splitInBatches`
- **Switch According Platform** — `n8n-nodes-base.switch`
- **Image Generate** — `n8n-nodes-base.httpRequest`
- **Content for Twitter** — `@n8n/n8n-nodes-langchain.openAi`
- **Content For LinkedIn** — `@n8n/n8n-nodes-langchain.openAi`
- **Create Tweet** — `n8n-nodes-base.twitter`
- **Append Linkedin Post Url** — `n8n-nodes-base.googleSheets`
- **Append Twitter Post Url** — `n8n-nodes-base.googleSheets`
- **Download Image** — `n8n-nodes-base.httpRequest`
- **Upload Image** — `n8n-nodes-base.httpRequest`
- **Download Img** — `n8n-nodes-base.httpRequest`
- **Get Post Data** — `n8n-nodes-base.googleSheets`
- **Get Content + Image Prompt** — `n8n-nodes-base.googleSheets`
- **Append Content + Img Prompt** — `n8n-nodes-base.googleSheets`
- **Get Topic + Img Desc** — `n8n-nodes-base.googleSheets`
- **Content for Instagram** — `@n8n/n8n-nodes-langchain.openAi`
- **Append instagram Data** — `n8n-nodes-base.googleSheets`
- **Set Image & Caption** — `n8n-nodes-base.set`
- **Creating Container ID** — `n8n-nodes-base.facebookGraphApi`
- **Facebook Graph API** — `n8n-nodes-base.facebookGraphApi`
- **Append instagram Post Url** — `n8n-nodes-base.googleSheets`
- **HTTP Request** — `n8n-nodes-base.httpRequest`
- **Split Items** — `n8n-nodes-base.code`
- **Split Data** — `n8n-nodes-base.code`
- **Sticky Note** — `n8n-nodes-base.stickyNote`
