javascript - Replace Values of Spreadsheet Column Google Scripts -

javascript - Replace Values of Spreadsheet Column Google Scripts -

i want replace values of range google spreadsheet this:

values range:

viki john mark

replace with:

viki@domain-x.com john@domain-y.com mark@domain-z.co.il

as see need check each value in order determine email want replace with.

this i've got far (getting range of names)

var taskmanagerrange= sheet.getrange(2,4,lastrow-startrow+1,1 ); var taskmanagervalues=taskmanagerrange.getvalues();

then, how actual values:

for (var = 0; <= numrows - 1; i++) { var taskman=taskmanagervalues[i][0]; }

i need output within script (for sending emails), meaning don't want replace spreadsheet range, values.

javascript google-apps-script