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
Triggers impulse buys with real-time notifications
Eliminates human error in duplicate posting
Scales effortlessly as your catalog grows
Provides analytics through database tracking
Announce new arrivals instantly
Promote limited-time offers effectively
Maintain consistent social presence
Track performance through MySQL
✅ Detects new products AND coupons in Magento
✅ Prevents duplicate postings with MySQL tracking
✅ Posts rich formatted alerts to Telegram
✅ Runs on a customizable schedule
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
CREATE TABLE IF NOT EXISTS posted_items (item_id INT PRIMARY KEY, item_type ENUM('product', 'coupon') NOT NULL, item_value VARCHAR(255), posted BOOLEAN DEFAULT FALSE, created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP);
Magento API (HTTP Header Auth)
MySQL Database
Telegram Bot
`❗ IMPORTANT SETUP NOTES ❗
For products: Ensure 'url_key' exists in custom_attributes
For coupons: Magento REST API must expose coupon rules
MySQL user needs INSERT/SELECT privileges
Telegram bot must be added to your channel first
🔄 SCHEDULING: - Default: Checks every 1 hours at :00 - Adjust in Schedule Trigger node `
Workflow Logic:
Checks for new products/coupons via Magento API
Verifies against MySQL database
Only posts if record doesn't exist
Updates database after successful post
Error Handling:
Automatic skip if product/coupon exists
Empty result handling
Connection timeout protection
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!