Scripts, Emails & Setup Guide

Confirm Email Notifications in Netlify

After deploying your site, set up where form submissions get emailed:

• → Log in at app.netlify.com
• → Go to your site → Project configuration → Notifications
• → Under Emails and webhooks, open Form submission notifications
• → Enter your email: virtuoustouchcleaning@gmail.com
• → Save — you'll now get an email every time someone books!

Connect to Google Sheets via Zapier (Free)

To have every submission also appear as a row in Google Sheets automatically:

• → Go to zapier.com and create a free account
• → Create a new Zap: Trigger = "Netlify → New Form Submission"
• → Action = "Google Sheets → Create Spreadsheet Row"
• → Connect your accounts, map the fields, turn Zap on
• → Free plan: 100 tasks/month — more than enough to start

Create Your Google Sheet (for Zapier to log into)

Go to sheets.google.com → new spreadsheet → name it "Virtuous Touch — Lead Tracker". Add these column headers in Row 1:

Optional: Google Apps Script (Advanced — Email + Sheets in One)

If you prefer not to use Zapier and want a direct Google Sheets integration with email alerts built in, use this script. In Google Sheets → Extensions → Apps Script, paste this code. It logs to the sheet AND sends you an email:

// Virtuous Touch Cleaning — Sheet + Email Notification Script
var NOTIFY_EMAIL = 'virtuoustouchcleaning@gmail.com';

function doPost(e) {
  try {
    var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
    var data = JSON.parse(e.postData.contents);

    // 1. Log to Google Sheet
    sheet.appendRow([
      data.timestamp   || new Date().toLocaleString(),
      data.firstName, data.lastName,
      data.phone,     data.email,
      data.address,   data.service,
      data.homeSize,  data.preferred,
      data.notes,     data.claimOffer,
      data.source     || 'Website'
    ]);

    // 2. Send email notification
    var subject = '✦ New Lead: ' + data.firstName + ' ' + data.lastName;
    var body =
      'New booking request from your website!\n\n' +
      'Name: '    + data.firstName + ' ' + data.lastName + '\n' +
      'Phone: '   + data.phone    + '\n' +
      'Email: '   + data.email    + '\n' +
      'Service: ' + data.service  + '\n' +
      'Home Size: ' + data.homeSize + '\n' +
      'Preferred: ' + data.preferred + '\n' +
      'Notes: '   + data.notes    + '\n' +
      'Claimed Offer: ' + data.claimOffer + '\n\n' +
      'Submitted: ' + data.timestamp;

    MailApp.sendEmail(NOTIFY_EMAIL, subject, body);

    return ContentService
      .createTextOutput(JSON.stringify({'result': 'success'}))
      .setMimeType(ContentService.MimeType.JSON);

  } catch(err) {
    return ContentService
      .createTextOutput(JSON.stringify({'result': 'error', 'error': err.toString()}))
      .setMimeType(ContentService.MimeType.JSON);
  }
}

function doGet() {
  return ContentService.createTextOutput('Virtuous Touch Form Handler Active');
}

Deploy as Web App

In the Apps Script editor, click Deploy → New Deployment. Configure it as follows:

• → Type: Web App
• → Execute as: Me (your Google account)
• → Who has access: Anyone

Click Deploy, authorize the permissions when prompted, then copy the Web App URL — it starts with https://script.google.com/macros/s/...

Paste the URL into Your Website

Open your index.html file. Find this line near the bottom in the JavaScript section:

const GOOGLE_SCRIPT_URL = 'YOUR_GOOGLE_SCRIPT_URL';

Replace YOUR_GOOGLE_SCRIPT_URL with the URL you copied in Step 3. Save the file.