Quick overview
This workflow provides an n8n-hosted form link that lets attendees confirm, reschedule, or cancel a specific Google Calendar meeting, then sends an email receipt via SMTP and logs the action to Google Sheets.
How it works
- Receives an attendee submission from an n8n Form with their email, a hidden Google Calendar event ID, an action (confirm/reschedule/cancel), and optional new date/time.
- Validates the submission and shows an error page if the email, meeting ID, or action is missing.
- Retrieves the matching event from Google Calendar via the Calendar API and shows a not-found page if the event no longer exists.
- Builds a meeting context (title, formatted time, attendee name, and meeting link) and routes based on the selected action.
- For confirmations, updates the Google Calendar event (sets a color tag) and emails the attendee a confirmation with the join link.
- For reschedules, parses the requested new date/time, patches the Google Calendar event to the new start/end (sending updates to guests), and emails the attendee the updated time.
- For cancellations, deletes the Google Calendar event (sending updates to guests), emails the attendee a cancellation notice, appends the outcome to Google Sheets, and shows a success page.
Setup
- Connect Google Calendar OAuth2 credentials for the Google Calendar API requests and set the correct calendar ID in the workflow configuration.
- Add SMTP credentials for the three outgoing emails and ensure the configured “from” address is allowed by your SMTP provider.
- Connect Google Sheets credentials, create a spreadsheet tab named “Meeting Actions” with the expected columns, and paste the spreadsheet ID into the workflow configuration.
- Update the CONFIG values in the workflow (timezone, business/sender names, from/support emails, and logSheetId) to match your environment.
- Activate the workflow and share the hosted form URL in your reminder email, prefilling Email and Meeting ID in the link if desired.