Description
Overview
This price monitoring workflow automates Zalando product price tracking using a no-code integration pipeline. Designed for e-commerce managers and data analysts, it addresses the challenge of manually tracking dynamic prices by periodically scraping product pages and comparing current prices against predefined alert thresholds. The workflow uses a schedule trigger to initiate the process and leverages Google Sheets as both the input database and historical log repository.
Key Benefits
- Automates price tracking for Zalando products via scheduled data extraction and update cycles.
- Maintains historical price records in Google Sheets for trend analysis and audit purposes.
- Triggers alerts when product prices fall below user-defined thresholds for timely decision-making.
- Enables easy product addition through a web form, streamlining monitoring management.
Product Overview
This price monitoring automation workflow is initiated via a form trigger that collects Zalando product URLs and user-defined price alert values. Once a product is added, the workflow runs on a schedule trigger, fetching the list of monitored products from a Google Sheets database. Each product page is scraped through HTTP requests to extract real-time price and product name information from the page’s HTML content. The extraction uses string parsing techniques targeting meta tags and the title tag to retrieve accurate data.
Extracted data is formatted and then appended or updated in two Google Sheets: one maintaining the master product list with current prices and names, and the other logging historical price changes keyed by the update date. A conditional check compares the current price against the alert threshold. If the price is below or equal to the alert value, an email notification is sent via Gmail OAuth2 credentials, delivering structured alert information. The workflow handles data transiently without persistent external storage beyond Google Sheets, relying on OAuth2 authentication for secure API access.
Features and Outcomes
Core Automation
This automation workflow processes price data extracted via web scraping and applies deterministic threshold comparisons using an if-node filter. The orchestration pipeline ensures products are continuously monitored and price alerts dispatched when criteria are met.
- Single-pass evaluation of product price against alert threshold per run cycle.
- Automated update or append of price history entries keyed by update date.
- Deterministic routing for notification only if price meets alert condition.
Integrations and Intake
The integration pipeline connects Google Sheets for both product intake and data storage, using OAuth2 credentials for authentication. Input is accepted through a form trigger requiring a product URL and numeric price alert threshold.
- Google Sheets API for product list management and price history logging.
- HTTP request node for fetching Zalando product HTML pages.
- Gmail API (OAuth2) for sending price reduction notifications.
Outputs and Consumption
The workflow outputs updated Google Sheets rows with current product prices and logs historical price data for auditability. Notification emails are sent asynchronously upon detecting qualifying price drops.
- Google Sheets rows updated with price, name, and timestamp fields.
- Email alerts formatted with product name, current price, and alert threshold.
- Price history logged with append-or-update semantics keyed by date.
Workflow — End-to-End Execution
Step 1: Trigger
The workflow starts either by a form trigger where users submit a Zalando product URL and price alert value or by a scheduled trigger that initiates periodic monitoring. The form trigger requires two fields: a product link and a numeric alert price.
Step 2: Processing
After triggering, the workflow reads the product list from Google Sheets. Each product URL is processed through an HTTP request node that retrieves the raw HTML content. Basic parsing extracts the product name and current price from specific HTML meta and title tags, with no additional schema validation applied beyond string splitting and float parsing.
Step 3: Analysis
The extracted price is compared against the stored alert threshold using an if-node with a less-than-or-equal numeric operation. This conditional branching determines whether to send a notification or skip alerting for that run.
Step 4: Delivery
Upon price alert condition satisfaction, the workflow asynchronously sends an email notification containing product details and price information via Gmail’s OAuth2-authenticated node. Updated product information and price history are simultaneously logged back into Google Sheets for tracking.
Use Cases
Scenario 1
An e-commerce analyst needs to monitor Zalando product prices for competitor pricing strategies. This workflow automates data collection and alerts when prices drop below target thresholds, enabling timely pricing adjustments based on structured historic and current data.
Scenario 2
Retail buyers require automated notifications for product discounts on Zalando. By submitting product URLs and alert prices, they receive email alerts when deals meet their criteria, eliminating manual price checks and reducing response latency.
Scenario 3
Data teams need a scalable pipeline to log price trends over time for market research. This workflow records daily price points in Google Sheets, providing structured historical data for downstream analysis or reporting.
How to use
To deploy this price monitoring workflow, first configure Google Sheets OAuth2 credentials within your n8n instance. Create or copy the Google Spreadsheet with the required “Links” and “Pricing History” sheets as structured. Use the provided web form trigger to add products by submitting the Zalando URL and desired alert price. Set the schedule trigger interval according to your monitoring frequency needs, typically once daily or as preferred. Upon execution, the workflow scrapes current product prices, updates records, and sends notifications when alert conditions are met. Results include updated Google Sheets data and email alerts summarizing price changes.
Comparison — Manual Process vs. Automation Workflow
| Attribute | Manual/Alternative | This Workflow |
|---|---|---|
| Steps required | Manual price checks via browser, manual spreadsheet updates, manual alerting | Automated data scraping, processing, updating, and notification in one pipeline |
| Consistency | Subject to human error and inconsistent check intervals | Deterministic scheduled runs with strict threshold evaluation |
| Scalability | Low; manual efforts increase linearly with product count | High; scalable through scheduled iteration over Google Sheets product list |
| Maintenance | High; frequent manual data entry and monitoring required | Low; requires occasional credential updates and configuration tuning |
Technical Specifications
| Environment | n8n workflow automation platform |
|---|---|
| Tools / APIs | Google Sheets API (OAuth2), HTTP Request, Gmail API (OAuth2) |
| Execution Model | Event-driven via form trigger and scheduled polling |
| Input Formats | Web form fields (URL string, numeric price alert) |
| Output Formats | Google Sheets rows updated, email notifications (HTML formatted) |
| Data Handling | Transient HTTP data parsing, persistent Google Sheets storage |
| Known Constraints | Relies on Zalando HTML structure consistency for scraping accuracy |
| Credentials | Google Sheets OAuth2, Gmail OAuth2 for API access |
Implementation Requirements
- Configured OAuth2 credentials for Google Sheets and Gmail APIs within n8n.
- Accessible Google Spreadsheet with specified sheet names and column schema.
- Internet access for scheduled HTTP requests to Zalando product pages.
Configuration & Validation
- Verify OAuth2 credentials for Google Sheets and Gmail are correctly set and authorized.
- Ensure the Google Spreadsheet exists with “Links” and “Pricing History” sheets and required columns.
- Test form trigger submission with valid Zalando URLs and price alert values, confirming rows are appended or updated.
Data Provenance
- Trigger nodes: “Monitor Zalando Product” (form trigger), “Schedule Trigger” (timed execution).
- Data sources and sinks: Google Sheets nodes “Add Product,” “List Products,” “Add Log in History,” and “Update Products Infos”.
- Condition evaluation via “If price below price alert” node; notification via “Notify Price Reduction” Gmail node.
FAQ
How is the price monitoring automation workflow triggered?
The workflow is triggered either by a web form submission collecting product URL and alert price or by a scheduled timer node that runs periodic price checks.
Which tools or models does the orchestration pipeline use?
The pipeline uses Google Sheets APIs for data storage, HTTP requests for scraping, and Gmail API for notifications, all authenticated via OAuth2. No machine learning models are involved; price comparison is rule-based.
What does the response look like for client consumption?
Clients receive email notifications formatted with product name, current price, alert threshold, and a direct product link. Updated pricing and history are stored in Google Sheets for reference.
Is any data persisted by the workflow?
Yes. Product information, current prices, and historical price changes are persisted in Google Sheets. Transient HTTP response data is not stored beyond processing.
How are errors handled in this integration flow?
The workflow relies on n8n’s default error handling mechanisms. No explicit retry or backoff strategies are configured in the workflow steps.
Conclusion
This price monitoring workflow offers a reliable, rule-driven automation for tracking Zalando product prices and alerting on specified thresholds. It ensures consistent data capture and notification delivery through scheduled scraping and Google Sheets integration. The workflow’s accuracy depends on the stability of Zalando’s HTML structure and requires valid OAuth2 credentials for API access. By automating repetitive manual tasks, it facilitates scalable and maintainable price surveillance with deterministic outcomes, supporting data-driven decision-making over time.
Reviews
There are no reviews yet.