Daily competitor price tracker with Slack alerts

Build me a competitor product price tracker that runs every day at 6am on a cron schedule.

Inputs: a Google Sheet I maintain with one competitor product per row. The columns include product URL, product name, last price, last currency, last availability, and last checked timestamp. Use Google Sheets Get Values to read this tracker tab into the workflow.

For each row, call Diffbot Extract Product on the URL to pull title, price, currency, availability, and SKU.

Then do two writes back to Google Sheets. First, use Append Values to add a timestamped row to a separate Price History tab with the timestamp, URL, product title, price, currency, and availability. Second, use Update Values to write the new current price, currency, availability, and last checked timestamp back to the matching row on the tracker tab so the latest snapshot lives on the tracker.

Compute a change signal per product. If the absolute percent change between last price and new price is greater than a configurable threshold (default 5 percent), or if availability flipped between in stock and out of stock, treat the row as changed.

For every changed row, use Slack Send a Message to post an alert to a configurable channel. The message should name the product, include the old price and new price with currency, the percent change, the new availability, and a link to the product page.

Keep this fully deterministic. No model calls, no judgement steps. Every step is a known node: cron trigger, Google Sheets read, loop over rows calling Diffbot, Google Sheets append and update, conditional Slack post. Skip rows where Diffbot returns no price rather than failing the whole run, and continue processing the rest.

Configurable values: schedule time and timezone, tracker spreadsheet id and tab name, history tab name, percent change threshold, Slack channel.