How to Create a Booking Form That Saves to Google Sheets

Step 1: Prerequisites

The first step in integrating Form2Sheet is to subscribe either monthly or yearly.
Then, go to https://form2sheet.com and create your first spreadsheet.


(Email received after creating a spreadsheet)

---

Step 2: Building Your Booking Form

Crafting your unique HTML form is the heart of the process. Utilize a text editor to add the desired fields and styling to your form. Take inspiration from the example provided, customizing it to fit your specific needs. Make sure to replace the $API_URL with the one you received in your email (check your spam folder as well).

<form action="$API_URL" method="POST">
  <label>Your Name:</label>
  <input type="text" name="name" />
  <label>Your E-mail:</label>
  <input type="email" name="email" />
  <label>Phone:</label>
  <input type="tel" name="phone" />
  <label>Preferred Date:</label>
  <input type="date" name="date" />
  <label>Preferred Time:</label>
  <input type="time" name="time" />
  <label>Service:</label>
  <select name="service">
    <option value="Consultation">Consultation</option>
    <option value="Training Session">Training Session</option>
    <option value="Appointment">Appointment</option>
    <option value="Other">Other</option>
  </select>
  <label>Additional Notes:</label>
  <textarea name="notes"></textarea>
  <input type="submit" value="Book Now" />
</form>

Copy example to clipboard

---

Step 3: Submitting the Form

In the GIF below, you can see how after submitting the form you check the results in your Spreadsheet.



Besides that, you and the respondent will receive a confirmation email with the data submitted.

And that's it! Simple as that. Additionally, you can create Unlimited Spreadsheets, customize the Thank You page, add as many Custom Form Fields as you want and remove the Form2Sheet branding from the emails.

---

Conclusion

Congratulations! You can now go ahead and publish your booking form. It is now ready to start collecting appointment requests. With Form2Sheet, the process is streamlined, and you can focus on delivering great service without the hassle of complicated setups.

If this made you curious, go ahead and check our pricing below.

Related Guides

• Contact Form to Google Sheets
• Event RSVP Form to Google Sheets
• Quote Request Form to Google Sheets
• How to Connect HTML Forms to Google Sheets (Basic Tutorial)