function generateMap() {
const scriptPrp = PropertiesService.getScriptProperties();
const anglishWordsE = new Map();
//open by the correct Id
var sheet = spreadSheet.getSheetByName("Wordbook");
//select C2 all the way down the column
var unformattedMeanings = sheet.getRange(2,3,sheet.getLastRow() - 1, 1).getValues();
var unformattedWord = sheet.getRange(2,1,sheet.getLastRow() - 1, 1).getValues();
for(var i = 0; i < unformattedMeanings.length; i++)
{
//split based on the dot seperator
const splitMeanings = unformattedMeanings[i].toString().trim().slice(1,-1).split("᛫");
for(var b = 0; b < splitMeanings.length; b++)
{
// get anglish word
const anglishWord = unformattedWord[i].toString();
console.log(anglishWord);
console.log(splitMeanings[b]);
anglishWordsE.set(anglishWord, splitMeanings[b]);
console.log(anglishWordsE);
}
}
//console.log(anglishWordsE);
//scriptPrp.setProperty("anglishWords", JSON.stringify([...anglishWordsE]));
}