Numbers Of Rows To Process

I would like to make sure that an e-mail is not send twice. The script itself is working, however the Insertion of: sheet.getRange(startRow + i, 6).setValue(EMAIL_SENT); does not w

Solution 1:

Short answer

Instead of using for(i in data){...} use for(var i = 0;i < data.lenght;i++) {...}

Explanation

for (variable in object) assigns a different property name on each iteration but what you need is the data index to be used to calculate the row index.

Reference

• for..in