Triage after-hours website form requests with OpenAI, Google Sheets, Gmail and Telegram

Quick Overview

This workflow receives website form submissions via a webhook, validates and acknowledges the request, then routes notifications based on business hours and urgency, sending on-call alerts through Gmail and Telegram while keeping daytime requests email-only.

How it works

1. Receives a POST request from your website form via an n8n webhook.
2. Cleans and validates the submitted fields (name, email, phone, message, and optional urgency) and rejects invalid payloads.
3. Responds immediately to the visitor with HTTP 200 and a confirmation message, or HTTP 400 with validation errors.
4. Checks the current local time against your configured timezone and opening hours, treating emergency/urgent requests as always on-call.
5. Sends an on-call email via Gmail and then a Telegram alert when the request is after hours or marked emergency.
6. Sends a daytime notification email via Gmail when the request is within business hours.

Setup

1. Configure the webhook URL in your website form to POST to the workflow’s Production webhook endpoint.
2. Update the timezone and weekly opening hours in the business-hours checking step to match your business.
3. Add a Gmail OAuth2 credential and replace [email protected] with the inbox that should receive notifications.
4. Create a Telegram bot, add a Telegram credential in n8n, and replace REPLACE_WITH_YOUR_CHAT_ID with your target chat ID.