Reddit Monitor with AI Analysis & Google Sheets Logging

Monitor multiple subreddits for relevant posts using AI-powered filtering, draft responses, and log everything to Google Sheets — all on autopilot.

What it does

This workflow watches Reddit via RSS feeds, uses an AI agent to evaluate each post against your criteria, drafts response comments for relevant posts, and sends them through a human approval step before logging to a Google Sheet.

Pipeline

1. Cron Trigger — Runs every hour (configurable)
2. Generate Feed URLs — Builds RSS feed URLs from your configured subreddit list
3. Iterate Subreddits — Loops through each subreddit feed
4. Parse RSS — Fetches the latest posts from each subreddit
5. Iterate Posts — Loops through each post in the feed
6. AI Analyzer — Evaluates each post for relevance based on your keywords and criteria, returning a relevance score, priority, and summary
7. Conditional Filter — Routes relevant posts forward, skips irrelevant ones
8. Response Drafter — AI drafts a concise Reddit comment for relevant posts
9. Human Approval — Review the post details, AI summary, and drafted response before approving
10. Google Sheets Logger — Approved posts are appended to a tracking spreadsheet with subreddit, title, link, priority, summary, and drafted response

Setup

A one-time setup flow creates a Google Sheet with headers and saves the credentials. Use the Configure Monitor interface to:

• Add or remove subreddits to watch
• Set keywords and relevance criteria for the AI filter
• Connect a Google Sheet for logging

Input

• Subreddits — Comma-separated list (e.g. technology, programming, automation)
• Keywords / Criteria — Natural language description of what posts you care about (e.g. "workflow automation, AI agents, n8n")

Output

• Google Sheet with columns: Subreddit, Title, Link, Priority, AI Summary, Drafted Response
• Activity logs showing skipped posts with reasons
• Approval requests for human review of relevant posts