Send customer visit notifications from Google Calendar to Slack and Sheets
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
Nodes used (12)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Google Calendar
n8n-nodes-base.googleCalendar - Edit Fields (Set)
n8n-nodes-base.set - Code
n8n-nodes-base.code - If
n8n-nodes-base.if - Filter
n8n-nodes-base.filter - Google Sheets
n8n-nodes-base.googleSheets - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Wait
n8n-nodes-base.wait - HTTP Request
n8n-nodes-base.httpRequest - Google Drive
n8n-nodes-base.googleDrive - Merge
n8n-nodes-base.merge
What it does
Customer Visit Notification This workflow monitors Google Calendar for events indicating that a customer will visit the company today or the next day, retrieves the required details, and sends reminder notifications to the relevant stakeholders. It also posts a company-wide announcement to ensure proper preparation and a professional reception for the customer. 📌Who is this for? - Reception / Administration team - Sales / Account owners in charge of customers - Management / Related team leaders - Security / IT / Logistics (for meeting room, equipment, and check-in preparation) 📌The problem - Customer visit information is usually shared manually and can be easily missed. - Related staff are not informed in time to prepare. - This causes last-minute preparation for reception, meeting rooms, documents, and support. - It affects the customer experience and the company’s professional image. 📌How it works - When a customer meeting is scheduled, the system records the information (time, customer name, company, person in charge). - The system automatically sends notifications to related groups based on timeline: - Notify the whole office 1 hour before the visit. - Notify related members 24 hours in advance. - Notifications can be sent via Email / Slack / Internal chat. 📌Quick setup Required information: - N8n Version 2.4.6 - Google Calendar OAuth2 API: Client ID, Client Secret - Google Sheets OAuth2 API: Client ID, Client Secret - Slack App: Bot User OAuth Token Google Sheets will be used to log all notified events. 📌Results - Everyone is aware of the customer visit schedule. - Teams can proactively prepare meeting rooms, documents, and manpower. - Reduce mistakes and missed communication. - Improve customer experience and company professionalism. 📌Take it further - Customer check-in using QR code / Visitor form - Send reminders to prepare documents - Store visit history - Monthly/quarterly reports for number of customer visits 📌Need help customizing? Contact me for consulting and support: Linkedin / Website