Review workflow
Streams remain private until verified.
The admin structure is ready for Google Sheets export and an optional Apps Script validator.
Google Sheets schema
Admin-friendly stream columns.
idtitleslugchapelNameparishOrCommunityNamecityregioncountrytimezonelanguagestreamStatusproviderstreamUrlembedUrlisTwentyFourSevenverificationStatuslastCheckedAtlastVerifiedAtfeaturedprayerFocusscheduleJsonreverenceGuidelinesJsonreportNotesJsonstatusApps Script exporter
Validate before publishing.
- Read rows from the Adoration Streams sheet and validate required fields.
- Normalize YouTube and Vimeo URLs into safe embed URLs only.
- Reject rows with unsupported providers, javascript URLs, script tags, or unknown domains.
- Export published rows as a typed JSON file or TypeScript module for static builds.
- Write validation errors to an Admin Review sheet with row number and issue.
- Update lastCheckedAt only after an editor confirms the stream loads.