Skip to content

Form Submission with Google Sheets#

Learn how to automatically process web form submissions and save them to Google Sheets with conditional logic and email notifications.

🎯 What You'll Build#

A donation form automation that: - Collects user information via web form - Saves data to Google Sheets - Sends personalized thank you emails based on donation amount - Notifies the team of new submissions

📋 Requirements#

  • Google account with access to Google Sheets
  • Gmail account for sending notifications
  • n8n instance running

🔧 Workflow Overview#

View workflow file

Key Components#

  1. Form Trigger - n8n form with multiple fields
  2. Google Sheets - Automatic data storage and VIP status calculation
  3. Conditional Logic - Branch based on donation amount
  4. Email Notifications - Personalized responses and team alerts

📝 Step-by-Step Guide#

1. Set Up the Form Trigger#

  1. Add a Form Trigger node
  2. Configure form fields: - First Name (required) - Last Name (required) - Email (required, email type) - Project (dropdown with donation options) - Amount (number, required) - Receipt (dropdown: Yes/No) - Note (textarea, optional)

2. Connect to Google Sheets#

  1. Add Google Sheets node
  2. Configure connection: - Operation: AppendOrUpdate - Select your spreadsheet and sheet - Map form fields to spreadsheet columns - Add VIP status calculation: {{ $if($json.Amount >= "5000", "TRUE", "FALSE") }}

3. Add Conditional Logic#

  1. Add Switch node
  2. Create conditions based on donation amount: - Route 1: Amount < 5000 (Normal donors) - Route 2: Amount >= 5000 (VIP donors)

4. Set Up Email Notifications#

  1. Add two Gmail nodes (one for each donor type)
  2. Configure personalized messages: - VIP donors get premium thank you message - Normal donors get standard thank you message
  3. Add merge Gmail node to send team notification

🎨 Customization Options#

  • Form Fields: Add custom fields for your specific use case
  • VIP Threshold: Adjust the amount that qualifies for VIP status
  • Email Templates: Create personalized email content
  • Spreadsheet Layout: Customize columns and calculations
  • Team Notifications: Add multiple recipients or different notification rules

🔍 Testing Your Workflow#

  1. Test the form by submitting different donation amounts
  2. Check Google Sheets for proper data storage
  3. Verify email delivery and content
  4. Test the VIP status calculation

📊 Real-World Applications#

  • Donation Processing: Fundraising campaigns and charitable donations
  • Event Registration: Conference registrations with VIP tiers
  • Product Orders: E-commerce with premium customer tiers
  • Contact Forms: Lead qualification and routing
  • Surveys: Response collection and analysis

⚠️ Common Issues & Solutions#

Issue: Data not saving to Google Sheets#

Solution: Check Google Sheets API permissions and spreadsheet sharing settings

Issue: Emails not sending#

Solution: Verify Gmail credentials and check if sender address is verified

Issue: VIP status not calculating correctly#

Solution: Check the conditional logic and data types in the calculation

🚀 Advanced Enhancements#

  • Data Validation: Add validation rules for form inputs
  • Duplicate Prevention: Check for existing entries before saving
  • Analytics Dashboard: Create summary reports and visualizations
  • SMS Notifications: Add SMS alerts for high-value donations
  • Payment Integration: Connect with payment gateways for automatic processing

Duration: 10 minutes Difficulty: Beginner Prerequisites: Google account, Gmail account