01-projects/process-newsletter

README

2026-04-11·project·status: prototype-complete

Process Newsletter — project README

Goal

Ingest email newsletters from a whitelisted set of senders into the vault as structured assessment notes, with bias and sponsor flagging. Separate from Substack-specific tooling — this works on any newsletter that lands in ben@raydata.co regardless of publisher (Substack, Ghost, Mailchimp, self-hosted).

Companion skill: ~/.claude/skills/process-newsletter/SKILL.md.

Status

Whitelist — locked in 2026-04-11

K = keep, backfill history + ongoing watch

Sender Newsletter Typical format Notes
email@stratechery.com Stratechery (Ben Thompson) thought-leadership 60 actual in inbox (2026-04-12 discovery; 3 batch tasks created). Original "201+ in history" estimate was archive-based, NOT inbox-bounded.
seattledataguy@substack.com SeattleDataGuy (Ben Rogojan) hybrid ✅ backfill complete (8 articles + 1 pre-existing)
notboring@substack.com Not Boring (Packy McCormick) hybrid (long-form + Friday optimism curation) 28 actual in inbox (2026-04-30 discovery; 1 batch task created, 26 already filed). Original "201+ in history" estimate was archive-based.
practicaldatamodeling@substack.com Practical Data Modeling (Joe Reis) thought-leadership, series-based 32 actual in inbox (2026-04-30 discovery; 1 new batch task created, 23 already filed). Original "~20+" was closer but still off. ⚠️ paid sub lapsed 2026-04-24 — flagged to founder for resubscribe decision.
analyticsengineeringroundup@substack.com Analytics Engineering Roundup curation ~20+ in history (estimate — not yet discovery-scanned; assume lower per inbox-bounded pattern below)
hello@every.to Every multi-author thought-leadership 201+ in history (estimate — not yet discovery-scanned; assume MUCH lower per inbox-bounded pattern below)
hello@ship30for30.com Ship30for30 (Start Writing Online) writing craft / marketing 30+/180d
writewithai@substack.com Write With AI writing with AI tools 8+/180d
michaeldean9@substack.com Essay Architecture (Michael Dean) essay writing craft curation-heavy
ark@arkinvest.com ARK Invest (Cathie Wood) investment commentary weekly stock commentary
newsletter@commoncog.com Commoncog (Cedric Chin) thought-leadership, series-based ~201+ in history estimate — actual is inbox-bounded (founder re-subscribed 2026-04-15, so inbox has from-that-date forward). Operator's field manual; tacit knowledge, expertise, sensemaking. Highly relevant to RDCO agent-deployer positioning.
secretcfo@mail.beehiiv.com CFO Secrets (The Secret CFO, anon) thought-leadership (multi-cadence: Sat Playbook + Tue Mailbag + monthly Spotlight + biweekly Boardroom Brief) Added 2026-05-11. Brother-in-law recommendation. Sponsor: Campfire (Series A close-the-books software; author is investor/user, disclosed openly across all 4 AI-for-CFOs articles). Inbox starts 2026-05-11 (founder just subscribed); back-catalog only via WebFetch from public archive at cfosecrets.io. Strong harness-engineering thesis convergence from CFO seat. AI-for-CFOs I-IV synthesis already filed at 06-reference/2026-05-11-cfo-secrets-ai-for-cfos-series-synthesis.md. Sponsor update 2026-06-02: a NEW third-party paid placement — Zip (continuous-close software) — appeared in the Tue Mailbag, distinct from the known Campfire tie (no disclosed author investor/user relationship; clean paid block). Watch whether Zip recurs or rotates back to Campfire. Sponsor update 2026-06-06: a THIRD distinct paid placement — Pulley (cap-table/equity-management software) — appeared in the Sat Playbook "Permission to Grow" issue, again a clean paid block with no disclosed author relationship. Pattern now confirmed: CFO Secrets rotates third-party sponsors (Campfire→Zip→Pulley); treat each issue's sponsor as per-issue, not a standing relationship. Sponsor update 2026-06-09: a FOURTH distinct paid placement — Stuut (stuut.ai, AI accounts-receivable agent) — appeared in the Tue Mailbag, clean third-party block with no author relationship. The "three rotating sponsors" framing is now STALE: CFO Secrets runs a broad rotating clean-third-party ad pool, so treat each issue's sponsor as UNKNOWN-until-scanned (do not assume Campfire/Zip/Pulley). Sponsor update 2026-07-07: a FIFTH distinct paid placement — Una (benchmark.una.ai, benchmark pricing intelligence software) — appeared in the Tue Mailbag, clean third-party block with no author relationship. Rotating ad pool now 5+ confirmed distinct sponsors: Campfire, Zip, Pulley, Stuut, Una. Sponsor update 2026-07-14: a SIXTH distinct paid placement — Ledge (ledge.co) — appeared in the Tue Mailbag "Cashing out" issue, clean third-party block with no author relationship. Rotating ad pool now 6+ confirmed distinct sponsors: Campfire, Zip, Pulley, Stuut, Una, Ledge. Sponsor update 2026-07-18: a SEVENTH distinct paid placement — Summation (AI Analyst product, direct-to-CFO positioning) — appeared in the Sat Playbook "The trouble with business partners" issue, clean third-party block with no author relationship. Rotating ad pool now 7+ confirmed distinct sponsors: Campfire, Zip, Pulley, Stuut, Una, Ledge, Summation. Sponsor update 2026-08-18: an EIGHTH distinct paid placement — Nominal (agentic close/consolidation software) — appeared in the Tue Mailbag "Nobody bid... but whose fault is it?" issue, clean third-party block with no author relationship. Rotating ad pool now 8+ confirmed distinct sponsors: Campfire, Zip, Pulley, Stuut, Una, Ledge, Summation, Nominal. Sponsor update 2026-08-25: a NINTH distinct paid placement — CloudZero (AI-cost-to-board-ROI deck pitch) — appeared in the mailbag "fake news metrics" issue, clean third-party block with no author relationship. Rotating ad pool now 9+ confirmed distinct sponsors: Campfire, Zip, Pulley, Stuut, Una, Ledge, Summation, Nominal, CloudZero. New mini-series 2026-09-05: "Inheriting a Shitshow Finance Function" (Sat Playbook cadence, Part I of IV) launched with Stuut in a case-study sponsor block — Stuut is an already-known pool member (first seen 2026-06-09), not a new sponsor. Per the "Building FP&A"/Man Utd precedent, watch installments II-IV for whether Stuut recurs as a de facto series-standing sponsor rather than rotating out. Sponsor update 2026-09-08: a TENTH distinct paid placement — Aleph (getaleph.com, finance-ops AI platform pitching a "Claude skills for finance" lead-magnet guide) — appeared in the Tue Mailbag "Your AI product has a fake mustache" issue, clean third-party block with no author relationship. Notable beyond the rotation count: Aleph's pitch is a vertical-packaged Claude-Skills product, directly adjacent to RDCO's own skills-over-commands practice and phData's finance-function client base — a competitive-positioning signal, not just a sponsor to disclose. Rotating ad pool now 10+ confirmed distinct sponsors: Campfire, Zip, Pulley, Stuut, Una, Ledge, Summation, Nominal, CloudZero, Aleph. This issue was the regular Tue Mailbag, not a "Shitshow" series installment — no data point yet on whether Stuut recurs in Part II. Series update 2026-09-12: "Inheriting a Shitshow Finance Function" Part II ("Bring out the dead") confirmed — Stuut recurred as sponsor, now 2 of 2 installments. Matches the "Building FP&A"/Summation and Man Utd/Summation pattern: watch Parts III-IV for whether Stuut graduates to de facto series-standing sponsor for this series specifically. Series update 2026-09-19 (confirmed): Part III ("Keeping the lights on (while everything else burns)," 5-lever Repair Mode operating model) confirmed — Stuut recurred a THIRD time, now 3 of 3 installments. Pattern is now firmly confirmed, not just suspected: treat "Inheriting a Shitshow Finance Function" as having Stuut as its de facto standing sponsor, same tier of confidence as Summation/Building FP&A and Summation/Man Utd. Watch Part IV to see if it holds at 4 of 4. Series-sponsor exception 2026-07-25: within the "Building FP&A" mini-series specifically, Summation has sponsored 3 of 4 installments (II, III, IV) — this breaks the "rotate per-issue, unknown until scanned" framing for that series. Treat "Building FP&A" as having a de facto standing sponsor (Summation) unless a future installment breaks the pattern; the broader rotating-pool framing still holds for other CFO Secrets cadences (Sat Playbook, Tue Mailbag outside this series, Boardroom Brief). Sponsor update 2026-08-22: Summation recurred a THIRD time overall, and a SECOND time within a different mini-series — the Manchester United stadium CapEx breakdown — suggesting Summation may be graduating from a single-series exception to a broader standing relationship across CFO Secrets' business-history / decision-breakdown pieces specifically (as opposed to Sat Playbook / Tue Mailbag generally). Watch the next 2-3 business-history-format issues to confirm. Sponsor update 2026-08-29 (confirmed): Summation recurred a FOURTH time overall and a THIRD time within the Manchester United series specifically (Parts I, III, IV of the valuation-methodology breakdown). The pattern is now firmly confirmed, not just suspected: Summation is CFO Secrets' de facto standing sponsor for long-form business-history/decision-breakdown pieces. Treat future business-history-format issues as Summation-sponsored by default (verify, don't assume unsponsored) — the broader rotating-pool framing still holds for Sat Playbook/Tue Mailbag/Boardroom Brief outside this format.
mostlymetrics@mail.mostlymetrics.com Mostly Metrics (CJ Gustafson, @cjgustafson222) hybrid (bangerz + research/reports + how-to + IPO S1 breakdowns + "Run the Numbers" podcast) Added 2026-05-11. CFO Secrets-bundled subscription. Sponsors visible: Brex / Intuit / Samsara / Rivian / MLB / Abacum (added 2026-05-24, FP&A SuiteApp / NetSuite-stack play) / Mostly Talent (added 2026-05-28 — CJ's own recruiting arm = self-consulting, NOT third-party; flag accordingly when seen) / Koyfin (added 2026-08-02 — named "data partner" with an explicit affiliate link (?via=metrics) in the weekly benchmarks issue, first time flagged as a partner relationship rather than a silent data-source caption; CJ has a commercial incentive to keep citing Koyfin as the benchmark source) / Rillet (added 2026-08-20 — the "21 Interview Questions to Hire a Great Controller" post was originally written for Rillet's own "Close Club" community and republished here; treat as content-partnership/cross-promo, not a clean paid block). Startup/tech CFO audience (vs CFO Secrets' growth-stage focus — pair them). Voice study for Sanity Check. Free tier active; paid tier on hold per founder 2026-05-11 (re-evaluate after 4-6 weeks of free issues). Inbox starts 2026-05-11.

⚠️ Count-before-budget rule (added 2026-04-30)

The original "N+ in history" estimates in the K table were Substack-archive-based, NOT Gmail-inbox-bounded. Real inbox counts have come back substantially smaller (Stratechery: 60 vs 201+ estimate; PDM: 32 vs 20+ estimate; Not Boring: 28 vs 201+ estimate). The gap is because Gmail only has from-subscription-date forward, not the sender's full archive.

Rule for remaining un-scanned senders (Every, Commoncog, Analytics Engineering Roundup, ARK Invest, Write With AI, Ship30for30, Essay Architecture): run discovery with --dry-run semantics first — count messages in inbox BEFORE planning batch sizes. If count is small (<20), skip the batch-task overhead and process inline via Mode 3 (Backfill, legacy small-sender path). Don't allocate 10+ batch tasks for a sender that only has 25 messages in the inbox.

Implication: the total backfill work is significantly smaller than the README originally implied. Prioritize the per-sender deep-fetch quality (sponsor detection, RDCO mapping discipline) over volume planning.

F = follow-forward only, no backfill (watch from now onward)

Sender Newsletter Typical format
theinnermostloop@substack.com Innermost Loop (Alex Wissner-Gross) thought-leadership
dataengineeringcentral@substack.com Data Engineering Central thought-leadership
dataengineeringweekly@substack.com Data Engineering Weekly (Ananth Packkildurai) curation
technically@substack.com Technically thought-leadership
news@alphasignal.ai AlphaSignal curation (AI/ML news)
lon@dataelixir.com Data Elixir curation (data science/ML news) — founder will resubscribe to ben@raydata.co; currently hits personal inbox
semistructured@substack.com Semi-Structured (Jonathan Natkins) thought-leadership (data infrastructure for AI agents) — added 2026-04-12

Known sender-specific gotchas (learned from SDG backfill)

Innermost Loop — timestamp vs content-date offset (added 2026-08-06)

SDG — SeattleDataGuy (fully backfilled)

PDM — Practical Data Modeling (Joe Reis) — partial backfill, paid sub lapsed 2026-04-24

Not Boring (Packy McCormick) — partial backfill, ongoing watch

CFO Secrets — "Inheriting a Shitshow Finance Function" series CLOSED at 4/4 Stuut (added 2026-09-26)

CFO Secrets — sponsor pool 11th member (added 2026-09-22)

ARK Invest — Gmail body is teaser-only, source site Cloudflare-blocked (added 2026-09-22)

Every — sponsor observation (added 2026-08-20)

Patterns to watch for in other senders (not yet backfilled)

AlphaSignal — sponsor pair broke after 2 days (2026-09-02 → 2026-09-03)

Every — live-session/Camp promo triage (added 2026-09-04)

Data Engineering Central — Delta Lake standing sponsor (added 2026-09-14)

Technically — sponsor observation (added 2026-08-11)

Skill design — key decisions

  1. Skill over cron for now. The /process-newsletter watch invocation is user-triggered, not scheduled, until we have confidence it doesn't burn context or generate noise.
  2. Always-flag, never-filter. Sponsors and bias get disclosed in frontmatter and body, never used to skip an article. The reader needs to see the angle.
  3. Deep-fetch cautiously. Max 2 link follows per curation issue, only for third-party links clearly relevant to RDCO topics. No paywall traversal.
  4. Vault-path discipline. All notes under 06-reference/<YYYY-MM-DD>-<sender-slug>-<topic-slug>.md. No exceptions. The filename convention is what lets the skill detect "already-filed" without duplicating work.
  5. Tracked authors feed Task #4. When a guest post or curation link surfaces a new author worth following (Dylan Anderson from the Mar 25 SDG issue, Olga Berezovsky from Jan 23), they go to the CRM candidate list, not directly into a contact file.

Lessons from the SDG prototype

What worked well:

What to improve for the next sender:

Next actions (pending founder approval)

  1. Backfill the next K sender — recommend Stratechery (201+ messages, highest expected signal density, single author for consistent assessment voice).
  2. Set up the watch cron loop once we've done 2-3 senders and trust the pattern.
  3. Revisit the 06-reference/ folder structure question at ~50 files.
  4. Handle Data Elixir once founder re-subscribes.

Related

AlphaSignal — "Sunday Deep Dive" single-thread format observed (added 2026-09-27)

AlphaSignal — 2026-09-28 new sponsor (added 2026-09-28)

AlphaSignal — 2026-09-29 new sponsor + masthead resolved as house self-promo (added 2026-09-29)

AlphaSignal — 2026-09-30 new sponsor pair (added 2026-09-30)

AlphaSignal — 2026-10-01 new sponsor (added 2026-10-01)

AlphaSignal — 2026-10-02 two new sponsors (added 2026-10-02)

Not Boring — Reducto resumed at WDoO #213 (added 2026-10-02)

Mostly Metrics — 2026-10-01 new sponsor (added 2026-10-01)