# Automatically save n8n form leads to Google Sheets and Airtable with email confirmations
This automation template streamlines online form processing: when a user submits a form in n8n, the data is automatically split, formatted, and saved simultaneously to Google Sheets and Airtable. A personalized confirmation email is sent via Gmail right after submission. Ideal for lead collection, candidate applications, or feedback forms.
## Who it´s for
- Marketers collecting leads through online forms
- Sales managers integrating data into CRM and spreadsheets
- Administrators automating request tracking and notifications
- Freelancers using Airtable and Google Sheets for client management
## What the automation does
- Triggered by form submission in n8n (form_submit_trigger)
- Captures name, city, and email from the user
- Splits system timestamp into separate date and time fields
- Formats data for consistent storage
- Simultaneously saves data to Google Sheets and Airtable
- Sends a personalized confirmation email via Gmail
## What´s included
- Ready-to-use n8n workflow
- Trigger and handler logic using JavaScript
- Integrations with Google Sheets API, Airtable API, and Gmail API
- Basic text instructions for setup and adaptation
## Requirements for setup
- n8n account with workflow editing access
- Google account with enabled Google Sheets and Gmail access
- Airtable account with a database for record storage
- Configured API keys and permissions for all services
## Benefits and outcomes
- Eliminates manual data entry into spreadsheets and CRM
- Reliable data duplication across two systems for backup
- Instant user confirmation upon form submission
- Reduces team workload in handling requests
- Ensures consistent data format through automated formatting
- Scalable solution without increasing manual effort
## Important: template only
Important: you are purchasing a ready-made automation workflow template only. Rollout into your infrastructure, connecting specific accounts and services, 1:1 setup help, custom adjustments for non-standard stacks and any consulting support are provided as a separate paid service at an individual rate. To discuss custom work or 1:1 help, contact via chat
No feedback yet