- Import the target-price-alerts.xlsx into Google Sheets
- Copy/paste the apps_script.js code into Extensions > Apps Script
- In Extensions > Apps Script > Triggers, add a new trigger on the list using the following format. It's important to set the function checkPrices to run.
- Make a few test changing the columns C and D
Blue fields needs to be filled by the user, white ones are manager automatically. Checkbox can be disabled/enabled also manually