Reply to contact form leads via Gmail and Google Sheets using OpenAI GPT-4o mini
Go to Workflow
TakatoYamada
Description
Quick overview
This workflow triggers on n8n form submissions, uses OpenAI (GPT-4o mini) to draft a short acknowledgment email, sends the auto-reply through Gmail, and appends the submission details to a Google Sheets spreadsheet.
How it works
Triggers when someone submits the n8n “Contact Us” form with their name, email, and message.
Sends the submission text to OpenAI (GPT-4o mini) to generate a warm auto-reply that promises a human follow-up within one business day.
Sends the generated reply to the submitter via Gmail with the subject “Thanks for reaching out!”.
Appends the form submission data to a Google Sheets worksheet for tracking.
Setup
Connect an OpenAI credential for the Chat model used to generate the email reply.
Connect a Gmail account credential and confirm the workflow is allowed to send email from that mailbox.
Connect a Google Sheets credential, replace the spreadsheet URL/ID in the Google Sheets step, and ensure the target sheet tab is named “Leads” (or update it to match your sheet).
This workflow was created by TakatoYamada and shared publicly on the n8n community template library. n8nFind indexes it for discovery — the workflow remains the property of its original creator.