Kütüphane / Potansiyel Müşteri Yaratma ve Zenginleştirme
Potansiyel Müşteri Yaratma ve Zenginleştirme
Gecikmiş talepleri takip et ve Google Sheets'ten günlük Gmail özeti gönder
Hafta içi 08:30'da çalışır, Google Sheets'te belirlenen süreden uzun süredir hareketsiz kalan açık talepleri bulur ve her sahibine kendi taleplerini listeleyen tek bir Gmail hatırlatması gönderir.
Ne yapar
## Chase stalled enquiries and email a daily digest from Google Sheets Who's it for Commercial cleaning companies, and any small sales team, that tracks enquiries in a Google Sheet and keeps losing work simply because nobody followed up in time. How it works Every weekday at 08:30 the workflow reads the whole tracker once. Any enquiry still at an open stage that has had no movement for CHASE_AFTER_HOURS (48 by default) is collected and grouped by owner, then each owner gets one nudge listing all of theirs - never one email per enquiry. Chasing stops after CHASE_MAX reminders, and the chase count is written back to the sheet so nobody gets a daily drip about the same job. From the same read it builds a morning digest: every open enquiry counted by stage, everything that has gone quiet, and any row with no owner email. Moving a row to Won or Lost takes it out of both. How to set up 1. Attach a Google Sheets credential and a Gmail credential to the four [cred] nodes. 2. Open config and set TRACKER_SHEET_ID, the area-to-owner list and DIGEST_TO. 3. Leave TEST_RUN = true for the first run, read what the STOP nodes produced, then set it to false. Requirements A Google account for Sheets and Gmail, and a tracker sheet with an Enquiries tab whose headings match COLUMNS. How to customize CHASE_AFTER_HOURS, CHASE_MAX and OPEN_STAGES in config decide what counts as stalled. The email wording lives in write the nudge and build the morning digest.
Adımlar
- Run once manually
- Every weekday at 08:30
- config
- [cred] Sheets - read the tracker
- find what has gone quiet
- anything to chase?
- STOP: nothing stalled
- split by owner
- write the nudge
- sending the nudges?
- STOP: preview - nudges not sent
- [cred] Gmail - nudge the owner
- record the chase
- [cred] Sheets - record the chase
Toplam 19 adım.
Benzer otomasyonlar
Güvenlik ve UyumlulukŞüpheli Girişleri Algılama ve Slack ile Gmail'den Uyarı Verme33 adımGörüntü, Video ve SesGPT-4 ve Dumpling AI ile Reklam Görseli Varyasyonları Üretme13 adımKod, Git ve Geliştirici AraçlarıMySQL'de 10 günden eski n8n geçmişini temizleme4 adımYapı Taşları ve Yardımcı AraçlarAirtable kayıtlarını hız sınırlı gruplar halinde ekle veya upsert et29 adım