Every time someone completes the audit, their answers and scores will automatically appear in a Google Sheet you own. Here's exactly how to set it up — no code experience needed.
Step 1
Create your Google Sheet
Go to sheets.google.com and create a new blank spreadsheet. Name it something like Practiced Path Audit Submissions. Leave it open — you'll need the URL in a moment.
Step 2
Open Google Apps Script
In your new Sheet, click Extensions → Apps Script in the top menu. This opens a code editor in a new tab. Delete any existing code in the editor.
Step 3
Paste this script exactly
Copy the entire block below and paste it into the Apps Script editor:
function doPost(e) {
var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
var data = JSON.parse(e.postData.contents);
// Add header row if sheet is empty
if (sheet.getLastRow() === 0) {
sheet.appendRow([
"Timestamp", "First Name", "Last Name", "Email",
"Business Type", "Industry", "Revenue", "Team Size",
"Seasonal", "Tenure", "Biggest Challenge",
"Sales Score", "Delivery Score", "Operations Score",
"Finance Score", "Leadership Score", "Life Score",
"Overall Score", "3-Year Goal", "Final Notes"
]);
}
sheet.appendRow([
new Date().toLocaleString(),
data.fname, data.lname, data.email,
data.biztype, data.industry, data.revenue,
data.team, data.seasonal, data.tenure, data.biggest,
data.salesScore, data.deliveryScore, data.opsScore,
data.financeScore, data.leaderScore, data.lifeScore,
data.overallScore, data.goal3yr, data.finalNote
]);
return ContentService
.createTextOutput(JSON.stringify({status: "success"}))
.setMimeType(ContentService.MimeType.JSON);
}
This script receives the audit data and writes one row per submission with a timestamp, all answers, and all section scores.
Step 4
Deploy as a Web App
In Apps Script, click Deploy → New deployment. Then:
• Under "Select type" choose Web app
• Description: Audit form receiver
• Execute as: Me
• Who has access: Anyone
• Click Deploy and authorize when prompted
You'll receive a Web app URL that looks like:
https://script.google.com/macros/s/YOUR_ID_HERE/exec
Copy this URL — you'll need it in the next step.
Step 5
Add your Web App URL to the audit file
Open audit.html in a text editor. Find this line near the bottom of the <script> section:
const SHEETS_URL = 'YOUR_GOOGLE_APPS_SCRIPT_URL_HERE';
Replace YOUR_GOOGLE_APPS_SCRIPT_URL_HERE with the URL you copied in Step 4. Save the file and re-deploy to Netlify.
Once this is done, every audit submission will automatically appear as a new row in your Google Sheet within seconds of the person clicking "See My Results."
Step 6
Test it
Complete the audit yourself using a test name and email. Check your Google Sheet — you should see a new row appear with all the data. If it doesn't appear, make sure you authorized the script in Step 4 and that the URL in audit.html is correct.
Optional
Get email alerts for new submissions
In your Google Sheet, go to Extensions → Apps Script and add a second function below the first:
function sendEmailAlert(name, email, score) {
MailApp.sendEmail({
to: "kim@practicedpathadvisory.com",
subject: "New Audit Submission: " + name,
body: name + " (" + email + ") just completed the audit.\n\nOverall score: " + score + "/100\n\nLog in to Google Sheets to see the full results."
});
}
Then inside doPost, add this line just before the return statement:
sendEmailAlert(data.fname + " " + data.lname, data.email, data.overallScore);
Re-deploy (Deploy → Manage deployments → Edit → New version → Deploy) and you'll receive an email every time someone completes the audit.