Step 2: Connect Google Sheets

Load the product list and prepare spreadsheet connections for updates and history logging.

1. Open Configuration Setup and set the spreadsheet URL value to https://docs.google.com/spreadsheets/d/[YOUR_ID].
2. In Retrieve Monitored Items, set Document to {{ $json.spreadsheet_url }} and Sheet to Products to Monitor.
3. Credential Required: Connect your googleSheetsOAuth2Api credentials in Retrieve Monitored Items.
4. In Update Monitored Records, confirm Operation is update and Document is {{ $('Configuration Setup').item.json.spreadsheet_url }}.
5. Credential Required: Connect your googleSheetsOAuth2Api credentials in Update Monitored Records and Append Price History.
6. In Append Price History, confirm Operation is append and Sheet is Price History.

Step 3: Set Up the Processing and API Fetch Chain

Fetch Amazon data, normalize pricing, and compute change metrics.

1. Open Iterate Item Batch and ensure it is connected from Retrieve Monitored Items for item-by-item processing.
2. In Capture Prior Price, set last_pricing to {{ $json.pricing }}.
3. In Fetch Amazon Product Data, set URL to https://proxy.scrapeops.io/v1/structured-data/amazon/product, enable Send Query, and use query parameters: asin = {{ $('Iterate Item Batch').item.json.asin }} and api_key = {{ $('Configuration Setup').item.json.scrapeops_apikey }}.
4. In Map Product Fields, map name to {{ $json.data.name }}, pricing to {{ parseFloat(($json.data.pricing || "").replace(/[^\d.-]/g, "")) || 0 }}, and product_url to https://www.amazon.com/dp/{{ $('Iterate Item Batch').item.json.asin }}?th=1&psc=1.
5. In Validate Price Value, set the condition to pricing > 0 using {{ $json.pricing }}.
6. In Compute Price Delta, confirm price_change and percent_change formulas use {{ $('Capture Prior Price').item.json.last_pricing }} and {{ $json.pricing }} as provided.

Step 4: Configure Alert Logic and Spreadsheet Updates

Determine alert thresholds, update the product records, and append history for each item.

1. In Determine Alert Status, keep the alert calculation expression: {{ $json.percent_change > $('Iterate Item Batch').item.json.alert_threshold_high ? "High" : ($json.percent_change < $('Iterate Item Batch').item.json.alert_threshold_low ? "Low" : "") }}.
2. In Update Monitored Records, ensure columns are mapped using expressions like {{ $('Fetch Amazon Product Data').item.json.data.pricing.replace(/[^\d.]/g, '') }}, {{ $('Compute Price Delta').item.json.price_change }}, and {{ $now.format("MM/dd/yyyy HH:mm:ss") }}.
3. In Append Price History, confirm asin, pricing, and timestamp are mapped to {{ $('Iterate Item Batch').item.json.asin }}, {{ $('Fetch Amazon Product Data').item.json.data.pricing.replace(/[^\d.]/g, '') }}, and {{ $now.format("MM/dd/yyyy HH:mm:ss") }}.
4. Verify the execution flow: Determine Alert Status → Update Monitored Records → Append Price History → Evaluate Alert Condition.

Step 5: Configure the Email Alert Output

Send alerts only when the alert status is set to High or Low.

1. In Evaluate Alert Condition, keep the condition: {{ $('Determine Alert Status').item.json.alert_status }} is not empty.
2. Connect the true branch from Evaluate Alert Condition to Dispatch Email Alert, and the false branch back to Iterate Item Batch.
3. In Dispatch Email Alert, set To Email to {{ $('Configuration Setup').item.json.to_email }} and From Email to {{ $('Configuration Setup').item.json.from_email }}.
4. Keep the Subject as Price Monitoring Alert: {{ $('Update Monitored Records').item.json.name }} Change Detected and the HTML body as provided for the dynamic price summary.
5. Credential Required: Connect your smtp credentials in Dispatch Email Alert.

Step 6: Test and Activate Your Workflow

Validate each step with a manual run, then enable scheduling for production.

1. Click Execute Workflow to run a manual test starting from Scheduled Run Trigger.
2. Confirm items flow through Retrieve Monitored Items → Iterate Item Batch → Fetch Amazon Product Data and that Validate Price Value passes when pricing > 0.
3. Verify that Update Monitored Records and Append Price History write data to the correct sheets, and that Dispatch Email Alert sends an email when alert_status is not empty.
4. Once confirmed, toggle the workflow Active to enable scheduled monitoring.