This is a sample sheet with settings:

↑ Cells from the first row are holding special keys. 

Please see keys for this automation:  sheets_name and range_a1 . They help the script to form settings:

sets = {

  sheets_name: "Sample3",

  range_a1: "E4:E17"

}

 You may notice other keys on the left side of a setting sheet; here they are:

delimiter — any char for splitting things in settings, I usually use |

todos — this is the way we may stop this line execution from a sheet. To run this line, use 1. To make 2 or more checks, use delimited numbers: 1|1, 1|0. The script will execute the line if all todos = 1.

exit_messages — paired with todos, and also delimited: message1|message2. They specify what message to show if one of the todos is 0. 

log_file_id — specify if you want to write logs to another spreadsheet. Leave blank to use the current file.

log_sheet_name — sheet name for logs. May leave blank if logs are not needed.

success_message — the message returned by the function in case it was finished successfully.

If you specify the name of a sheet for logs (log_sheet_name), the script will write logs there. 

Here's a Sheet with sample logs ↓

It contains columns populated by Script:

• timestamp — time the function was executed.

• user — who executed the code

• json_log — information about settings and the result

You may also notice column [D] with Success Message. It is populated by the formula from the json_log column (see how).

Each automation has its own custom success message, exit message, and other preset stuff, which is optional. All this and more is passed to the executive function. While the function runs, it sets new values to the resulting JSON.

Sample JSON logs look like this ↓