Google Review Automation System — Workman Firearms / Range 42
Google Review Automation System — Workman Firearms / Range 42
# Google Review Automation System — Workman Firearms / Range 42
Version: 1.0 | Date: 2026-03-27 | Prepared by: Gunny
Locations: Brunswick, OH | Norton, OH
SECTION 1: REVIEW REQUEST FLOW
1.1 Trigger Events
There are three types of customer interactions that should trigger a review request:
| Trigger Event | Detection Method | Notes |
|---|---|---|
| CCW / Firearms Class Completion | Manual trigger by instructor at end of class | Instructor marks class complete in system |
| Range Visit (walk-in or reservation) | POS sale close or time-based (departure estimate) | Lane rental transaction = trigger |
| Gun Purchase / FFL Transfer | POS sale close | Customer completed a high-value transaction |
Option A — POS Integration (Recommended)
If the POS system (Square, Lightspeed, or similar) supports webhooks or API access:
- On transaction close, POS fires a webhook to a lightweight automation script
- Script receives: customer phone/email, location, transaction type, timestamp
- Script queues SMS/email for delivery at T+2 hours
- **Stack:** Make.com (free tier) or a simple Node.js script on a cheap VPS / Raspberry Pi
Option B — Manual Trigger (Immediate fallback)
- Staff/instructor fires a "send review request" action from a simple form (Google Form or internal dashboard)
- Form fields: customer phone or email, visit type (class/range/purchase), location
- Form submission triggers the automation queue
- **Stack:** Google Forms → Google Sheets → Apps Script sends SMS via Twilio or email via Gmail
Option C — Time-Based (Dumbest but functional)
- For range visits: if no POS integration exists, send at a fixed time daily (e.g., 6 PM) to all customers who checked in that day
- Requires a customer sign-in log (can be a paper log or simple iPad form at the counter)
- Least precise, still better than nothing
Recommended path: Start with Option B (manual trigger) — zero tech debt, live in 48 hours. Graduate to Option A when POS integration is feasible.
1.3 Channel Priority
SMS first. Email as fallback.
SMS open rates: ~98% within 3 minutes. Email open rates: ~20–25%. For a quick, action-oriented ask, SMS wins every time. If phone number isn't available or customer opts out of SMS, fall back to email.
SMS platform: Twilio (cheapest, most reliable, $0.0079/message).
Email platform: Gmail API (free) or existing email marketing setup.
VARIANT A — Direct / Marine energy (matches brand voice)
SMS:
```
Hey [FirstName] — thanks for coming into Range 42 [Brunswick/Norton] today.
If you had a good time, a Google review goes a long way for us.
Takes 60 seconds: [SHORT_URL]
```
Email Subject: `How was your visit to Range 42?`
```
[FirstName],
Appreciate you coming in today.
If you've got 60 seconds, a Google review would mean a lot to the team.
We're a local range — those reviews help people in [Brunswick/Norton] find us.
👉 Leave a Review: [LINK]
See you next time.
— Glen & the Range 42 crew
```
VARIANT C — Instructor / Class-specific (use after CCW classes)
SMS:
```
[FirstName] — congrats on completing today's CCW class!
If you felt well-prepared and had a good experience,
a Google review helps us reach more Ohioans looking for quality training: [SHORT_URL]
```
Email Subject: `Thanks for taking the CCW class — quick favor?`
```
[FirstName],
Great having you in class today. You're now one of the most responsibly-armed people in Ohio.
If you felt our instructor did right by you, we'd really appreciate a Google review.
It helps other Ohioans find quality training instead of settling for less.
👉 Review our [Brunswick/Norton] location: [LINK]
Stay safe out there.
— [Instructor Name] & the Workman Firearms Training team
```
SECTION 2: GOOGLE REVIEW DIRECT LINKS
2.1 Finding Your Place ID
Each Google Business Profile has a unique Place ID. Here's how to get it:
1. Go to: `https://developers.google.com/maps/documentation/javascript/examples/places-placeid-finder`
2. Search for `Workman Firearms Brunswick` and `Range 42 Norton`
3. Copy the Place ID (format: `ChIJ...` — a long alphanumeric string)
Alternative method:
1. Search your business name in Google Maps
2. Click "Share" → "Copy Link"
3. The link contains the Place ID or a CID that can be converted
2.2 Direct "Write a Review" URLs
Once you have both Place IDs, build these links:
Brunswick:
```
https://search.google.com/local/writereview?placeid=[BRUNSWICK_PLACE_ID]
```
Norton:
```
https://search.google.com/local/writereview?placeid=[NORTON_PLACE_ID]
```
These links open directly to the star rating + review text box — zero friction. Bookmark both. Put them in every template.
Shortened URLs: Use a free URL shortener (Bitly or your own domain) to create clean trackable links:
- `workmanfirearms.com/review/brunswick` → 301 redirect to the Google review URL
- `workmanfirearms.com/review/norton` → 301 redirect to the Google review URL
Benefits: trackable clicks in GA4, branded, short enough for SMS.
2.4 NFC Tags — Tap-to-Review at the Counter
NFC tags are cheap (~$0.30–$1.00 each), last forever, and are increasingly expected by tech-savvy customers. A tap from any modern smartphone opens the review page instantly.
How to set up:
1. Buy: NFC215 or NFC213 stickers (Amazon, ~$15 for 50 tags)
2. App: NFC Tools (iOS/Android, free)
3. Program: Write action "Open URL" → set to the Google review direct link for that location
4. Test on both iPhone (iOS 14+, holds phone near top of device) and Android
5. Mount tags under a "Tap to Review" sign at the checkout counter
Label design:
```
┌─────────────────────────────┐
│ 📲 TAP TO LEAVE A REVIEW │
│ │
│ [NFC STICKER EMBEDDED] │
│ │
│ Works with most phones │
└─────────────────────────────┘
```
Print on card stock, laminate, mount tag behind the card or visibly on top.
DESIGN SPEC — Front Face:
```
┌─────────────────────────────────────────┐
│ │
│ ⭐⭐⭐⭐⭐ │
│ │
│ Enjoyed your visit? │
│ │
│ Leave us a Google review! │
│ It takes 60 seconds and helps other │
│ Ohioans find a range they can trust. │
│ │
│ [QR CODE — 1.5" × 1.5"] │
│ │
│ Or visit: │
│ workmanfirearms.com/review/brunswick │
│ │
│ RANGE 42 · BRUNSWICK │
│ Locally owned. Marine-built. │
└─────────────────────────────────────────┘
```
DESIGN SPEC — Back Face (optional):
```
┌─────────────────────────────────────────┐
│ │
│ We read every review. │
│ Good, bad, or honest. │
│ │
│ — Glen Workman │
│ Owner, Workman Firearms │
│ │
└─────────────────────────────────────────┘
```
Print notes:
- Use brand colors (dark background / white text for contrast)
- Range 42 / Workman Firearms logo at top or bottom
- Laminate for durability (counter cards get dirty fast)
- Print run: 20–30 per location, replace monthly or when worn
- Print locally (Minuteman Press, Vistaprint, or Canva + local print shop)
3.3 Instructor Script — Post-Class
Train every instructor to deliver this after every class. Word it naturally — don't read it verbatim. Core elements: genuine close, direct ask, no pressure.
Script framework:
```
"Alright, before everyone heads out — I want to say it's been a
great class. You all put in real work today.
One quick thing: if you felt like this class gave you what you
needed — knowledge, confidence, range time — we'd really
appreciate a Google review for us. It sounds small but for a
local Ohio range, those reviews are what get us found.
There's a card on the table with a QR code. Takes about 60 seconds.
No obligation — just if you genuinely felt good about today.
Thanks for coming in. Stay safe out there."
```
Key principles:
- Say it at the END of class (not middle — students are packing up and attention is shifting)
- Conditional language: "if you felt like..." — not "please give us 5 stars"
- Don't single out individuals — group address
- Reference the QR code / card so they have a physical reminder
- Never say "5-star review" — that's review manipulation
4.1 Five-Star Response Templates
Variant A — Warm / personal:
```
[FirstName], thank you — this made our day! Glad you had a great
experience at the [Brunswick/Norton] range. We work hard to make
sure every visit feels worth your time. Come back and shoot with
us soon!
— The Range 42 Team
```
Variant B — Direct / confident:
```
Appreciate the review, [FirstName]. We take this stuff seriously
and it's great to hear it shows. Hope to see you back on the lanes.
Bring a friend next time!
```
Variant C — Class-specific:
```
[FirstName], thank you — and congrats again on completing your CCW
certification. Our instructors pour real effort into every class,
so this means a lot. Shoot us a message if you ever have questions
post-class. See you at the range!
```
4.3 Three-Star Response Template
```
[FirstName], thank you for being honest — that's exactly what
helps us get better. Three stars tells us something wasn't
quite right, and we want to fix it.
Would you mind reaching out directly to us at [email] or
calling [phone]? We'd like to hear what happened and make
it right. We don't shrug off feedback like this.
— Glen, Workman Firearms
```
4.5 Response Time SLA
| Review Type | Target Response Time | Who Responds |
|---|---|---|
| 5-star | Within 24 hours | Staff or owner |
| 4-star | Within 24 hours | Staff or owner |
| 3-star | Within 12 hours | Owner preferred |
| 1-2 star | Within 4 hours | Owner only |
Set GBP mobile app notifications on Glen's phone so 1-2 star reviews trigger immediate awareness.
5.2 Telegram Notifications
New review alert format in Telegram:
```
🔔 New Google Review — Brunswick
⭐⭐⭐⭐⭐ from John D.
"Best range in the area. Instructors are top notch and the lanes
are always clean. Been coming here for 2 years."
Reply within 24h in GBP dashboard.
```
For low-star reviews, add urgency:
```
🚨 NEW 1-STAR REVIEW — Norton
⭐ from Anonymous
"Staff was rude and the lanes were dirty."
⚠️ RESPOND WITHIN 4 HOURS — owner response required.
GBP: https://business.google.com/...
```
SECTION 6: COMPLIANCE
6.1 Review Gating — Prohibited
What is review gating:
Asking customers how they felt BEFORE sending the Google review link, then only sending happy customers to Google while routing unhappy ones to a private feedback form.
Why it's banned:
- Google TOS Section 3: "Don't discourage or prohibit negative reviews"
- FTC considers it deceptive business practice
- Violations result in GBP suspension (nuclear — kills local pack presence)
What we do instead:
Send the review request link to ALL customers equally. No pre-screening question. No "How was your visit? → Only if good → here's Google link." Every customer gets the direct link.
6.3 FTC Guidelines for Business Review Solicitation
Permitted:
- Asking customers to share their honest experience
- Providing a direct link to make it easy
- Asking in-person, via email, or SMS
- Displaying "Find us on Google" materials
Required if applicable:
- Any employee or staff member who leaves a review must disclose their connection (they can't post like a regular customer)
- Family members or friends who review must also disclose — or not review at all
Best practice language:
Use "honest review" framing in all copy. Example: "We'd love your honest feedback" or "Share what you thought" — not "Leave us a 5-star review."
IMPLEMENTATION TIMELINE
Week 1 — Foundation (Zero-budget)
- [ ] Find Place IDs for both GBP listings
- [ ] Generate direct review URLs for Brunswick + Norton
- [ ] Create shortened branded URLs (`workmanfirearms.com/review/brunswick`)
- [ ] Generate and print QR codes (free tool)
- [ ] Install GBP app on Glen's phone, enable notifications
- [ ] Print counter cards (Canva + local printer or home laser printer)
- [ ] Train staff on asking script + counter card placement
- [ ] Add receipt footer text in POS settings
Week 2 — Automation (Low-budget)
- [ ] Set up Twilio account (pay-as-you-go, ~$5 to start)
- [ ] Build Google Form + Sheets manual trigger for review requests
- [ ] Write Apps Script to send SMS via Twilio on form submit
- [ ] Set T+2 hour delay logic (Apps Script can do this natively)
- [ ] Test with a real transaction — confirm SMS delivery + link works
- [ ] Set up Google Sheets review tracking log
Week 3 — Monitoring
- [ ] Set up GBP API access (Google Cloud Console)
- [ ] Deploy gbp-review-monitor.py script
- [ ] Add cron job for 15-minute polling
- [ ] Test Telegram alert with a real review
- [ ] Build weekly summary script
Week 4 — Optimize
- [ ] Buy and program NFC tags (Amazon, ~$15)
- [ ] Mount NFC tags at counters with "Tap to Review" signage
- [ ] Review A/B test results (which SMS variant drives more reviews)
- [ ] Declare winner variant, update templates
Ongoing
- [ ] Monitor weekly review count vs. 50/year target per location
- [ ] Respond to every review within SLA
- [ ] Update QR codes if review URL changes
- [ ] Replace worn/damaged counter cards monthly
QUICK-REFERENCE: TOOL STACK
| Tool | Purpose | Cost |
|---|---|---|
| Google Business Profile (free) | Source of truth for reviews | Free |
| GBP API | Automated review polling | Free |
| Twilio | SMS delivery | ~$0.008/SMS |
| Google Forms + Sheets | Manual trigger system | Free |
| Apps Script | Automation glue | Free |
| Python + cron | GBP monitoring script | Free |
| Telegram | Review alerts | Free |
| Canva | Counter card design | Free |
| NFC Tools app | Program NFC tags | Free |
| NFC215 stickers | Tap-to-review tags | ~$15/50 |
| Bitly or branded redirect | Short review URLs | Free |
Total recurring cost: ~$5–15/month (Twilio SMS only, scales with volume)