Library / Lead Generation & Enrichment
Lead Generation & Enrichment
Save website form leads to Google Sheets and send Gmail auto-replies
Receives website form submissions via webhook, validates required fields, appends valid leads to a Google Sheet, sends a Gmail thank-you and returns 400 errors for invalid input.
What it does
## How it works 1. Form Webhook receives a POST from your website form (JSON or form-encoded: name, email, phone, message, source). 2. Clean & Validate trims fields, lowercases the email and checks required fields. 3. Valid? routes the lead: - valid -> Respond OK (200) to the form, Save to Google Sheet appends the lead, Auto-reply (Gmail) sends an instant thank-you email. - invalid -> Respond Error (400) with the validation errors.
The steps
- Form Webhook
- Clean & Validate
- Valid?
- Respond OK
- Save to Google Sheet
- Auto-reply (Gmail)
- Respond Error
Similar automations
Lead Generation & EnrichmentSave form leads to Google Sheets, alert Slack and auto-reply via Gmail7 stepsLead Generation & EnrichmentFind websiteless local businesses via Apify and save leads to Google Sheets14 stepsLead Generation & EnrichmentFilter website contact form leads with OpenAI, Twilio, Gmail and Google Sheets39 stepsLead Generation & EnrichmentCapture Website Leads into HubSpot with Apollo Enrichment5 steps