This question is part of finding a solution to a

Second run:

Third run:

CodePudding user response：

Save and Retrieve Array from Properties Service

function saveArray(a) {
  PropertiesService.getScriptProperties().setProperty("myarray",JSON.stringify(a));
}

function getArray() {
  return JSON.parse(PropertiesService.getScriptProperties().getProperty("myarray"));
}