Take bookings with a Google Form and put them straight on your calendar

Short answer: Use a free Google Apps Script that turns each Google Form booking into a Google Calendar event with the customer invited, and emails them to pick another time if that slot is already taken. It runs in your own Google account; nothing is sent to us. Setup takes 5 steps: Make the form; Link it to a sheet; Paste the script; Turn on bookings; What happens next.

How to set it up

1. Make the form. Create a Google Form with five questions titled exactly: Name, Email, Date, Time and Service. Use the Date and Time question types for those two.
2. Link it to a sheet. In the form's Responses tab, choose Link to Sheets. Open that sheet and add a tab called Settings: the appointment length in minutes in B1, and in B2 a calendar ID if you don't want your main calendar.
3. Paste the script. In the sheet, open Extensions, then Apps Script, paste in the code from our email, and save. Reload the sheet and a Bookings menu appears.
4. Turn on bookings. Choose Bookings, then Turn on bookings, and allow the permissions Google asks for (calendar and email).
5. What happens next. Each new booking becomes an event called the service and the customer's name, and the customer gets a calendar invite. If something is already on the calendar at that time, the customer gets an email asking for another time instead. A Status column in the responses tab shows Booked or Clash for each one.

Want this set up for your business? Free written scope in 20 minutes

Get the script

Good to know

• Any event on that calendar counts as busy, including personal ones, so use a separate calendar ID in B2 if you want bookings kept apart.
• Times are read in the time zone of the Apps Script project.

Questions

What does this script do?

It is a free Google Apps Script that turns each Google Form booking into a Google Calendar event with the customer invited, and emails them to pick another time if that slot is already taken.

How do I set it up?

In 5 steps: 1. Make the form; 2. Link it to a sheet; 3. Paste the script; 4. Turn on bookings; 5. What happens next. The full steps are on this page.

Is it free, and does it send my data anywhere?

It is free: enter your email on this page and we email you the script (Code.gs). It runs in your own Google account; nothing is sent to us.

Can you install it for me?

Yes. We set it up in your Google account in a short Connect session, connect it to your sheet and check that it runs.

Want this connected to the rest of your tools? Send us a short brief.