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.
Steps
- Trigger: n8n form receives an appointment requestn8n Form
Details, preferred date and time window. - Google Calendar Free/Busy fetches busy timesGoogle Calendar
Next two weeks. - Calculates the first slot or alternatives
Up to three alternatives. - OpenRouter drafts the email subject and bodyOpenRouter
- If a slot is free, creates the eventGoogle Calendar
- Output: Emails the confirmation via GmailGmail
- Output: Appends a booked or offered row to SheetsGoogle Sheets
- Output: Otherwise emails the alternative timesGmail
- 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
Weekly AI assistant traffic report
Also for scheduling and ops, 6 steps.
Daily Todoist and calendar briefing
Also for scheduling and ops, 7 steps.
Daily business news brief in Slack
Also for scheduling and ops, 5 steps.
Gmail and Google Sheets: 22 templates compared
Same two apps, different steps.
Gmail and n8n Form: 6 templates compared
Same two apps, different steps.
Gmail and OpenRouter: 6 templates compared
Same two apps, different steps.
Google Sheets and n8n Form: 6 templates compared
Same two apps, different steps.
Gmail and Google Calendar: 4 templates compared
Same two apps, different steps.
Google Sheets and OpenRouter: 3 templates compared
Same two apps, different steps.
Follow-ups and reminders
Other templates that do this task.