Template Data Sheet

When you name a Google Sheet for saving your data, if the sheet does not already exist it will be created from a template sheet that you must name.

The essential thing is the data sheet, and hence the template must contain the right columns in the right order. A simple starting template is shown below.