Step 2: Connect Google Sheets

This step loads your product URLs and baseline prices from a sheet.

1. Open Retrieve Sheet Rows and select your spreadsheet in Document.
2. Set Sheet Name to list urls (value gid=0).
3. Credential Required: Connect your googleSheetsOAuth2Api credentials.
4. Ensure your sheet includes columns like url and baseline price (usd) used later in calculations.

Step 3: Batch and Fetch Live Prices

Items are processed in batches, and each URL is scraped for live pricing data.

1. Open Batch Iterate Items and keep default settings for batch processing.
2. Connect Retrieve Sheet Rows → Batch Iterate Items → Decodo Amazon Fetch.
3. In Decodo Amazon Fetch, set Operation to amazon.
4. Set URL to {{ $json.url }}.
5. Credential Required: Connect your decodoApi credentials.

Step 4: Compute Price Changes and Route by Threshold

This step calculates the price delta and routes results to alerts or updates.

1. Open Compute Price Delta and confirm the JavaScript calculates diff and diffPercentage using Batch Iterate Items data.
2. Ensure Compute Price Delta references $('Batch Iterate Items').first().json['baseline price (usd)'].
3. Open Route by Price Shift and verify three rules:
4. High: {{ $json.diffPercentage }} > 10
5. Normal: {{ $json.diffPercentage }} ≥ 0
6. Low: {{ $json.diffPercentage }} < 0
7. Confirm Compute Price Delta → Route by Price Shift connection.

Step 5: Configure Alerts, Meetings, and Updates

Based on the route, alerts are sent, meetings are scheduled, or updates are emailed.

1. For the High path, open Alert Leadership via Telegram and keep the message template using expressions like {{ $json.title }} and {{ $json.diffPercentage }}.
2. Credential Required: Connect your telegramApi credentials.
3. Open Schedule Review Meeting and set Start to {{ $now.plus(2, 'hour') }} and End to {{ $now.plus(3, 'hour') }}.
4. Set Summary to [IMPORTANT DISCUSSION] Price Increase {{ $('Compute Price Delta').item.json.title }} and update Attendees with your emails.
5. Credential Required: Connect your googleCalendarOAuth2Api credentials.
6. For the Low path, open Email Stakeholder Update and set Send To to [YOUR_EMAIL].
7. Keep Subject as Price Drop - {{ $('Compute Price Delta').item.json.title }} and the HTML Message template intact.
8. Credential Required: Connect your gmailOAuth2 credentials.
9. For the Normal path, No-Action Placeholder intentionally performs no action.

Route by Price Shift outputs to Alert Leadership via Telegram, No-Action Placeholder, or Email Stakeholder Update based on the rule matched.

Step 6: Manage the Pause and Batch Loop

After each action branch, the workflow pauses and then continues batch processing.

1. Confirm Alert Leadership via Telegram → Schedule Review Meeting → Pause Execution.
2. Confirm Email Stakeholder Update → Pause Execution and No-Action Placeholder → Pause Execution.
3. Verify Pause Execution outputs back to Batch Iterate Items to continue processing remaining items.

Step 7: Test and Activate Your Workflow

Validate the full flow before turning on scheduled automation.

1. Click Execute Workflow to run a manual test from Scheduled Automation Start.
2. Confirm Retrieve Sheet Rows pulls data and Decodo Amazon Fetch returns live price results.
3. Check that Compute Price Delta outputs price, baseline, and diffPercentage values.
4. Verify the correct path is taken in Route by Price Shift and the corresponding alert or email is sent.
5. Once successful, toggle the workflow to Active for production scheduling.