Repurpose Reddit Posts into AI Tweets with Gemini and Google Sheets

Automatically turns trending Reddit posts into punchy, first-person tweets powered by Google Gemini AI, Reddit, and Twitter API, with Google Sheets logging.

🧩 Overview

This workflow repurposes Reddit content into original tweets every few hours.
It’s perfect for creators, marketers, or founders who want to automate content inspiration while keeping tweets sounding human, edgy, and fresh.

Core automation loop:

Fetch trending Reddit posts from selected subreddits.
Use Gemini AI to write a short, first-person tweet.
Check your Google Sheet to avoid reusing the same Reddit post.
Publish to Twitter automatically.
Log tweet + Reddit reference in Google Sheets.

🧠 Workflow Diagram

🪄 How It Works

1️⃣ Every 2 hours → the workflow triggers automatically.
2️⃣ It picks a subreddit (like r/automation, r/n8n, r/SaaS).
3️⃣ Gemini AI analyzes a rising Reddit post and writes a fresh, short tweet.
4️⃣ The system checks your Google Sheet to ensure it hasn’t used that Reddit post before.
5️⃣ Once validated, the tweet is published via Twitter API and logged.

🧠 Example Tweet Output

📊 Logged Data (Google Sheets)

Each tweet is automatically logged for version control and duplication checks.

| Date | Subreddit | Post ID | Tweet Text | |------|------------|----------|-------------| | 08/10/2025 | n8n_ai_agents | 1o16ome | Just saw a wild n8n workflow on Reddit... |

⚙️ Key Components

| Node | Function | |------|-----------| | Schedule Trigger | Runs every 2 hours to generate a new tweet. | | Code (Randomly Decide Subreddit) | Picks one subreddit randomly from your preset list. | | Gemini Chat Model | Generates tweet text in first person tone using custom prompt rules. | | Reddit Tool | Fetches top or rising posts from the chosen subreddit. | | Google Sheets (read database) | Keeps a record of already-used Reddit posts. | | Structured Output Parser | Ensures consistent tweet formatting (tweet text, subreddit, post ID). | | Twitter Node | Publishes the AI-generated tweet. | | Append Row in Sheet | Logs the tweet with date, subreddit, and post ID. |

🧩 Setup Tutorial

1️⃣ Prerequisites

| Tool | Purpose | |------|----------| | n8n Cloud or Self-Host | Workflow execution | | Google Gemini API Key | For tweet generation | | Reddit OAuth2 API | To fetch posts | | Twitter (X) API OAuth2 | To publish tweets | | Google Sheets API | For logging and duplication tracking |

2️⃣ Import the Workflow

Download Reddit Twitter Automation.json.
In n8n, click Import Workflow → From File.
Connect your credentials:
Gemini → Gemini
Reddit → Reddit account
Twitter → X
Google Sheets → Gsheet

3️⃣ Configure Google Sheet

Your sheet must include these columns:

| Column | Description | |--------|--------------| | PAST TWEETS | The tweet text | | Date | Auto-generated date | | subreddit | Reddit source | | post_id | Reddit post reference |

4️⃣ Customize Subreddits

In the Code Node, update this array to choose which subreddits to monitor:

const subreddits = [ "n8n", "microsaas", "SaaS", "automation", "n8n_ai_agents" ];