Kütüphane / Potansiyel Müşteri Yaratma ve Zenginleştirme
Potansiyel Müşteri Yaratma ve Zenginleştirme
Temizlik taleplerini Google Sheets'e kaydedin ve Gmail otomatik yanıtları gönderin
Web sitesi form taleplerini webhook ile alır, spam ve geçersiz e-postaları eler, posta koduna göre bölge sorumlusu atar, her potansiyel müşteriyi Google Sheets'e kaydeder ve bir Gmail otomatik yanıtı gönderir.
Ne yapar
## Log cleaning enquiries to Google Sheets and auto-reply with Gmail Who's it for Commercial cleaning companies, and any small service business, whose website form fills up faster than anyone can answer it. How it works Your website form posts to the webhook. read the form fields reads the payload whatever the plugin calls its fields - Contact Form 7, WPForms, Gravity Forms, Elementor and Fluent Forms all land cleanly - then honeypot hits and anything with no usable email are dropped. The postcode picks the area owner. The row is written to Google Sheets before any email is attempted, so an enquiry can never be lost to a mail failure. The customer gets a plain acknowledgement asking the three questions you always end up asking anyway; the owner gets the details and the reference. How to set up 1. Create a sheet with an Enquiries tab and the column headings listed in config. 2. Attach a Google Sheets credential and a Gmail credential to the three [cred] nodes. 3. Open config and set TRACKER_SHEET_ID, the AREAS postcode table and your company details. 4. Point your form plugin at this workflow's webhook URL. Requirements A Google Sheets credential, a Gmail credential, and a website form that can POST the submission as JSON. How to customize QUESTIONS and AREAS in config change what you ask and who quotes where. The email wording lives in write the first reply.
Adımlar
- Enquiry arrives
- config
- read the form fields
- a real enquiry?
- STOP: spam or incomplete
- assign an owner
- write the first reply
- row for the sheet
- [cred] Sheets - log the enquiry
- sending?
- STOP: preview - nothing sent
- [cred] Gmail - reply to the customer
- owner has an email?
- STOP: no owner email set
Toplam 16 adım.
Benzer otomasyonlar
Potansiyel Müşteri Yaratma ve ZenginleştirmeOpenAI, Gmail ve Google Sheets ile portal taleplerine yanıt taslakları hazırlayın9 adımPotansiyel Müşteri Yaratma ve ZenginleştirmeGemini, Gmail ve Google Sheets ile Erişim E-postalarını Zamanla12 adımPotansiyel Müşteri Yaratma ve ZenginleştirmeGelen potansiyel müşterileri puanla, ardından HubSpot kişileri oluştur ve Gmail takip e-postaları gönder8 adımPotansiyel Müşteri Yaratma ve ZenginleştirmeOpenRouter ile potansiyel müşterileri içe aktar, soğuk e-postalar gönder ve Gmail yanıtlarını sınıflandır20 adım