Settings
Configuration is managed via environment variables in .env.local. Sensitive values are never shown in this UI.
Google Sheets
Service Account Email
GOOGLE_CLIENT_EMAIL
Private Key
GOOGLE_PRIVATE_KEY (secret)
Drive Folder ID
GOOGLE_DRIVE_FOLDER_ID
Tracker Tab Name
GOOGLE_TRACKER_TAB_NAME
Test Google Connection
Verifies the service account credentials can obtain an access token from Google
Test Drive Folder Access
Lists all Google Sheets inside the configured Drive folder
Test Read All Project Sheets
Reads the Tracker tab from every sheet and counts tasks — full end-to-end check
Slack
Slack Enabled
SLACK_ENABLED
Webhook URL
SLACK_WEBHOOK_URL (secret)
Default Channel
SLACK_DEFAULT_CHANNEL
Email (Postmark)
Email Enabled
EMAIL_ENABLED
Postmark API Token
POSTMARK_API_TOKEN (secret)
From Email
POSTMARK_FROM_EMAIL
Message Stream
POSTMARK_MESSAGE_STREAM
Default Recipients
EMAIL_DEFAULT_RECIPIENTS
Reminder Schedule
"Run Check" previews what would be sent without dispatching anything. "Run and Send" dispatches real messages — duplicates are always skipped automatically.
Reminder Log Sheet
Log Sheet ID
REMINDER_LOGS_SHEET_ID
Each reminder attempt is logged here with timestamp, project, task, check type, recipient, channel, status, and any error message.
Security
API Secret
CRON_SECRET
The CRON_SECRET protects the /api/reminders/run and /api/reminders/check endpoints. Pass it as the Authorization: Bearer <secret> header.
Sheet Column Reference (A–T)
Each project Tracker tab must have these 20 columns in this exact order.
| Col | Header | Required | Example / Notes |
|---|---|---|---|
| A | Task ID | — | RNB-001 |
| B | Area / Module | — | Homepage |
| C | Go Live Date | 14/05/2026— Supports DD/MM/YYYY, ISO, or serial format | |
| D | Type of Activity | — | Design & Dev |
| E | Description | Homepage redesign— Primary identifier shown in the dashboard | |
| F | Asset Link | — | https://figma.com/…— Opens in a new tab |
| G | Progress / Status | Internal QA— Must match a known status value (see below) | |
| H | Project Manager | — | Alice Johnson— Person responsible for the task |
| I | Designer | — | Sarah Chen— Designer assigned to this task |
| J | Development Team | — | Frontend Team— Dev team or developer name |
| K | Comments | — | Waiting for client |
| L | Est. Completion Date | — | 12/05/2026 |
| M | QA Link | — | https://staging.site.com— Opens in a new tab |
| N | Internal Ready Date | — | 09/05/2026— Auto-calculated (5 days before Go Live) if blank |
| O | QA Date | — | 11/05/2026— Auto-calculated (3 days before Go Live) if blank |
| P | Priority | — | High— Low · Medium · High · Critical. Defaults to Medium |
| Q | Blocker | — | Waiting on vendor— Shown as a red label in the table |
| R | Reminder Email | — | alice@example.com— Task-level override for email reminders |
| S | Slack User / Channel | — | @alice or #go-live— Task-level override for Slack reminders |
| T | Last Updated | — | 13/05/2026— Auto-updated by dashboard edits |
Allowed Status Values (column G):