Discord Question of the Day#
A Deno cron job that fetches questions from a Google Sheets endpoint and posts them sequentially to Discord via webhook. Uses Deno KV for state management to track question progression.
Setup#
- Install Deno,
git clonethe project and rundeno installto install dependencies. - Create
.envfile for local development and fill in your values (see below) - Deploy to Deno Deploy or run locally
Commands#
# Local testing (with optional date/index override)
deno task dev
deno task dev --d="2025-10-25" --i="12"
# Run locally with cron
deno task run
# Deploy to Deno Deploy
deno task deploy
Necessary Environment Variables#
SHEET_ENDPOINT- JSON endpoint URL (Google Sheets, etc.)CRON_STRING- Cron schedule expressionDISCORD_WEBHOOK_URL- Discord webhook URLSUGGESTION_FORM_URL- Form to suggest new questionsDENO_KV_DATABASE_ID- Deno Deploy KV database ID (for local testing)DENO_KV_ACCESS_TOKEN- Deno Deploy KV access token (for local testing)
Idea by @meylemonade.bsky.social