Step 2: Connect Google Sheets

Pull the product URLs and prices from your spreadsheet, then prepare updates back to your master and history sheets.

1. Open Retrieve Product Sheet Rows and set Document to [YOUR_ID] and Sheet to product_data.
2. Credential Required: Connect your googleSheetsOAuth2Api credentials in Retrieve Product Sheet Rows.
3. Open Append Price History and confirm Operation is append, Document is [YOUR_ID], and Sheet is price_tracking.
4. Ensure column mappings use expressions like {{$json.last_price}}, {{$json.current_price}}, and the timestamp formatting expression already present in Append Price History.
5. Credential Required: Connect your googleSheetsOAuth2Api credentials in Append Price History and Update Master Price.
6. Open Update Master Price and confirm Operation is update, matching on product_url with mappings {{$json.current_price}} and {{$json.product_url}}.

Step 3: Set Up Product Iteration and Scraping

Loop through each product, delay between requests, and fetch the product page HTML for price extraction.

1. Connect Retrieve Product Sheet Rows to Batch Iterate Products to start the batch loop.
2. In Delay Between Calls, set Amount to 20 (seconds) to throttle requests.
3. Open Request Product Page and set URL to {{ $json.product_url }}.
4. Enable Send Headers and set Headers (JSON) to the provided browser-like user agent and accept headers.
5. Connect Delay Between Calls to Request Product Page to enforce the wait between calls.
6. Note the parallel execution: Request Product Page outputs to both Parse Current Price and Batch Iterate Products in parallel.

Step 4: Set Up Price Parsing and Calculation

Extract price from HTML, normalize values, and compute the delta for change detection.

1. In Parse Current Price, set Operation to extractHtmlContent and confirm the CSS selector .price__regular > span.price-item--regular maps to current_price.
2. Open Normalize Price Numbers and confirm it references the original row with $items("Delay Between Calls")[0].json and parses the numeric price.
3. Open Calculate Price Delta and confirm it computes price_changed and price_diff_pct based on last_price vs current_price.
4. Open Sanitize Parsed Fields and keep the cleaned output fields (product_url, last_price, current_price, price_changed, price_diff_pct, timestamp).
5. Connect Parse Current Price → Normalize Price Numbers → Calculate Price Delta → Sanitize Parsed Fields → Price Change Check.

Step 5: Configure Alerts and Sheet Updates

Send Telegram alerts on price changes and log changes to Google Sheets with a controlled update delay.

1. In Price Change Check, keep the condition {{ $json.price_changed }} equals true.
2. Note the parallel execution: Price Change Check outputs to both Compose Telegram Alert and Append Price History in parallel.
3. Open Compose Telegram Alert and confirm the message formatting includes the URL, prices, and percentage change.
4. Open Dispatch Telegram Alert and set Text to {{$json["message"]}} and Chat ID to [YOUR_ID].
5. Credential Required: Connect your telegramApi credentials in Dispatch Telegram Alert.
6. Open Wait Before Sheet Update and set Unit to minutes and Amount to 1.
7. Connect Append Price History → Wait Before Sheet Update → Update Master Price.
8. Ensure Dispatch Telegram Alert reconnects to Batch Iterate Products so the loop continues after alerting.

Step 6: Test and Activate Your Workflow

Run a manual test to confirm price parsing, alerts, and sheet updates before enabling the daily schedule.

1. Click Execute Workflow to run a manual test from Scheduled Morning Start.
2. Verify that Request Product Page returns HTML and Parse Current Price extracts current_price.
3. Confirm Append Price History writes a new row and Update Master Price updates the matching product_url.
4. Trigger a known price change and verify Dispatch Telegram Alert sends a message to your Telegram chat.
5. Once successful, toggle the workflow to Active so Scheduled Morning Start runs daily.