Google Sheets Customer CRM for PrestaShop 8-9 | Segments, Tags, GDPR | OpenPresta

OpenPresta Google Sheets Customer Control Room — CRM, Segments, Tags & GDPR in One Sheet

Your full customer database inside Google Sheets — searchable, taggable, segmentable, and collaborative. Five sheets for customers, custom segments, tags, GDPR consent, and duplicate detection. Your sales, marketing, and support teams work from one shared view. Two-way sync: any tag, note, or segment added in the sheet flows back to PrestaShop.

• 5 sheets in one spreadsheet - Customers, Segments, Tags, GDPR, Duplicates
• Custom segments - build your own rules: VIP, churn risk, high potential, B2B
• Multi-tag system - many-to-many tagging editable from the sheet
• LTV calculator - lifetime value, average order, orders count, days since last order
• Duplicate detection - email, VAT, phone, and fuzzy-name matching
• GDPR compliance panel - consent per channel, right-to-be-forgotten flag, retention
• Customer journey timeline - registered, first order, group change, notes
• B2B fields - company, VAT, roles, credit terms visible and editable
• Bulk writes from the sheet - change company, VAT, phone, tags, newsletter, group
• Two-way sync with conflict detection - `_conflict` column flags edits that need review
• Privacy mode - anonymize names and emails for shared sheets
• Real-time hooks - new customers flow in the moment they register
• Multi-shop aware - all shops visible in one sheet
• Automatic cosmetics - money format, protected columns, conditional colors
• Compatible with PrestaShop 8 & 9 - Symfony + Twig architecture, PHP 7.4+
• No core file changes - works exclusively through hooks, upgrade-safe
• Lightweight - zero external dependencies, vanilla JS, minimal requests