Google Calendar Google Docs Google Script Our products

Appointment Scheduler With Google Calendar

Today Google Calendar has become an indispensable part of our life. It is very clean and intuitive. We can create events, add guests and block our time-slots. But how about allowing others to book available time-slots themselves in our Google Calendar. Keeping this mind we have created this script. Now you don't have to deal with data entry and overlapping times. People can book their appointments automatically according to your available times. You can even set day-wise working hours so that booking will not be possible in off hours.


Some cool stuffs you can do with this

  • People can view the live calendar and hence can track available time slots. This helps them to book appointment easily.
  • They can only see free-busy information so your data is secure. They cannot see details of an event.
  • You can set your available working hours so that appointment can not be done in off hours
  • There is also an option to set max duration of an appointment.
  • When you go on leave, you can disable appointment temporarily and can show a message to user.
  • Last but not the least, the script handles everything like overlapping of time-slots. So you don't have to bother about time-slot management.

Some sample use cases

  • A doctor can use this app to allow her patients to book time-slots
  • A student can book an appointment to meet the Principal
  • An employee can book a meeting with his manager


Make a copy of this spreadsheet and follow the instructions provided. For any query drop a comment at