Win back past customers from Google Sheets with OpenAI, Gmail and Slack

## Win back past customers from Google Sheets with OpenAI, Gmail and Slack ### Who is it for Owners and marketers at gyms, clinics, salons, studios and agencies whose past customers have gone quiet, and freelancers who run win-back campaigns for them. ### How it works 1. Each weekday it picks customers who agreed to hear from you, up to a daily limit, follow-ups first. 2. OpenAI writes a short email from each customer's row and your offer. Code checks every email and holds any with a wrong name, link, number or date. 3. Whenever the offer changes, you approve a few samples in Slack first. 4. Emails go from your Gmail with your address and a "Reply STOP" line, plus up to two follow-ups in the same thread. 5. Every hour it sorts replies. Unsubscribes and bounces are never emailed again. Interested people, and questions your FAQ answers, get a Gmail draft for you to send, and you get a Slack alert. 6. A Monday report sums up the campaign. ### How to set up - [ ] Connect Gmail, Google Sheets, Slack and OpenAI (key at platform.openai.com/api-keys). Add your Slack app to your channel. - [ ] Run Run Once to Set Up, then copy sheetId and handledLabelId from Show Your Setup Values into Campaign Settings. - [ ] Fill in the rest of Campaign Settings. The Slack channel ID is at the bottom of the channel's About tab. - [ ] Add customers to the Customers tab with consent set to yes. - [ ] Set the timezone in the workflow settings, then publish. ### Requirements Gmail, Google Sheets, Slack and an OpenAI API key. Only email people who agreed to hear from you, and follow the email marketing rules where you and they live. ### How to customize the workflow Change the daily limit, sample size and follow-up timing in Campaign Settings, and the send time in Every Weekday at 10.