The Composer's Brain
Composer's BrainStudio
Admin area

Opportunities ingestion

Reads the latest monthly Excel from the Contests pipeline and upserts to the opportunities table. Runs automatically the 1st of each month at 7am EST.

12
Active opportunities
2026-04-01
Last sync
May 1, 7am
Next auto-sync

Recent ingestion runs

Each row corresponds to one monthly Excel parse.

  • 2026-04-01
    +12 new · 38 updated · 8 archived
    OK
  • 2026-03-01
    +14 new · 42 updated · 5 archived · 1 errors
    Warnings
  • 2026-02-01
    +18 new · 36 updated · 4 archived
    OK
  • 2026-01-01
    +16 new · 31 updated · 3 archived
    OK
How this works.The existing fully-automated Contests skill runs on the 1st of every month at 7am EST. After it sends the GHL email and Discord post, an extra step (`scripts/ingest_opportunities.py`) parses the resulting Excel into the `opportunities` table here. Stale rows (deadline more than 60 days past) are archived, not deleted, so fellow save-as-contact links don't 404. If ingestion fails, you get a separate Resend alert.