Bibliothek / E-Mail-Automatisierung
E-Mail-Automatisierung
Win-Back-Angebote mit Gemini erstellen und über Gmail versenden
Läuft nach Zeitplan, wählt berechtigte abgewanderte Kunden aus, lässt Gemini für jeden ein personalisiertes Win-Back-Angebot entwerfen, protokolliert es in Google Sheets und versendet es per Gmail.
Was sie bewirkt
# 02. Generate & Send Win-Back Offer (Loop) Purpose: Processes each eligible customer found in the previous step individually within a loop. 1. Generate Offer (Gemini): Uses Google Gemini to create a personalized win-back offer (Informational, Bonus Points, or Discount) based on the customer's predicted_churn_score and preferred_categories. Outputs offer details in JSON format. 2. Log Sent Offer: Records the successful generation and intent to send the offer (action_taken, timestamp, customer_id) in the 'SYSTEM_LOG' Google Sheet. 3. Send Email (Gmail): Sends the generated offer details (offer_title and offer_details) via email to the customer's user_mail. The loop continues until all eligible customers are processed.
Die Schritte
- Scheduled Start: Daily Churn Check
- Fetch Customer Data from Sheet
- Filter High Churn Risk & No Campaign Customers
- Check if Eligible Customers Found
- Process Each Eligible Customer
- Generate Win-Back Offer
- (LLM Model for Offer Generation)
- (Parse Offer JSON)
- Log Sent Offer in System Log
- Send Win-Back Offer via Email
- Set 'Not Found' Status
- Log 'Not Found' in System Log
- Error Handler
Ähnliche Automatisierungen
E-Mail-AutomatisierungTäglich Rückgewinnungsangebote mit Gemini an gefährdete Kunden senden12 SchritteWeb Scraping & RechercheUber-Eats-Pizzaangebote mit Bright Data finden4 SchritteE-Mail-AutomatisierungWin back past customers from Google Sheets with OpenAI, Gmail and Slack83 SchritteE-Mail-AutomatisierungWin back lapsed clients with OpenAI, Google Sheets and Gmail37 Schritte