Triage and enrich contact form leads, log to Sheets, and notify via Gmail

Quick Overview

This workflow receives website contact form submissions via a webhook, logs the details to Google Sheets, generates a branded HTML notification, and sends the submission to a specified recipient using Gmail.

How it works

1. Receives a contact form submission through an HTTP POST webhook.
2. Sets the workflow’s notification recipient email used for alerts.
3. Appends the submission fields (Date, Time, Name, Email, Phone, Message) to a Google Sheets spreadsheet.
4. Builds a branded HTML email body from the submitted form data.
5. Sends the formatted notification email via Gmail, using the submitter’s email as the Reply-To address.

Setup

1. Copy the webhook URL from n8n and configure your contact form to POST submissions to it with the expected fields (Date, Time, Name, Email, Phone, Message).
2. Add Google Sheets credentials and replace YOUR_SPREADSHEET_ID (and sheet name if needed) so the workflow can append rows.
3. Add Gmail credentials and set the notificationEmail value to the address that should receive the alerts.
4. Update the email branding values in the HTML generator (logo URL, brand name/website, and colors) to match your company.