MARTI Program Calendar
A nonprofit's program calendar, driven live by a Google Sheet so organizers can edit it themselves.
A program calendar site I built and maintain for MARTI, the Maryland nonprofit where I mentor. The point of it is that the organizers are not developers: a Google Sheet is the single source of truth, fetched as CSV and revalidated on a short interval, so editing a spreadsheet row updates the live site within minutes and without a deploy. Most of the real work is in the parser. It reads bilingual Turkish and English month blocks, merges same-named events on consecutive days into multi-day spans including across month boundaries, infers a category and colour from keywords, and infers the year, which the sheet never records, by matching weekday columns against candidate years.
Highlights
- Google Sheet as the single source of truth, replacing hardcoded event data
- Incremental revalidation, so a sheet edit reaches production without a deploy
- Parser handles bilingual Turkish and English month blocks
- Merges repeated events into multi-day spans, including across month boundaries
- Infers the event year by matching weekday columns against candidate years
A look inside.
No screenshots yet
This project is still in progress. Shots go up once the interface settles.