Google Sheet Script - Multiple Getrange Looping

so I have a new problem. So far my script here can loop a sheet and find the text 'Bank', it will set the background color to red and it will take the value from another cell as ma

Solution 1:

You may look at similar questions:

Google Script - Internal Error after 15 seconds

Google script - Exceeded maximum execution time , help optimize

Google sheet script, times out. Need a new way or flip it upside down

Basic solution is to use getValues() one time and then loop values in 2d array:

var sheet = SpreadsheetApp.getActiveSheet(); 
var rows = sheet.getDataRange(); 
vardata = rows.getValues();

for (var i = 0; i < numRows; i++)
{
  var j = SomeValue; // column number - 1var row = data[i]; // row from origonal data rangevar value = row[j]; // value from data// some other code...   
} 

See more info about your problem here:

Your scripts will run faster if you can find ways to minimize the calls the scripts make to those services.