Back to Templates

Transform Reddit Discussions into LinkedIn Post Ideas with GPT-4o and Google Sheets

Created by

Created by: clearcue.ai || clearcue

clearcue.ai

Last update

Last update a day ago

Share


Who’s it for

This workflow is for marketers, founders, and content strategists who want to identify business opportunities by analyzing Reddit discussions. It’s ideal for B2B, SaaS, and tech professionals looking for fresh LinkedIn post ideas or trend insights.

How it works / What it does

This workflow automatically:

  1. Fetches Reddit posts & comments based on a selected subreddit and keyword.
  2. Extracts pain points & insights using OpenAI (ChatGPT) to identify key frustrations and trends.
  3. Generates LinkedIn post ideas with headlines, hooks, and CTAs tailored for professional audiences.
  4. Saves all results into Google Sheets for easy tracking, editing, and sharing.

It uses AI to turn unstructured Reddit conversations into actionable content marketing opportunities.

How to set up

  1. Clone this workflow in your n8n instance.
  2. Configure credentials:
    • Reddit OAuth2 (for fetching posts & comments)
    • OpenAI API key (no hardcoding—use credentials in n8n)
    • Google Sheets OAuth2 (for output)
  3. Run the workflow or trigger it using the built-in Form Trigger (provide subreddit & keyword).
  4. Check the generated Google Sheet for analyzed insights and post suggestions.

Requirements

  • n8n (self-hosted or cloud)
  • Reddit account with API credentials
  • OpenAI API key (GPT-4o recommended)
  • Google Sheets account

How to customize the workflow

  • Change the AI prompt to adjust tone or depth of insights.
  • Add filtering logic to target posts with higher engagement.
  • Modify the Google Sheets output schema to include custom fields.
  • Extend it with Slack/Email notifications to instantly share top insights.