🤖 INTERNAL — Make.com 11 Szenarien (Detailliert)

🤖 Make.com Szenarien — KOMPLETT für Copy-Paste

VORAUSSETZUNGEN

1. Shopify Admin API Token erstellen

  1. Shopify Admin → Settings → Apps and sales channels → Develop apps
  2. 'Allow custom app development'
  3. 'Create app' → Name: 'Make.com Integration'
  4. 'Configure Admin API scopes':
    • read_orders, write_orders
    • read_products, write_products
    • read_customers, write_customers
    • read_inventory, write_inventory
    • read_discounts, write_discounts
  5. 'Install app' → API Token kopieren!

2. Slack Webhook

  1. slack.com → Workspace erstellen wenn nicht da
  2. api.slack.com/apps → Create New App → From Scratch
  3. Incoming Webhooks → Aktivieren
  4. Add New Webhook → Channel: #orders
  5. URL kopieren

3. Google Sheets vorbereiten

  1. sheets.new → 'LuxeStyle-Dashboard'
  2. Tab 1: 'Orders' (Spalten A-F: ID, Date, Customer, Total, Items, Status)
  3. Tab 2: 'KPIs' (für Daily Reports)
  4. Tab 3: 'Inventory-Alerts'

🎯 SZENARIO 1: ORDER → SLACK + SHEETS + KLAVIYO

Modules:

[1] Shopify - Watch Orders
    Connection: au3j0y-hq.myshopify.com
    Event: orders/create
    Trigger: Real-time (webhook)

[2] Google Sheets - Add a Row
    Spreadsheet: LuxeStyle-Dashboard
    Sheet: Orders
    Values:
      A: {{1.id}}
      B: {{formatDate(1.created_at; 'YYYY-MM-DD HH:mm')}}
      C: {{1.email}}
      D: CHF {{1.total_price}}
      E: {{length(1.line_items)}}
      F: {{1.financial_status}}

[3] Slack - Create a Message
    Channel: #orders
    Text: 🔥 *Neue Bestellung!*
          Kunde: {{1.email}}
          Betrag: CHF {{1.total_price}}
          Items: {{length(1.line_items)}}
          Shop: LuxeStyle CH
          {{1.order_status_url}}

[4] Klaviyo - Track Event
    Event: Placed Order
    Customer: {{1.email}}
    Properties: {total: {{1.total_price}}, items: {{length(1.line_items)}}}

🎯 SZENARIO 2: LIVE DASHBOARD WEBHOOK

[1] Schedule - Every 5 minutes

[2] Shopify - List Orders (filtered)
    Status: any
    Created: >= {{addDays(now; -1)}}

[3] Aggregator (Numeric)
    Source: total_price from step 2
    Operation: SUM → revenue_total

[4] Aggregator (Numeric)
    Source: total_price from step 2
    Operation: AVG → aov

[5] Webhooks - Custom Webhook Response
    Status: 200
    Headers: Content-Type: application/json
    Body:
    {
      'revenue': '{{revenue_total}}',
      'orders': '{{length(step2.orders)}}',
      'visitors': '0',
      'conv': '0',
      'aov': '{{aov}}',
      'recentOrders': [...]
    }

🎯 SZENARIO 3: CART ABANDONMENT (Backup zu Klaviyo)

[1] Shopify - Watch Checkouts (created)

[2] Sleep 1 hour

[3] Shopify - Search Orders
    Filter: email = {{1.email}} AND created_at > {{addHours(1.created_at; -1)}}

[4] Router IF length(step3.orders) == 0

[5] Klaviyo - Track Event
    Event: Started Checkout
    Customer: {{1.email}}
    
[6] Slack - Notify
    Channel: #cart-abandons
    Text: ⚠️ Cart abandoned: {{1.email}} - CHF {{1.total_price}}

🎯 SZENARIO 4: DAILY KPI REPORT (20:00)

[1] Schedule - Daily 20:00 Europe/Zurich

[2] Shopify - List Orders (today)

[3] Aggregator - Sum total_price

[4] Email - Send to allengchour@gmail.com
    Subject: 📊 LuxeStyle Tagesreport {{formatDate(now; 'DD.MM.YYYY')}}
    Body:
      🎯 HEUTIGER REPORT
      💰 Umsatz: CHF {{sum}}
      📦 Bestellungen: {{count}}
      📈 AOV: CHF {{avg}}
      Schönen Abend!

🎯 SZENARIO 5: VIP AUTO-TAGGING

[1] Shopify - Watch Orders

[2] Shopify - Get Customer total_spent

[3] Router IF total_spent > 200

[4] Shopify - Update Customer
    Tags: add 'vip'
    
[5] Klaviyo - Add to List 'VIPs'

[6] Klaviyo - Send Email 'VIP-Status-Erreicht'

🎯 SZENARIO 6: HEYGEN AUTO-VIDEO

[1] Shopify - Watch Products (tag:bundle, status:active)

[2] OpenAI - Generate Script
    Prompt: 'Erstelle 30-Sek HeyGen-Skript Hochdeutsch für: {{1.title}} - Preis CHF {{1.price}}'

[3] HeyGen API - Create Video
    URL: https://api.heygen.com/v2/video/generate
    Headers: X-Api-Key: {{HEYGEN_KEY}}
    Body:
      avatar_id: 'YOUR_AVATAR_ID'
      voice_id: 'german_neutral'
      script: {{step2.text}}
      dimensions: {width: 1080, height: 1920}

[4] Sleep 10 minutes

[5] HeyGen API - Get Video Status

[6] Google Drive - Upload File
    Folder: 'HeyGen-Videos'
    Filename: {{1.title}}.mp4

🎯 SZENARIO 7: INSTAGRAM AUTO-POST (neue Produkte)

[1] Shopify - Watch Products

[2] Instagram Business - Create Media
    Image: {{1.featured_image}}
    Caption: ✨ NEU: {{1.title}}
              💰 CHF {{1.price}}
              🔥 Code WELCOME10 = 10% Rabatt
              👉 Link in Bio
              #LuxeStyleCH #SchweizerShop

[3] Instagram Business - Publish Media

🎯 SZENARIO 8: INVENTORY LOW ALERT

[1] Schedule - Every 4 hours

[2] Shopify - List Products
    Filter: inventory_quantity < 5 AND status = 'active'

[3] Slack - Notify
    Channel: #inventory
    Text: ⚠️ Lager niedrig:
          {{title}}: nur noch {{quantity}}

[4] Shopify - Add tag 'low-stock'

🎯 SZENARIO 9: META ADS AUTO-PAUSE bei schlechtem ROAS

[1] Schedule - Daily 23:00

[2] Meta Marketing API - Get Ads (last 3 days)

[3] Router IF ROAS < 1.5

[4] Meta Marketing API - Update Ad
    Status: PAUSED

[5] Slack - Notify
    Text: 📉 Pausiert: {{ad.name}} (ROAS {{roas}})

🎯 SZENARIO 10: PINTEREST AUTO-PIN

[1] Shopify - Watch Products

[2] Pinterest API - Create Pin
    Board: 'Premium Lifestyle CH'
    Image: {{1.featured_image}}
    Title: {{1.title}}
    Description: {{1.description}}
    Link: https://aban-192.myshopify.com/products/{{1.handle}}

🎯 SZENARIO 11: REVIEW NOTIFICATION + ACTION

[1] Judge.me Webhook - Watch Reviews

[2] Router IF rating >= 5

[3] Klaviyo - Send 'Thank You' Email mit Code REVIEW10

[4] Instagram Business - Auto-Post Review als Story

[5] Router IF rating < 3

[6] Slack - URGENT Notification
    Channel: #urgent
    Text: 🚨 Schlechte Bewertung: {{review.body}} von {{review.customer}}

💡 PRO-TIPP: Reihenfolge der Einrichtung

  1. HEUTE (15 Min): Szenario 1 + 2 + 4 (Dashboard live)
  2. Diese Woche: Szenario 3 + 5 + 8
  3. Nächste Woche: Szenario 6 + 7 + 10
  4. Sobald skaliert: Szenario 9 + 11