Add weekly admin stats digest — email Kamsi a scrape summary after each run

[kamsirichard]

Context

After every scrape, ScoutBot has all the data it needs to answer useful questions: how many new opportunities were found? How many were removed as expired? Which sources produced the most results? Currently none of this is reported — it just runs silently.

Task

Add a short admin summary email sent to kamsirichard1960@gmail.com after each full scrape cycle.

Contents of the summary

• Total new opportunities added (Nigeria + International breakdown)
• Total entries removed (expired/closed)
• Top 3 sources by new entries this run
• Total subscribers (pulled from the Subscribers tab)
• Any hard bounces that occurred this run

Implementation notes

• Add a notify_admin() function in notify.py or a new admin_report.py
• Call it from run.py at the end of full_pipeline()
• Keep it simple: plain text or minimal HTML, no batching needed (1 recipient)
• Subject: ScoutBot Admin — Scrape Report [date]

Files to touch

• notify.py or new admin_report.py
• run.py

[kamsirichard]

Implemented as a monthly report (not after every scrape — monthly gives meaningful trends without 30 emails/month of noise).

What was added:

• admin_report.py — standalone script that connects to Google Sheets, collects stats for the last 30 days, and sends a formatted HTML email to kamsirichard1960@gmail.com
• .github/workflows/admin-report.yml — runs on the 1st of every month at 07:30 WAT (30 minutes after the daily scrape, so stats reflect fresh data). Can also be triggered manually from the Actions tab.

Email contains:

• Total new opportunities added last 30 days (Nigeria tab + International tab breakdown)
• Total entries currently live in the sheet
• Category breakdown of new entries
• Total active subscribers (from the form responses sheet)
• New bounce count this month

To trigger it manually at any time: Actions → ScoutBot — Monthly Admin Report → Run workflow.