All templates

Automated Square Repeat Customer Win-Back Drafts

Every Monday, WebRun opens Square's Customer Directory, finds customers who last purchased 60 or more days ago and had at least two prior visits, drafts a personalized win-back message for each, and logs them in Google Sheets so you can review and approve before sending.

Runs on WebRun · Strict Lockdown policy
Every Monday at 9:00 AM WebRunorchestrates each step
1 Square find lapsed repeat customers from the directory
2 Google Sheets log each lapsed customer with a draft win-back message
In short

How do I automatically identify and draft win-back messages for lapsed Square customers?

WebRun opens Square's Customer Directory every Monday, finds repeat customers who have not returned in 60 or more days, drafts a personalized win-back message for each one referencing their history, and logs everything in Google Sheets for your team to review. No message is sent until a human approves it.

  • Lapsed repeat customers are identified weekly without manual filtering
  • Personalized win-back messages are pre-drafted, cutting campaign prep time
  • No customer is contacted without explicit team approval

Built for retail shop owners · salon and spa owners · cafe owners · service businesses using Square

Step by step

What does WebRun do on every run?

The exact actions WebRun takes, in order - in plain language, so you can adjust anything.

  1. WebRun signs in and gets to work

    Opens squareup.com/dashboard/customers in a real browser with your saved login - no setup, no API keys.

  2. 1
    Square - find lapsed repeat customers from the directory
    squareup.com
    WebRun in Square: find lapsed repeat customers from the directory
    WebRun opens Square to find lapsed repeat customers from the directory.
    • Open Square Dashboard and navigate to Customers
    • Filter for customers with at least 2 visits whose last purchase was 60 or more days ago
    • Capture the customer name, email, last visit date, total visits, and top purchased item

    Done when All lapsed repeat customers are identified with their purchase history.

  3. 2
    Google Sheets - log each lapsed customer with a draft win-back message
    google.com
    WebRun in Google Sheets: log each lapsed customer with a draft win-back message
    WebRun opens Google Sheets to log each lapsed customer with a draft win-back message.
    • Append each lapsed customer as a new row with their name, contact, last visit, and visit count
    • Draft a short, personalized win-back message referencing their top purchase and how long it has been
    • Set status to 'Awaiting approval' so no message is sent until a team member reviews and approves

    Done when All lapsed customers are logged with draft messages awaiting team approval.

Run settings

How is each run configured?

Starting pageWhere Chrome opens at the start of each run
squareup.com/dashboard/customers
ScheduleRuns automatically on this cadence
Every Monday at 9:00 AM
DeliveryHow each run's result reaches you
Win-back queue · Google Sheets
OutputWhat each run produces - A Google Sheet with each lapsed Square customer, their visit history, and a draft win-back message ready for human review before sending.
Spreadsheet
Setup & safety

Secure by default

Connect once, stays signed in

WebRun signs in once and keeps each session in a persistent environment, so every run picks up right where it left off.

Your credentials stay in your own private environment - WebRun never stores your passwords.
Strict Lockdown

Every action is checked against this policy before it runs.

Domains ALLOWLIST
Typed input ALLOW
Shell command BLOCK
File uploads BLOCK
Runs in a contained environment More on policies
Good to know

Questions, answered

Will it send the win-back messages automatically?

No. WebRun drafts and queues the messages for your review in Google Sheets. A team member approves each one before it is sent, so you stay in control of every customer communication.

How does it personalize the messages?

It references the customer's name, their most-purchased item, and how many days it has been since their last visit, making each message feel relevant rather than generic.

Can it adjust the lapse window, such as 30 or 90 days instead of 60?

Yes. Set your preferred lapse window during setup. You can also set a minimum visit count so one-time purchasers are excluded from the campaign.

Put this on autopilot.

Turn it on in minutes - or have our team set it up for you.