LLM_V2 Reddit Tracker - Insights & Automation

What it is (quick):

LLM_V2 Reddit Tracker is a no-code Google Sheets automation that pulls Reddit posts for your keyword list, classifies queries (What/How/Why/etc.), groups by word length, and generates a clean “Top 3 posts” insights report — automatically every day at 9 AM.

Who it’s for:

SEOs, content & social researchers, product teams, and agencies who want a fast, repeatable way to surface community trends, content gaps, and high-engagement Reddit threads for content ideation and competitive insights.

Core features:

• Live Reddit fetch — Query Reddit API for any list of keywords and pull top posts.
• Query classification — Auto-tag each query by type (What / How / Why / Can / Is / etc.).
• Word-grouping — Auto-group queries by length (1, 2–4, 5–8, 9–12, 13–20, 20+).
• Top-3 Insights — Produces a “Reddit Insights” sheet listing the top 3 posts per query (titles, upvotes, comments, subreddits, latest date).
• Daily scheduling — Set a daily trigger (9 AM) so the sheet refreshes automatically.
• Custom date ranges — Presets (7d, 28d, 3/6/12/16 months, lifetime) + datepicker for custom ranges.
• Logging & monitoring — Detailed Log sheet for runs, errors, and status.
• Simple UI menu — “LLM V2” menu in Sheets: fetch, generate insights, set/remove triggers, clean data.
• Rate-limit safe — built-in pauses between requests to avoid API throttling.
• Exportable reports — Insights sheet ready to export as PDF for client deliverables.
• No-code setup — All runs inside Google Sheets + Apps Script; no external hosting needed.

Technical & setup notes:

• Uses Reddit API (Client ID & Secret) — create a Reddit App and paste keys into the Apps Script.
• Requires a Google Sheet (Queries tab) and Apps Script authorization.
• Includes datepicker HTML for custom ranges and clear menu-driven operations.
• Simple troubleshooting & maintenance guide included (token errors, throttling, trigger checks).

Deliverables (what you get):

• Google Sheet template with Apps Script (Code.gs + datepicker.html) pre-installed.
• Step-by-step SOP (setup, authorize, first run, schedule trigger).
• “Reddit Insights” generator that creates a ready-to-share sheet (Top 3 posts per query).
• Log sheet + simple error fixes guide.
• Optional add-on: 30-min setup support (sold separately).

Why this matters:

Stop manually scraping community sites for content ideas. This tracker gives you a daily pulse of Reddit conversations around your target queries — perfect for content ideation, product feedback, social listening, and catching trends before competitors.