Automate Zalando Price Tracking and Alerts
detail.loadingPreview
Streamline your Zalando product management by automating price tracking and receiving timely alerts when prices drop. This workflow integrates seamlessly with Google Sheets to keep your product information up-to-date and notify you of significant price changes.
About This Workflow
This n8n workflow is designed to automate critical aspects of managing Zalando products. It begins by fetching your product links from a Google Sheet, then scrapes their current pricing and product information. The workflow intelligently updates your main product list with the latest details and simultaneously logs the price history in a separate sheet for trend analysis. A crucial 'If' condition checks if the current price has fallen below your set alert threshold. If it has, you're positioned to receive proactive notifications, ensuring you never miss a profitable selling opportunity or a chance to snag a deal. This provides a robust solution for e-commerce professionals and bargain hunters alike.
Key Features
- Automated Price Scraping: Reliably fetches current prices and product names from Zalando.
- Real-time Google Sheets Sync: Updates your product list and logs price history automatically.
- Customizable Price Alerts: Triggers notifications when prices drop below your defined thresholds.
- Centralized Product Data: Maintains an organized record of your Zalando product information.
- Efficient Workflow Automation: Saves time and reduces manual effort in product management.
How To Use
- Connect Google Sheets: Ensure your n8n instance is authenticated with your Google account and has access to the "Zalando Links" spreadsheet.
- Configure "List Products" Node: Set the
documentIdto your Zalando Links spreadsheet and specify thesheetNamefor your main product list (e.g., "Links"). - Configure "Update Products Infos" Node: This node will update your main product list. Ensure the
documentIdandsheetNameare correct, and thematchingColumns(e.g., 'link') are set to accurately identify and update existing rows. - Configure "Add Log in History" Node: Set the
documentIdto your Zalando Links spreadsheet and specify thesheetNamefor your pricing history (e.g., "Pricing History"). Ensure thematchingColumns(e.g., 'update') are configured for your logging needs. - Configure "If price below price alert" Node: In the
leftValue, set the expression to={{ parseFloat($json.price) }}to get the current scraped price. In therightValue, set the expression to={{ parseFloat($('List Products').item.json.price_alert) }}to reference your desired alert price from the "List Products" node. - Add Notification Nodes (Optional): After the "If price below price alert" node, add nodes (e.g., Email, Slack) to send alerts when the condition is met.
Apps Used
Workflow JSON
{
"id": "7ffec717-f8a0-43c0-8574-0ee906c2874c",
"name": "Automate Zalando Price Tracking and Alerts",
"nodes": 17,
"category": "Operations",
"status": "active",
"version": "1.0.0"
}Note: This is a sample preview. The full workflow JSON contains node configurations, credentials placeholders, and execution logic.
Get This Workflow
ID: 7ffec717-f8a0...
About the Author
N8N_Community_Pick
Curator
Hand-picked high quality workflows from the global community.
Statistics
Related Workflows
Discover more workflows you might like
Universal CSV to JSON API Converter
Effortlessly transform CSV data into structured JSON with this versatile n8n workflow. Integrate it into any application as a custom API endpoint, supporting various input methods including file uploads and raw text.
Instant WooCommerce Order Notifications via Telegram
When a new order is placed on your WooCommerce store, instantly receive detailed notifications directly to your Telegram chat. Stay on top of your e-commerce operations with real-time alerts, including order specifics and a direct link to view the order.
On-Demand Microsoft SQL Query Execution
This workflow allows you to manually trigger and execute any SQL query against your Microsoft SQL Server database. Perfect for ad-hoc data lookups, administrative tasks, or quick tests, giving you direct control over your database operations.