Senovy
Premium cosmetic brand site with automatic Google Sheets import, complete email infrastructure with DKIM 2048 and server-side Sent autosave.
Challenge
Senovy operates a product catalog that updates frequently through Google Sheets (the product department adds new references weekly). Manual synchronization with the site was a constant source of errors, missing references, old prices, inconsistent descriptions. Additionally, as a premium brand communicating directly with clients, they needed serious email infrastructure (multiple accounts on @senovy.ro and @talkbridge.co.uk, Sent autosave without client config, DKIM 2048 for deliverability, dedicated IPv4 for reputation). Functional webmail for users not installing desktop clients. And stable hosting, we don't compromise mail infrastructure to save a few euros.
Solution
For product import: dedicated endpoint /api/feed/run that fetches Google Sheets through cURL (resolves 307 redirect issues that Google throws at non-browser requests) with DNS forced to 8.8.8.8 (avoids local DNS issues) and mapping sheet fields into product schema. Real-time progress tracking through /api/feed/progress. Token-protected endpoint for security. For mail infrastructure: complete Postfix + Dovecot + OpenDKIM setup with 2048 keys on dedicated VPS, account separation through Virtualmin, server-side Sent autosave through BCC (Postfix sender_bcc → Dovecot pipe → doveadm save) so we don't depend on per-client configuration. Webmail through Roundcube 1.6.15 with password plugin integrated with Dovecot BLF-CRYPT and managesieve for filters. Let's Encrypt SSL with auto-renewal. SPF + DMARC quarantine for optimal deliverability. PTR records correctly configured for spam classification avoidance.
Process
- 01Product flow discovery with Senovy team: who updates, when, with what columns
- 02Feed endpoint setup with cURL + forced DNS + token security
- 03Google Sheets fields mapping → product schema with validation
- 04Dedicated mail VPS provisioning (separate from web hosting)
- 05Postfix + Dovecot + OpenDKIM setup with 2048 keys
- 06Server-side Sent BCC autosave through Dovecot pipe
- 07Roundcube webmail with integrated password plugin
- 08SPF + DKIM + DMARC + PTR configuration for deliverability
Results
Automat
Weekly Google Sheets import
DKIM 2048
Premium email deliverability
Server-side
Client-independent Sent autosave
Want similar results for your project?
Other case studies
Zelviro
Online store with 13,000+ products, eMAG and Trendyol integration, automatic stock and order sync, and performance tuning focused on conversion.
2024 - 2026
Modena
Online store with complete payment integration: BT iPay3 for card payments and TBI Bank for installments. Stable architecture for consistent order volume.
2023 - 2026
Helix Trading
Custom educational trading platform with proprietary simulator and complete challenge flow. Modern Next.js stack with PostgreSQL and role-segregated authentication.
2025 - 2026