EN
for (var i=0; i<sheets.length; i++) {
if (sheets[i].getName() === "net_worth" || sheets[i].getName() === "report") {}else
{
var response = UrlFetchApp.fetch(url + url_ext +
sheets[i].getSheetId(), { // Convert individual worksheets to PDF
headers: {
'Authorization': 'Bearer ' + token
}
});
blobs[i] = response.getBlob().setName(sheets[i].getName() +
'.pdf'); //convert the response to a blob and store in our array
Utilities.sleep(6000);// pause in the loop for 6000 milliseconds
иначе ошибка 429 слишком быстро
Logger.log("sheets[i].getName() = " + sheets[i].getName())
}
}
