Sales & CRM

Capture webhook data, log to Google Sheets, and send email notifications

6 nodes 114 74 Webhook
Download

Workflow Description

This automation receives data via webhook, processes it, and writes records directly to Google Sheets. Sends immediate email alerts to your sales team. Ideal for capturing new leads, opportunities, and real-time sales notifications without manual data entry.

How it works

  1. 1.Receive incoming webhook request with customer or sales data
  2. 2.Validate and parse the incoming data
  3. 3.Append new record to your Google Sheets spreadsheet
  4. 4.Send automated email notification to sales team members

Use cases

  • Automatically log new customer inquiries from web forms into a centralized sheet
  • Update sales opportunities and instantly notify team members
  • Create audit trails of customer interactions with email confirmations

Requirements

  • Google Workspace account with edit permissions on Google Sheets
  • Email account configured for sending notifications
  • Pre-existing Google Sheets document with correct column structure
  • Webhook source (form, app, or service) sending data to n8n

Service Value

Ideal as a smart automation service combining integrations and AI to produce ready-to-use results.

Apps Used

Google Sheets Email Send

Details

Trigger Webhook
Nodes 6
Apps 2
Views 114
Downloads 74

How to Use

  1. 1.Click "Download Template"
  2. 2.Open your n8n dashboard
  3. 3.Go to Workflows > Import from File
  4. 4.Select downloaded file and configure credentials

Nodes Used (6)

Webhook - Lead Capture

Webhook

#1

Google Sheets - Backup Log

Google Sheets

#2

FluentCRM - Add Contact

HTTP Request

#3

Send Warmup Email

Email Send

#4

Send WhatsApp via Whinta

HTTP Request

#5

Update CRM Tag to Customer

HTTP Request

#6