Google Calendar booking from a form

Books form requests into free calendar slots and emails AI-written replies. This n8n template takes appointment requests from an n8n Form with the customer's details, preferred date and time window. It creates a Google Calendar event when the slot is free, or emails other times when it is not. A model reached through OpenRouter writes the email subject and plain-text body, which Gmail sends; when a booking is more than 24 hours away, a reminder email goes out 24 hours before the start. Each request is logged as booked or offered in Google Sheets. It suits service businesses that take bookings through a form.

n8nRead on 2026-11-169 steps

Steps

  1. Trigger: n8n form receives an appointment requestn8n Form
    Details, preferred date and time window.
  2. Google Calendar Free/Busy fetches busy timesGoogle Calendar
    Next two weeks.
  3. Calculates the first slot or alternatives
    Up to three alternatives.
  4. OpenRouter drafts the email subject and bodyOpenRouter
  5. If a slot is free, creates the eventGoogle Calendar
  6. Output: Emails the confirmation via GmailGmail
  7. Output: Appends a booked or offered row to SheetsGoogle Sheets
  8. Output: Otherwise emails the alternative timesGmail
  9. Output: Reminder email 24 hours before the startGmail

Limits

  • The page names no OpenRouter model.
  • You set up the sheet with the listed headers yourself.
  • Needs four separate credentials before it runs.

What it does well

  • Emails alternative times when the requested slot is busy.
  • Sends a reminder 24 hours before the appointment.
  • The AI call retries up to 3 times.

Before you import

After import, add Google Calendar, Gmail and Google Sheets OAuth2 credentials and an OpenRouter key as HTTP Header Auth. The sheet headers are Timestamp, Name, Email, Service, Slot and Status.

Similar templates