我在这部分代码中看到了问题:

I see the problem in this part of code:

do { 
  // read info from the sheet
  range.getValue();
  // more code here...

} // only do while x = max number of suppliers reached
  while (y<x)

操作getValue需要很多时间才能运行.***做法是使用整个范围:

Operation getValue takes much time to run. Best practice is to use the whole range:

var data = sheet.getDataRange().getValuses();

，然后将数据用作进一步计算的来源.

and then use data as source for further calculations.

在此处查看更多信息:

https://developers.google.com/apps-script/best_practices