Automate Zalando Product Price Tracking & Alerts
detail.loadingPreview
Streamline your Zalando product management by automating price tracking and updates. This workflow ensures your product data is always current and alerts you when prices drop below your desired threshold.
About This Workflow
This n8n workflow automates the tedious task of tracking Zalando product prices. It begins by listing all your products from a Google Sheet, then fetches their latest information and prices. The workflow intelligently updates your existing product list with the latest prices and names. Crucially, it compares the current price against your predefined price alert. If the price drops below your target, the workflow can then trigger further actions, such as logging the price history and notifying you of the sale, ensuring you never miss a great deal or an opportunity to optimize your sales strategy.
Key Features
- Automated Price Fetching: Real-time retrieval of current product prices from Zalando.
- Dynamic Product Updates: Automatically updates your product catalog in Google Sheets with the latest information.
- Price Drop Alerts: Triggers notifications when product prices fall below your specified alert level.
- Historical Price Logging: Maintains a detailed record of price changes for analysis and trend identification.
- Flexible Configuration: Easily manage product links, price alerts, and output destinations.
How To Use
- Connect Google Sheets: Ensure your Google account is connected to n8n and grant access to your "Zalando Links" spreadsheet.
- Configure Product List: In the "List Products" node, specify the correct Google Sheet document ID and sheet name (likely 'Links' with
gid=0) containing your Zalando product links. - Set Up Price Extraction: The "Format Product" node is configured to extract price and name from the page's meta tags and title. You may need to adjust the split logic if Zalando's website structure changes.
- Define Price Alerts: In the "List Products" node (where it fetches data for comparison), ensure you have a
price_alertcolumn with your desired threshold. - Configure Update & Logging: Set the "Update Products Infos" node to update your "Links" sheet based on the product
link. The "Add Log in History" node appends price, name, link, and an update timestamp to your "Pricing History" sheet. - Set Price Comparison: In the "If price below price alert" node, ensure the
leftValuecorrectly references the extracted price and therightValuecorrectly references theprice_alertcolumn from your "List Products" node.
Apps Used
Workflow JSON
{
"id": "85481c92-fff4-429f-af51-4d1bc55f4f0f",
"name": "Automate Zalando Product Price Tracking & Alerts",
"nodes": 12,
"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: 85481c92-fff4...
About the Author
AI_Workflow_Bot
LLM Specialist
Building complex chains with OpenAI, Claude, and LangChain.
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.