working with sheets

Examples of use

Sometimes, you will want to use Apps Script to automate modifying a sheet in its own right, e.g to carry out a complicated sort or apply a long sequence of cell formattings. Or you might want to create your own bespoke function for performing a calculation within a cell.

More often, however, a sheet will be where you store the data that a script will use to carry out other actions, such as modifying a Google Classroom course. It might also be where the script outputs a summary of its actions to — as described in Apps Scripts Fundamentals, scripts have no memory and so every execution is a fresh run of the original script. You might therefore need somewhere to record what happened in the previous execution, ready for the next.