Quick overview
This workflow captures website contact form submissions, uses Google Gemini to classify the lead and draft a reply, logs every message to Google Sheets, and emails an internal alert for non-spam inquiries.
How it works
- Receives a new submission from an n8n Form trigger with the visitor’s name, email, phone, and message.
- Applies your business context, category list, preferred tone, notification email, and summary language to the incoming submission.
- Sends the message and rules to Google Gemini to classify it, set an urgency level, write a one-line summary, and draft a reply, then parses the result into structured fields.
- Formats the submission plus the AI results into a row and appends it to a Google Sheets spreadsheet.
- If the category is not Spam, sends an email alert to your notification address with the summary and suggested reply, using the visitor’s email as Reply-To.
Setup
- Add Google Gemini API credentials for the Gemini chat model node.
- Create a Google Sheet with headers
Date, Name, Email, Phone, Message, Category, Urgency, Summary, Reply draft, then connect Google Sheets (service account) and select the document and sheet.
- Configure SMTP credentials for the email-sending node and set a valid From address/domain.
- Update the Business settings values (business name/description, categories, reply tone, owner language, notification email and sender email) to match your business.
Requirements
- Google Gemini API key (the free tier works) or any other chat model
- Google account with Google Sheets (a service account is recommended)
- SMTP account to send the alerts (e.g. Resend, Gmail or Outlook)
Customization
- Replace the n8n Form with a Webhook to use your own website form
- Edit categories, reply tone and languages in Business settings
- Swap Gemini for OpenAI, Anthropic or any other chat model
Additional info
Replies are drafted in the customer's language and the summary in yours. Nothing is ever sent to the customer automatically: you review the draft and reply from your inbox.