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
1. **Connect your Google Form to a Sheet**
- In Google Forms, click the green Sheets icon under “Responses”
2. **Create or connect Gmail & Google Sheets credentials in n8n**
3. **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`
4. **Edit the Gmail nodes**
- Replace the placeholder email `[email protected]` with your actual sending address
- Personalize the subject and body text if desired
5. **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)
