Step 2: Connect Google Sheets

Configure the spreadsheet used to store product URLs and update minimum prices.

1. Open Retrieve Product List and select the Google Sheet with Document set to [YOUR_ID] and Sheet set to gid=0 (Foglio1). Credential Required: Connect your googleSheetsOAuth2Api credentials.
2. Open Modify Sheet Price and confirm Operation is update.
3. In Modify Sheet Price, set the column mappings to:
   DATE → {{$now.format('dd/LL/yyyy')}}
   MIN PRICE → {{ $('Extract Product Price').item.json.result.price }}
   row_number → {{ $('Iterate Items').item.json.row_number }}
4. Keep Matching Columns set to row_number to update the correct row. Credential Required: Connect your googleSheetsOAuth2Api credentials.

Step 3: Set Up the Processing and Validation Nodes

Extract prices from Amazon and validate whether the new price is a new minimum.

1. In Iterate Items, keep default batch settings so each product row is processed individually.
2. Configure Extract Product Price with userPrompt set to You are an expert extraction algorithm. Extract the price of the Amazon product and websiteUrl set to {{ $json.URL }}. Enable renderHeavyJs and useOutputSchema. Credential Required: Connect your scrapegraphAIApi credentials.
3. In Validate Minimum Price, set the numeric comparison to Left Value {{ $json.result.price }} and Right Value {{ $('Iterate Items').item.json['MIN PRICE'] }}, using the lt (less than) operator.

Step 4: Configure Output and Loop Control

Send notifications and loop back to process the next product until all rows are complete.

1. In Telegram Price Notification, set chatId to [YOUR_ID] and text to The product {{ $('Iterate Items').item.json['PRODUCT '] }} (sold by {{ $json['MIN PRICE'] }}) has just hit its lowest price yet on Amazon! 🎉 Check it out: {{ $('Validate Minimum Price').item.json.website_url }}. Credential Required: Connect your telegramApi credentials.
2. Confirm the flow: Extract Product Price → Validate Minimum Price → Modify Sheet Price → Telegram Price Notification → Combine Streams → Iterate Items.
3. Verify the alternate path from Validate Minimum Price (when the price is not lower) goes to Combine Streams to continue iterating.

Step 5: Test and Activate Your Workflow

Run a manual test, verify updates and alerts, then enable scheduled monitoring.

1. Click Execute Workflow and use Manual Execution Start to run a test with a few rows from the sheet.
2. Successful execution should update MIN PRICE and DATE in the sheet and send a Telegram message when a new minimum is detected.
3. Once validated, activate the workflow so Utility: Timed Trigger runs it automatically on schedule.