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

📋 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 your@email.com 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)