🔧 Tech Stack

• ManyChat flows – lead capture
• Google Sheets – central data storage
• n8n – automation engine
• Docker – containerized setup
• Hetzner Cloud – VPS hosting
• EmailOctopus API – email CRM ingestion
• Cron – scheduled automation

📈 Results

• 100% automated data flow
• Zero duplicates
• Tagged CRM
• Faster campaign activation (new leads appear in EmailOctopus within 1 hour)
• Reliable error-proof automation (hosted on VPS with health checks, cron schedules, and non-failing nodes)
• Scalable

Description:

Shahdag Resort collects leads and guest information through multiple digital touchpoints (ManyChat, forms, messenger sequences). However, the data was fragmented:

• Leads sitting inside ManyChat but not synced to email marketing
• Manual sheet exports for segmentation
• No tagging to identify lead source