Internal events dashboard with calendar sync and RSVP tracking
Build an internal company events board for employees. Employees browse upcoming company events and RSVP; a small allowlist of organizers can create, edit, and delete events. Keep it clean and shareable. Trigger it as a webpage. Build a single-page React app served at a space- or tenant-authenticated route that renders instantly and talks to a separate HTTP data API over fetch. Identify each visitor from the spoof-proof authenticated-email header so RSVPs are tied to the signed-in employee automatically — no manual name entry. Gate organizer powers behind an allowlist of emails defined in the data API. Include these capabilities: Data API — a route-based backend that reads and writes a persistent SQLite database on a named volume (use an exclusive-writer lock so scheduled syncs never clobber live writes). It handles listing events, event detail, RSVP (Going / Maybe / Can't go), and event create/edit/delete. RSVP options per event — organizers can attach short-answer questions (some required), which guests answer inline when RSVPing; answers are private to organizers. Support per-event opt-in toggles for collecting RSVPs at all and for calendar sync. Support private guestlists that hide an event from non-listed employees. Calendar integration — connect Google Calendar (or your team's calendar tool). When an event has calendar sync on, create a matching calendar event; RSVPing Going/Maybe adds the person as an attendee (Maybe = tentative) so they get an invite email, and Can't go removes them. Let organizers import events from a shared company calendar as linked drafts without duplicating or overwriting the source. Two-way sync — push board edits to the linked calendar event silently, and add a cron step (e.g. every 30 minutes) that pulls the other direction, refreshing linked events and unpublishing ones cancelled in the calendar. Use incremental sync tokens for efficiency. Spreadsheet export — give each RSVP-collecting event a tab in Google Sheets (or your team's spreadsheet tool) tracking attendees. Note this workflow is read-write to its data volume and to the connected calendar, and sends invite/cancellation emails to attendees on RSVP changes. Tools used: React, SQLite, Google Calendar, Google Sheets
What this prompt builds
This workflow consolidates internal company event management into a single dashboard with differentiated views for organizers and attendees. It automates Google Calendar creation and two-way sync, collects RSVP data with custom questions, handles dietary and logistical needs, and exports attendance to spreadsheets. Built for growing organizations where multiple teams previously tracked events manually across disconnected tools, causing data conflicts and inbox overload.
The problem
Companies with growing teams struggle to track internal events as they scale — hosts lose visibility into who's attending what, attendees juggle outdated details across emails and calendars, and critical logistics like dietary needs, swag sizes, and time zones slip through the cracks. When Workplace Experience teams, EAs, and department leads manage RSVPs, calendar invites, and event details across disconnected G Suite apps and manual spreadsheets, data goes out of sync, inboxes flood with follow-up questions, and no one knows which source is the truth. This workflow centralizes all event data onto a single dashboard with role-based views for organizers and attendees, automatically syncing Google Calendar invites bidirectionally so every reference point stays current without spamming inboxes or losing RSVPs.
Solution and impact
Event organizers gain a single source of truth that collects RSVP data, attendee details, and logistics in one place, while attendees see only the events relevant to them — with times automatically adjusted to their time zone and calendar invites sent only when they RSVP "Going." Two-way sync between the dashboard and Google Calendar keeps event details current in real time, a scheduled cron job refreshes linked events every 30 minutes, and private event support lets teams run departmental or location-specific calendars without cluttering the company-wide view. The result: Workplace teams reclaim hours per week otherwise spent reconciling spreadsheets and chasing RSVP replies, employees always know what's happening and when, and event attendance data exports directly to Google Sheets for seamless reporting.