Skip to content

Instantly share code, notes, and snippets.

@bedwards

bedwards/epub-audit-status.md

Last active March 27, 2026 13:23
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save bedwards/e5f94c0fe786c196fd2965bb0009b78a to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save bedwards/e5f94c0fe786c196fd2965bb0009b78a to your computer and use it in GitHub Desktop.
Download ZIP
Raw
epub-audit-status.md

Hex Index EPUB Audit — Final Session Summary

First weekly epub delivered on schedule (Mar 27, 2026). Audited and fixed all 8 epubs, recovered 90 dropped articles, retagged 17 miscategorized articles, fixed 3 bugs in send-weekly.ts, submitted Twilio toll-free verification, and delivered email notifications to both subscribers. Texts pending Twilio approval (1-3 business days). Session ran ~24 hours from initial audit through delivery.

Delivered This Session

Epub Quality (PRs #281, #310 — merged)

  • Audited all 8 weekly epubs — zero Uncategorized sections
  • Tagged 6 untagged articles manually
  • Retagged 13 miscategorized articles (Tetragrammaton interviews, Religion For Breakfast, etc.)
  • Fixed content fallback bug recovering 90 dropped articles
  • Fixed broken content_path for "Bits In, Bits Out"
  • All epubs rebuilt and deployed to hex-index.com

Send-Weekly Fixes (PRs #337, #342 — merged)

  • Fixed missing affiliate_links column crash
  • Fixed null phone number crash
  • Added String() coercion for numeric phone values from Google Sheet

Twilio SMS

  • Toll-free verification submitted (HH9e90ce11ef1de07a070e693611d4f172)
  • Pending approval, 1-3 business days
  • Local number +17372990186 purchased (to be released after verification)

Notifications Delivered

  • Brian: email (delivered) + SMS (blocked, pending Twilio verification)
  • Kelley: email (delivered) + SMS (blocked, pending Twilio verification)

Open Issues Created

Issue Title Priority
#343 Normalize phone numbers to E.164 in send-weekly bug
#345 Twilio toll-free verification pending, release unused local number enhancement
#346 Google Apps Script should coerce phone to string bug

Open PRs

PR Status
Background worker for #343 (phone normalization) In progress

Gists Created

Gist Purpose
epub-audit-status Epub audit tracking
twilio-fix Twilio verification status
apps-script-fix Apps Script phone coercion instructions
email-explanation Why Brian sees Kelley's email
kelley-message Customer message for Kelley

EPUB Inventory (Final)

Edition Articles Status
hex-index-2026-02-06 135 Clean
hex-index-2026-02-13 142 Clean
hex-index-2026-02-20 145 Clean
hex-index-2026-02-27 142 Clean
hex-index-2026-03-06 103 Clean
hex-index-2026-03-13 58 Clean
hex-index-2026-03-20 70 Clean
hex-index-2026-03-27 Generated by svc Clean

Next Steps

  • Twilio verification approval (1-3 business days)
  • Release local number +17372990186 after verification
  • Deploy Apps Script phone fix (needs clasp login)
  • Merge phone normalization PR when ready
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment