Pongo

The prompt to build it yourself

Build me a loyalty, customer marketing and Google review tool, for my venue, to replace a subscription.

Stack: web app (Next.js or Node/Express) with SQLite, hosted on my small server, usable on phone and computer. No mandatory paid service, no telemetry.

Core of the tool:
- Customer book with consent, visit history and loyalty points.
- Targeted email or SMS campaigns (inactive customers, birthdays), with unsubscribe.
- Invitation to leave a Google review after the visit.

Requirements:
- GDPR: explicit consent at collection (unticked box, clear wording), unsubscribe link in every message, export and deletion of a customer on request, configurable retention period.
- Honest reviews: every customer receives the same invitation, with no prior sorting by satisfaction, and no reward is tied to a positive review. The review platforms' rules apply.
- Emails sent through a configurable SMTP server, with rate limiting; no scraping of the review platforms.
- Simple dashboard: invitations sent, clicks, evolution over time.

Out of scope: local SEO tracking and bulk SMS sending (needs a paid provider).

README: installation, SMTP configuration, GDPR reminder (purposes, legal basis, retention) and a reminder that links to the review platforms are entered by hand.