Bibliothek / Lead-Generierung & Anreicherung
Lead-Generierung & Anreicherung
Formular-Leads in Google Sheets speichern, Slack benachrichtigen und per Gmail automatisch antworten
Wird bei jedem Webhook eines Website-Formulars ausgeführt, prüft Name und E-Mail, hängt gültige Leads an Google Sheets an, postet sie in Slack und sendet eine automatische Antwort per Gmail.
Was sie bewirkt
## Save website form leads to Google Sheets, alert Slack and auto-reply with Gmail ### Who is this for Small businesses, consultants and agencies who want every website enquiry captured, shared with the team and answered within seconds. ### How it works 1. Form webhook receives a POST with name, email, message (and optional source). 2. Clean & validate trims fields and checks the email format. 3. Valid email? drops submissions with a bad email. 4. Save lead appends the lead to your Google Sheet. 5. Ping Slack posts the lead to your channel. 6. Auto-reply emails the lead a thank-you from your Gmail. 7. Respond OK returns a success response to the form. ### How to set up 1. Create a Google Sheet with columns: received_at, name, email, message, source. 2. Attach credentials to Save lead (Google Sheets), Ping Slack (Slack) and Auto-reply (Gmail). 3. Paste your sheet URL and set your Slack channel. 4. Edit the auto-reply text and sign-off. 5. Point your form (Webflow, WordPress, Tally, HTML) at the webhook Test URL, send a test, then activate and switch to the Production URL. ### What you need n8n (Cloud or self-hosted), Google Sheets, Gmail and a Slack workspace. No paid apps. ### How to customise Add lead scoring in Clean & validate, route by source with a Switch node, or replace Slack with Telegram or Microsoft Teams.
Die Schritte
- Form webhook
- Clean & validate
- Valid email?
- Save lead
- Ping Slack
- Auto-reply
- Respond OK
Ähnliche Automatisierungen
Lead-Generierung & AnreicherungClaude-Recherche-Briefings für Google Sheets-Leads schreiben und in Drive speichern23 SchritteDokumente, PDF & OCRIndividuelle Google-Slides-Präsentationen für jeden Lead erstellen23 SchritteCode, Git & EntwicklertoolsTrack LLM token spend per workflow with n8n API, data tables, and Slack alerts11 SchritteE-Mail-AutomatisierungTrack LLM spend per workflow and send budget alerts via the n8n API16 Schritte