All templates

Automated Grocery Customer Review Request SMS

Every evening, WebRun reviews the day's completed loyalty transactions in ECRS CATAPULT, identifies customers eligible for a review request, drafts personalised SMS messages via Twilio, and logs them to a Google Sheet for your approval before any message is sent.

Runs on WebRun · Strict Lockdown policy
Every night at 8:00 PM WebRunorchestrates each step
1 ECRS CATAPULT identify eligible loyalty customers
2 Google Sheets log draft messages for approval
3 Twilio send approved SMS review requests
In short

How do I automatically send review requests to grocery customers after their visit?

WebRun reviews completed loyalty transactions in ECRS CATAPULT each evening, drafts personalised SMS review requests via Twilio for eligible customers, and logs them to Google Sheets for your approval. Only the messages you mark approved are ever sent, keeping your outreach compliant and customer-friendly.

  • Review requests go out to the right customers with zero manual effort
  • No customer is messaged without owner approval
  • 90-day suppression keeps outreach compliant and non-intrusive

Built for independent grocery store owners · supermarket marketing managers · community market operators

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 www.ecrs.com in a real browser with your saved login - no setup, no API keys.

  2. 1
    ECRS CATAPULT - identify eligible loyalty customers
    ecrs.com
    WebRun in ECRS CATAPULT: identify eligible loyalty customers
    WebRun opens ECRS CATAPULT to identify eligible loyalty customers.
    • Open CATAPULT loyalty and filter today's transactions for customers with a mobile number on file
    • Exclude customers contacted in the past 90 days to avoid over-messaging
    • Capture name, mobile number, and basket total for each eligible customer

    Done when Eligible loyalty customers for today's review request batch are identified.

  3. 2
    Google Sheets - log draft messages for approval
    google.com
    WebRun in Google Sheets: log draft messages for approval
    WebRun opens Google Sheets to log draft messages for approval.
    • Append one row per customer to the review-requests Sheet with their name, number, and draft SMS text
    • Mark each row as Pending Approval
    • Leave the Sheet open for you to mark rows as Approved or Skip before tomorrow morning

    Done when All draft messages are in the Sheet with Pending Approval status.

  4. 3
    Twilio - send approved SMS review requests
    twilio.com
    WebRun in Twilio: send approved SMS review requests
    WebRun opens Twilio to send approved SMS review requests.
    • On the next run, read the Sheet for rows marked Approved
    • Send each approved SMS via Twilio using your store's number
    • Update the row status to Sent and log the timestamp

    Done when Every approved message has been sent and logged.

Run settings

How is each run configured?

Starting pageWhere Chrome opens at the start of each run
www.ecrs.com
ScheduleRuns automatically on this cadence
Every night at 8:00 PM
DeliveryHow each run's result reaches you
Draft messages · Google Sheets
OutputWhat each run produces - A Google Sheet of drafted review request messages awaiting approval, then confirmed sent status after dispatch.
Text
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 text customers without my approval?

No. Every SMS is drafted and placed in a Google Sheet for you to approve first. WebRun only sends messages that you have explicitly marked Approved.

How does it avoid pestering the same customer repeatedly?

It checks the contact history and skips anyone messaged in the past 90 days, keeping your outreach compliant and your customers happy.

Can I customise what the review request message says?

Yes. You provide a message template during setup, including your Google review link. WebRun personalises it with the customer's first name each run.

Put this on autopilot.

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