The CCG booking spreadsheet tab is named 'Occupancy', not 'Sheet1'.
Updated defaults in docker-compose, route, booking-sheet lib, and env example.
Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>
- Add /api/accommodation-availability endpoint with 2-min cache + room filtering
- Fetch availability on mount, disable sold-out radio options
- Redirect booking notifications to jeff@jeffemmett.com for testing
Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>
Add "I would like to include food for the week" checkbox to the payment
step with co-producing meals messaging. Track food interest in Google
Sheets as column Q ("Want Food").
- Add wantFood field to RegistrationData interface
- Add interactive food checkbox replacing static note in payment step
- Pass wantFood through register API to Google Sheets
- Expand sheet ranges from A:P to A:Q, add "Want Food" header
- Preserve food column on payment status updates
Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>
- Add required email field to registration form (was missing entirely,
causing "N/A" emails in booking notifications)
- Pass email through full chain: form → API → Google Sheet → Mollie
metadata → webhook (with Mollie billingAddress as fallback)
- BCC contact@cryptocommonsgather.ing on all payment confirmation
emails so team is notified of every successful registration
- Replace OG image with alpine mountain card including event name,
dates, and URL for better Twitter/social sharing
Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>
- Add booking-sheet.ts: parses booking spreadsheet, finds first available
bed matching accommodation type, writes guest name across date columns
- Expand registration sheet to columns O-P (Accommodation Venue/Type)
- Webhook now assigns room booking (best-effort) on successful payment
- Send internal notification to contact@ with assignment details and flags
- Confirmation email shows assigned room; updated food/accommodation copy
- Add test script for end-to-end verification
- Add BOOKING_SHEET_ID/NAME to env and docker-compose configs
Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>
- Commons Hub nightly rates: shared €39.20→€39.90, double €50.20→€50.90
- Herrnhof prices now stored as 7-night totals (×7) for correct checkout
- Confirmation email: food text updated, Herrnhof link removed, added office@commons-hub.at for accommodation questions
Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>
- Remove food as a payment option; add note about follow-up email for food
- Restructure accommodation into two venues: Commons Hub and Herrnhof Villa
- Herrnhof Villa options: single, double (3 configs), and triple rooms
- Update event dates from Aug 16-22 to Aug 16-23 (7 nights) across all pages
- Update pricing: Commons Hub €274.40/€351.40, Herrnhof €40-€95 per person
- Update transparency page with new accommodation breakdown and food TBA
- Update API route and confirmation email to match
Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>
Replace Stripe checkout with Mollie payments API. Mollie handles
payment method selection on their hosted checkout (card, SEPA, iDEAL,
PayPal, etc). Simpler auth model — single API key, no webhook secrets.
- Rewrite /api/create-checkout-session for Mollie payment creation
- Rewrite /api/webhook for Mollie status verification flow
- Update google-sheets.ts: stripeSessionId → paymentSessionId
- Remove payment method radio buttons (Mollie shows all methods)
- Update docker-compose env vars
- Swap stripe npm package for @mollie/api-client
Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>
- Add nodemailer SMTP integration for payment confirmation emails
via newsletter@cryptocommonsgather.ing
- Add Listmonk PostgreSQL integration for newsletter subscriber sync
- Update webhook to send confirmation email after Stripe payment
- Add SMTP and Listmonk env vars to docker-compose
Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>
- Add googleapis for Google Sheets integration
- Create /api/register endpoint to record registrations with "Pending" status
- Update webhook to mark registrations as "Paid" when payment completes
- Add lib/google-sheets.ts with addRegistration and updatePaymentStatus functions
- Update docker-compose.yml with Google Sheets env vars
- Add .env.example documenting required environment variables
Flow: Form submit → Sheet (Pending) → Payment → Webhook → Sheet (Paid)
Co-Authored-By: Claude Opus 4.5 <noreply@anthropic.com>
Jeff Emmett
v0