Automate this with Make.com: Set WEBHOOK_URL at the top of the script to a Make.com webhook URL and every submission will auto-log to Google Sheets. See instructions at the bottom of this page.
How to connect Make.com → Google Sheets (30 min)
1.
Go to make.com → Create a new scenario → Add Webhooks → Custom webhook module
2.
Copy the webhook URL Make gives you (looks like https://hook.eu1.make.com/abc123)
3.
Open this HTML file → find var WEBHOOK_URL = '' near the top of the script → paste your URL between the quotes
4.
Back in Make, add a Google Sheets → Add a Row module after the webhook. Map: name, email, business, type, totalScore, tier, and each dimension score
5.
(Optional) Add Gmail → Send an Email after the Sheets module to auto-send a follow-up to every new lead with their score summary
6.
Test by submitting the form once → you should see a row appear in your Google Sheet within seconds
