Error Handling and Edge Cases in the Restaurant Booking n8n Workflow

说明与用途

餐厅预订表单将数据发送到 n8n 工作流，写入 Google 表格并通过 Gmail 发送确认邮件。缺失必填字段、字段标签不匹配、快速重复提交、网络错误和 Gmail 限速可能导致空行、重复记录和邮件发送失败。

问题

Missing or malformed data from a web form can cause null entries in Google Sheets or failed email confirmations, leading to unreliable restaurant bookings.

结果

The workflow automates booking capture and confirmation but exposes failure modes such as null entries, duplicate rows, network errors, and email rate limits that need manual or additional error handling.

工作流

• Form Trigger – formTrigger: receives JSON payload from web form
• Set – Preprocess Form: maps form fields to Google Sheet columns
• Google Sheets – Insert Booking: writes booking row into spreadsheet
• Email – Send Confirmation: sends confirmation email via Gmail

证据

Form submissions missing required fields pass empty values downstream, potentially causing null entries in Google Sheets or blank email recipients, requiring form-side retries to guarantee complete data.

来源

The Set node maps form fields to sheet columns; mismatched labels or quick resubmissions can result in empty columns or duplicate rows unless external duplicate checks are implemented.

来源

Google Sheets writes booking data but fails silently on network errors or row limits without automatic retries, and Gmail confirmation sends fail on malformed addresses or API rate limits, logging errors and moving on without retrying.

来源