Supabase isn't connected yet. Add your project URL and anon key near the top of this file's script before signing in — see README.md.
Sign in
Enter your email and we'll send a magic link — no password needed. Click the link in that email to come back here signed in.
RSVPs
Everyone who's signed up, newest first.
0 RSVPs
Loading RSVPs…
No RSVPs yet — once people start signing up, they'll show here.
Name
Email
Phone
Week before
Day before
Day of
Submitted
Hero
The top of the page — the first thing people see.
Impact section
Videos section
About Miyako
The Fillmore history section
Partners
GoFundMe section
Hero photo
The large photo at the top of the page.
About Miyako photo
The photo next to the shop's history.
Videos
Add as many as you want — from a link (YouTube, Vimeo) or by uploading a file. They show up on the site in the order listed here. Note: uploaded files are capped at 50MB on the free Supabase plan — for anything bigger, upload to YouTube first and paste the link instead.
Donations
GoFundMe doesn't share donor data automatically — check GoFundMe yourself, then mark matches here. The public tally on the site updates from these numbers.
Name
Email
Donated?
Amount ($)
Loading RSVPs…
Public tally (what shows on the site)
This is what actually powers the tally on the site. Editing the RSVP checkboxes above and saving will overwrite these two numbers — but you can also just set them directly here any time, with no need to tie them to specific RSVPs (handy for cash donations, donations from people who never RSVP'd, or just quickly bumping a running total you're tracking on GoFundMe itself).
The letter
Goes out from your Apps Script email as "100 Scoops Day." Use {firstName} anywhere you want it swapped for each person's name.
Who gets this
Unchecked people are skipped entirely.
Loading RSVPs…
Name
Email
Preview
Exactly what one recipient will see, using the first selected person's name.
Send status
Pulled from your Apps Script queue. Sends happen automatically, a batch per day, respecting Gmail's daily limit.
Not checked yet.
Scoop tracker
Powers the progress bar on the site. Update it during the event if you want it to reflect what's actually been given out.