How to optimize the script for thousands of API calls made one-by-one

[Ihor Stefurak]

I have a function that takes an email address from a cell A1, makes URLfetch to my API and returns a response to B1. After a few hundred requests the function freezes.

How can I optimize the script for thousands of API calls without freezing? Any suggestions are welcomed.

The function:

function startProcess(input) {

     try {

       var response = UrlFetchApp.fetch("https://someapihere.com/&email=" +input);

       var json = response.getContentText();

       var data = JSON.parse(json);

       var deliverableResult = data.deliverable;

        if (deliverableResult == true) {

                 return [[deliverableResult]];

                }

       } catch (e) {

       return "the mail server doesn't respond";

     }

      Utilities.sleep(1500);

} 

[Romain Vialard]

You can use the fetchAll() method to make hundreds of urlfetch calls simultaneously.

https://developers.google.com/apps-script/reference/url-fetch/url-fetch-app#fetchAll(Object)

[Ihor Stefurak]

Thanks, Romain. I will try to rewrite the function and come back with questions if any.