Automated Lead Response Template using Google Forms, Sheets, and Gmail

Description

📋 What this workflow does

This automated workflow streamlines the process of responding to leads who submit a Google Form. It instantly sends a personalized confirmation email to the lead and notifies your internal team with the submission details — ensuring no lead goes unnoticed.

It’s perfect for freelancers, agencies, small businesses, or any team collecting lead information through Google Forms and looking to reduce response time while staying organized.

⚙️ Workflow Overview

Trigger**: A new row is added to a connected Google Sheet via Google Forms
Email to lead**: Sends a custom confirmation message using Gmail
Email to team**: Notifies internal staff with all the lead’s submitted details

The entire process happens instantly and automatically, creating a better user experience and improving lead management.

🛠️ Setup Instructions

Connect your Google Form to a Sheet
In Google Forms, click the green Sheets icon under “Responses”
Create or connect Gmail & Google Sheets credentials in n8n
Update node field references if needed
Your Google Sheet must include these columns:
Timestamp
Full Name
Email
Phone Number (optional)
What are you interested in?
Additional message or query
Edit the Gmail nodes
Replace the placeholder email [email protected] with your actual sending address
Personalize the subject and body text if desired
Add your own notification recipient in the internal email node

🗒️ Notes

This workflow uses Spanish field labels — adapt field names if your form is in another language
Sticky notes inside the workflow explain where to update text and variables
All personal data has been removed from this public version

✅ Tools Used

Google Forms
Google Sheets
Gmail
n8n core nodes (no external APIs)