Skip to content
NEWMarketplace and the trig8n Agent: sell what you build, and get plans and changes that are tested before you see them. See what is new

Library / Email Automation

Email Automation

Send Daily Win-Back Offers to At-Risk Customers with Gemini

Every day, high churn-risk customers from Google Sheets get a Gemini-written win-back offer by Gmail and the sheet is updated.

Import it free Sign in to open it

What it does

# 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.

The steps

  1. Scheduled Start: Daily Churn Check
  2. Fetch Customer Data from Sheet
  3. Filter High Churn Risk & No Campaign Customers
  4. Check if Eligible Customers Found
  5. Process Each Eligible Customer
  6. Generate Win-Back Offer
  7. (LLM Model for Offer Generation)
  8. (Parse Offer JSON)
  9. Log Sent Offer in System Log
  10. Send Win-Back Offer via Email
  11. Set 'Not Found' Status
  12. Log 'Not Found' in System Log

Similar automations

Email AutomationGenerate Win-Back Offers with Gemini and Send Them via Gmail13 stepsData Sync & ETLSend weekly Shopify RFM win-back offers with GPT-4o-mini, Klaviyo and WhatsApp22 stepsEmail AutomationWin back past customers from Google Sheets with OpenAI, Gmail and Slack83 stepsEmail AutomationWin back lapsed clients with OpenAI, Google Sheets and Gmail37 steps