Step 2: Connect Google Sheets

Configure the Google Sheets nodes to read product data, track check status, and reset the check flag.

1. Open Fetch Unchecked Entry and set Document to your sheet ID (currently [YOUR_ID]) and Sheet to Sheet1 (gid 0).
2. Confirm the filter in Fetch Unchecked Entry is set to checked = 0 with Return First Match enabled.
3. Open Mark Row Checked and confirm Operation is update, with column mapping for checked = 1, Product Name = {{ $('Fetch Unchecked Entry').item.json['Product Name'] }}, and competitor price = {{ $('Convert Price to Number').item.json.price }}.
4. Open Fetch Checked Entry and ensure the filter is checked = 1 with Return First Match enabled.
5. Open Reset Check Flag and confirm Operation is update with checked = 0 and Product Name = {{ $json["Product Name"] }}.
6. Credential Required: Connect your googleSheetsOAuth2Api credentials in Fetch Unchecked Entry, Mark Row Checked, Fetch Checked Entry, and Reset Check Flag.

Step 3: Set Up Price Extraction and Comparison

Configure the competitor page fetch, HTML extraction, number conversion, and threshold comparison.

1. Open Retrieve Competitor Page and set URL to {{ $json['Competitor URL'] }}.
2. Open Extract Price Element and confirm Operation is extractHtmlContent with CSS Selector = .price_color and key price.
3. Open Convert Price to Number and keep the provided JavaScript that strips £ and parses a float.
4. Open Compare Price Threshold and confirm the condition is number < with Left Value = {{ $json.price }} and Right Value = {{ $('Fetch Unchecked Entry').item.json['my Price'] }}.

⚠️ Common Pitfall: If the competitor site changes its HTML class, update Extract Price Element to match the new selector.

Step 4: Configure Notifications and Looping Logic

Send Discord alerts and manage the loop that continues checking until all rows are processed.

1. Open Discord Price Alert and set Content to competitor has decreased price on product: {{ $('Fetch Unchecked Entry').item.json['Product Name'] }} our price: {{ $('Fetch Unchecked Entry').item.json['my Price'] }} competitor's price:{{ $('Convert Price to Number').item.json.price }}.
2. Credential Required: Connect your discordWebhookApi credentials in Discord Price Alert.
3. Open Discord Completion Notice and set Content to Price checks complete..
4. Credential Required: Connect your discordWebhookApi credentials in Discord Completion Notice.
5. Confirm the logic flow: Compare Price Threshold sends alerts to Discord Price Alert when true, and sends directly to Mark Row Checked when false.
6. Confirm the loop: Mark Row Checked returns to Fetch Unchecked Entry to process the next row.
7. Confirm the completion flow: Verify Unchecked Exists routes to Discord Completion Notice when no unchecked rows remain, then to Fetch Checked Entry, Validate Row Presence, and Reset Check Flag to reset checked rows for the next cycle.

Step 5: Test and Activate Your Workflow

Validate the end-to-end cycle and enable the schedule.

1. Click Execute Workflow to run a manual test starting from Scheduled Automation Kickoff.
2. Verify a row with checked = 0 is fetched and processed through Retrieve Competitor Page → Extract Price Element → Convert Price to Number.
3. Confirm the comparison in Compare Price Threshold correctly routes to Discord Price Alert (true) or straight to Mark Row Checked (false).
4. Check that Mark Row Checked updates checked to 1 and writes the competitor price to the sheet.
5. When no unchecked rows remain, confirm Discord Completion Notice fires and Reset Check Flag resets checked to 0.
6. Turn the workflow Active to enable scheduled execution.