Automatic Magento 2 product & coupon alerts to Telegram with duplicate protection

Boost Sales with Automated Magento 2 Product and Coupon Notifications ---------------------------------------------------- This n8n workflow automatically posts new Magento products & coupons to Telegram while preventing duplicates. Key benefits: ✅ Increase conversions with time-sensitive alerts (creates urgency) ✅ Reduce missed opportunities with 24/7 monitoring ✅ Improve customer engagement through rich media posts ✅ Save hours per week by automating manual posting Why This Works: 1. Triggers impulse buys with real-time notifications 2. Eliminates human error in duplicate posting 3. Scales effortlessly as your catalog grows 4. Provides analytics through database tracking Perfect for e-commerce stores wanting to: Announce new arrivals instantly Promote limited-time offers effectively Maintain consistent social presence Track performance through MySQL This workflow automatically: ✅ Detects new products AND coupons in Magento ✅ Prevents duplicate postings with MySQL tracking ✅ Posts rich formatted alerts to Telegram ✅ Runs on a customizable schedule ✨ Key Features -------------- For Products: Product name, price, and image Direct store link Media gallery support For Coupons: Coupon code and status Usage limits (times used/available) Active/inactive status indicator Core System: 🔒 MySQL duplicate prevention⏰ 1-hour schedule (customizable)📱 Telegram notifications with Markdown 🛠️ Configuration Guide ----------------------- Database Setup Required Credentials 1. Magento API (HTTP Header Auth) 2. MySQL Database 3. Telegram Bot Sticky Notes ❗ IMPORTANT SETUP NOTES ❗ 1. For products: Ensure 'urlkey' exists in customattributes 2. For coupons: Magento REST API must expose coupon rules 3. MySQL user needs INSERT/SELECT privileges 4. Telegram bot must be added to your channel first 🔄 SCHEDULING: - Default: Checks every 1 hours at :00 - Adjust in Schedule Trigger node ⚙️ Technical Details -------------------- Workflow Logic: 1. Checks for new products/coupons via Magento API 2. Verifies against MySQL database 3. Only posts if record doesn't exist 4. Updates database after successful post Error Handling: Automatic skip if product/coupon exists Empty result handling Connection timeout protection 🌟 Why This Template? --------------------- Complete Solution: Handles both products AND coupons Battle-Tested: Prevents all duplicates reliably Ready-to-Use: Just add your credentials Fully Customizable: Easy to modify for different needs Perfect for e-commerce stores using Magento 2 who want automated, duplicate-free social notifications!