Step 1: Google Cloud Setup (one-time)
- Go to Google Cloud Console → select your project (same one used for Reviews API)
- Enable the Google Sheets API
- Use your existing OAuth Client ID (or create one: APIs & Services → Credentials → OAuth 2.0 Client ID, Web application)
- Add your dashboard URL to Authorized JavaScript origins (e.g.
http://localhost:8000)
Step 2: Attendance Sheet
Create a Google Sheet with tabs "Friday" (Date | Event | Attendance) and "Saturday" (Date | Attendance). Share with your team as Editors. Paste the sheet URL above.
Step 3: Ticket Sales Sheet (separate sheet — share with ticket entry team only)
Create a Google Sheet with one tab per event. Each tab has metadata in row 1 and daily ticket data from row 4. Share only with the person entering ticket data.
Step 4: Campaign Data Sheet (separate sheet — ad spend stays private)
- Create a new Google Sheet with columns: Date | Platform | Campaign | Impressions | Clicks | Cost | Conversions
- For Google Ads: install the official Google Ads add-on (Extensions → Add-ons) and schedule automatic refresh
- For Meta Ads: add rows manually from Meta Ads Manager, or use the Google Apps Script for auto-pull
- Set the Platform column to "Google" or "Meta" for each row
- Paste the sheet URL above
3 separate sheets = separate access. The ticket entry person never sees ad spend. Only people you share each sheet with can see its data. The dashboard reads all 3 via Google Sheets API using your signed-in account.
Saturday campaigns should contain "SAT" in their name (e.g., "2026 SAT AEN May"). Friday campaigns are everything else. The dashboard auto-filters based on this.