AI Agents

Extract Reddit Posts, Summarize with AI, and Save to Google Sheets

17 nodes 290 143 Automatic trigger
Download

Workflow Description

An automation that retrieves Reddit posts about specific topics, analyzes them using advanced language models, generates concise summaries, and automatically stores the results in Google Sheets for easy tracking and analysis of community discussions.

How it works

  1. 1.Manually trigger the automation and search for Reddit posts using defined keywords or subreddits
  2. 2.Process and filter extracted Reddit data based on relevance and specified criteria
  3. 3.Summarize post content using Open Router's language model chain for intelligent extraction
  4. 4.Save summaries and metadata automatically to a Google Sheets table for ongoing reference

Use cases

  • Monitor conversations and trends about your brand or product across Reddit communities
  • Collect customer opinions and feedback from Reddit and organize them in a spreadsheet for analysis
  • Track common user questions and pain points in your industry and document them systematically
  • Build a research database of relevant Reddit content for product development and market insights

Requirements

  • Active Google Sheets account with permissions to create and modify spreadsheets
  • Reddit Developer account with valid API credentials and application token
  • Open Router API key to access advanced language models for summarization
  • Knowledge of Reddit search syntax to target relevant posts and communities

Service Value

Ideal as a smart automation service combining integrations and AI to produce ready-to-use results.

Apps Used

LLM Chain Google Sheets Reddit Lm Chat Open Router

Details

Trigger Automatic trigger
Nodes 17
Apps 4
Views 290
Downloads 143

How to Use

  1. 1.Click "Download Template"
  2. 2.Open your n8n dashboard
  3. 3.Go to Workflows > Import from File
  4. 4.Select downloaded file and configure credentials

Nodes Used (17)

/

When clicking ‘Test workflow’

Manual Trigger

#1

Post Summarization

Chain Summarization

#2

Merge Input

Merge

#3

Output The Results

Google Sheets

#4

Merge 3 Inputs

Merge

#5

Filter Posts By Features

If

#6

Filter Posts By Content

If

#7

Select Key Fields

Set

#8

Get Posts

Reddit

#9

Sticky Note

Sticky Note

#10

Sticky Note2

Sticky Note

#11

Sticky Note3

Sticky Note

#12

OpenRouter Chat Model

Lm Chat Open Router

#13

OpenRouter Chat Model1

Lm Chat Open Router

#14

Basic LLM Chain

LLM Chain

#15

Edit Fields

Set

#16

Edit Fields1

Set

#17

Similar Templates

Process requests intelligently in batches with OpenAI

45 nodes

Extract Drive documents and automatically schedule Calendar events

28 nodes

Index Notion pages as vector embeddings in Supabase with OpenAI

9 nodes

Process Customer Inquiries with OpenAI Assistant and Store Responses in Airtable

34 nodes

Intelligent search engine powered by AI with web discovery and content extraction

17 nodes

Automate Google Sheets with Intelligent Agents

11 nodes