Reddit Crawler

AI-powered Reddit lead discovery tool.

What is it?

A lightweight Python script that crawls Reddit posts from target subreddits, uses AI to identify posts relevant to your product, and outputs leads to Google Sheets.

Why Google Sheets?

I originally built this as a full-stack app with FastAPI, PostgreSQL, and a custom UI. It took a day and was still buggy.

Then I realized: I'm the only user. I don't need authentication, a database, or a fancy interface. I need relevant posts in a spreadsheet.

Rebuilt it in 2 hours. Works perfectly.

Read the full story →

How it Works

Cron (daily)
    │
    ▼
┌─────────────┐     ┌─────────────┐     ┌─────────────┐
│ Crawl Reddit│────▶│ AI Classify │────▶│ Push to     │
│ (PRAW)      │     │ (GPT-4o)    │     │ Google Sheet│
└─────────────┘     └─────────────┘     └─────────────┘

Quick Start

git clone https://github.com/your-username/reddit-crawler
cd reddit-crawler
cp .env.example .env
# Edit .env with your credentials
docker-compose up -d

Links

• Setup Guide
• Configuration
• GitHub Repository