Approved Gmail Addresses
Only the Google accounts listed below can sign in to this admin dashboard. Add or remove emails to control access. Changes take effect immediately.
⚠️ After deploying to Netlify, update this list directly in the admin.html file and redeploy.
Deploy to Netlify — Step by Step
Google Sheets Auto-Scoring Formulas
Total Score (col P)
=SUM(D2:O2)Percentage (col Q)
=ROUND((P2/60)*100,1)Readiness Tier (col R)
=IF(Q2>=85,"🚀 Launch-Ready",IF(Q2>=70,"✅ Strong Foundation",IF(Q2>=55,"📈 Building Momentum",IF(Q2>=40,"⚠️ Needs Alignment","🔧 Foundation Required"))))Section A (col S)
=SUM(D2:F2)Section B (col T)
=SUM(G2:I2)Section C (col U)
=SUM(J2:L2)Section D (col V)
=SUM(M2:O2)