Offer and confirm technician visit slots with Google Calendar, Gmail, Sheets, and Telegram
Ready for 3.0What this workflow does
This workflow has 32 nodes and runs when an HTTP POST request hits its webhook URL (plus 2 other triggers). Along the way it connects Google Calendar, Gmail, Google Sheets and Telegram.
How it runs
Trigger: When an HTTP POST request hits its webhook URL (plus 2 other triggers).
- Confirm Booking Request Receipt (Respond to Webhook): sends the response back to the webhook caller
- Parse Slot Selection (Code): runs custom JavaScript code
- Fetch All Bookings From Sheet (Google Sheets): uses Google Sheets
- Build Booking Request (Code): runs custom JavaScript code
- Retrieve Booking Info (Google Sheets): uses Google Sheets
- Determine Daily Actions (Code): runs custom JavaScript code
- Fetch Calendar Busy Times (Google Calendar): get many
- Verify Slot Availability (If): checks a condition and branches into true / false
- Assess Reminder or Expiry (If): checks a condition and branches into true / false
- Find Available Slots (Code): runs custom JavaScript code
…plus 19 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (9)
- Webhook
n8n-nodes-base.webhook - Respond to Webhook
n8n-nodes-base.respondToWebhook - Code
n8n-nodes-base.code - Google Calendar
n8n-nodes-base.googleCalendar - If
n8n-nodes-base.if - Gmail
n8n-nodes-base.gmail - Google Sheets
n8n-nodes-base.googleSheets - Telegram
n8n-nodes-base.telegram - Schedule Trigger
n8n-nodes-base.scheduleTrigger
From the author
Quick overview This workflow takes a booking request via webhook, checks a technician’s Google Calendar for availability, emails three one-click time options via Gmail, and books the chosen slot into Google Calendar while logging and tracking the process in…