Customer Alliance

The prompt to build it yourself

Build me a review centralisation and customer survey 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:
- Satisfaction survey after the stay or meal, with configurable questions and email sending.
- Table of reviews entered or imported as CSV (platform, rating, text, date), with reply tracking.
- Indicators: average rating per period, recurring themes spotted by keywords.

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: automatic retrieval of reviews from the platforms (without official access, it is fragile) and automatic replies.

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