Write and explain a scheduled Apps Script

Every Monday you export sales, open a spreadsheet, check stock against reorder points, and message the exceptions.

Before you use the output

• Test on the copy with three deliberately edited rows. Knowing the right answer in advance is what makes the test meaningful.
• The header check is the most important safety feature. Confirm it is in the script before deploying.
• Confirm the 'no exceptions' email is sent. An automation that is silent when all is well cannot be distinguished from a broken one.
• Check the execution log after the first two real runs, even if the emails look right.