How to create a booking form with automatic confirmation email using Google Forms
How to create a booking form with automatic confirmation email using Google Forms + Google Sheets + Apps Script
In this video, you'll learn how to create a professional booking form using Google Forms, and how to automatically send a confirmation email to users after they submit the form—powered by Google Sheets and Apps Script.
Follow this step-by-step guide:
Step 1: Open [Google Forms](https://forms.google.com) and create a new blank form
Step 2: Add required fields: Name, Email, Service Type, Date, and Time
Step 3: Link your form to a Google Sheet to collect responses
Step 4: Open Apps Script from the Sheet and paste the confirmation email script
Step 5: Set a trigger to run the script every time the form is submitted
Step 6: Test your form and check the confirmation email in your inbox
This method is ideal for small businesses, service providers, consultants, or anyone who needs a simple and free appointment or booking system.
No coding experience needed. Just copy, paste, and follow along!
🔔 Don’t forget to like and subscribe for more no-voice, step-by-step tutorials using Google tools.
CODE:
function sendConfirmationEmail(e) {
var email = e.values[1]; // Adjust index if needed
var name = e.values[2]; // Adjust index if needed
var service = e.values[3];
var date = e.values[5];
var time = e.values[6];
var subject = "Booking Confirmation";
var message = "Hello " + name + ",\n\n" +
"Thank you for booking " + service + ".\n" +
"We received your request for " + date + " at " + time + ".\n\n" +
"We’ll contact you soon!\n\n" +
"Best regards,\nYour Business Team";
MailApp.sendEmail(email, subject, message);
}