Back to projects
Shipped · Live Project 05 / 13

Competitor Intel Tracker

An automated competitive-intel system that monitors 21 lending-software competitors across 9 data sources, summarizes findings with AI, and publishes two Confluence reports every Monday morning — a per-competitor intel page and an industry-trends analysis.

Apps Script OpenAI Confluence API
Role
Solo design & build
Coverage
21 competitors · 9 sources
Stack
Apps Script · OpenAI · Confluence
Status
Runs weekly

01 Overview

Leadership needed a current read on the competitive landscape, but compiling it by hand across many competitors and sources was slow and never quite up to date.

This system automates the whole loop: every Monday morning it collects fresh signal on 21 lending-software competitors from 9 data sources, summarizes it with AI, and publishes two Confluence reports — a per-competitor intel page and a rolling industry-trends analysis — with zero manual compilation.

02 How it works

A 9-source collection pipeline runs with cascading fallbacks to conserve API quota — Google News RSS is the primary source, and a paid Custom Search is only called when needed — alongside blog scraping, job-posting monitoring, review-site monitoring, and hash-based page-change detection. Collected items are deduped with MD5, sorted into a 6-category keyword taxonomy, and prioritized by competitor tier.

An OpenAI gpt-4o-mini step writes "Morning Brew"-style 2–3 sentence summaries, batched by competitor, for roughly $0.50–1.00 per week with rate-limiting. Results publish to Confluence via both the v1 and v2 APIs: a fresh weekly intel page plus a rolling trends page with direction badges and a 4-week heatmap. Everything fires on scheduled Monday-morning triggers.

03 Engineering highlights

  • 9-source collection pipeline with cascading fallbacks (Google News RSS primary, Custom Search only when needed) plus blog scraping, job postings, review monitoring, and hash-based change detection.
  • gpt-4o-mini "Morning Brew"-style summaries batched by competitor — ~$0.50–1.00/week with rate-limiting.
  • Dual Confluence publishing (v1 + v2 APIs): a fresh weekly intel page + a rolling trends page with direction badges and a 4-week heatmap.
  • MD5 dedup, a 6-category keyword taxonomy, and tier-based prioritization.
  • Fully scheduled — runs unattended on Monday-morning triggers.

04 Outcome

Why it matters

Gives leadership a real-time competitive landscape every Monday with zero manual compilation — for about a dollar a week.