I have the following code that connects to a single google sheet and different tabs, and the web app load times are fast (almost 3-5 seconds). However, I need to connect to not one sheet, but 23 different ones (with different Urls). When I make the change (to the second code that I share) the loading times of the web app are too slow, very very slow (between 4 to 5 minutes).
How could I make the loading and response times of the Web App faster, like when I use a single URL, but now using 23 different URLs? Is there any other alternative?
I can only use pure javascript. I’m new to this so please bear with me. Any help will be greatly appreciated. Thanks in advance for your time and help.
SAME GOOGLESHEETS DOCUMENT (SAME URL, DIFFERENT TABS)
WITH THIS SCRIPT, THE WEB APP LOADS QUICKLY
var ss_operations_0 = SpreadsheetApp.openByUrl("URL0");
var sheetoperations1 = ss_operations_0.getSheetByName("SHEET1");
var sheetoperations2 = ss_operations_0.getSheetByName("SHEET2");
var sheetoperations3 = ss_operations_0.getSheetByName("SHEET3");
var sheetoperations4 = ss_operations_0.getSheetByName("SHEET4");
var sheetoperations5 = ss_operations_0.getSheetByName("SHEET5");
var sheetoperations6 = ss_operations_0.getSheetByName("SHEET6");
var sheetoperations7 = ss_operations_0.getSheetByName("SHEET7");
var sheetoperations8 = ss_operations_0.getSheetByName("SHEET8");
var sheetoperations9 = ss_operations_0.getSheetByName("SHEET9");
var sheetoperations10 = ss_operations_0.getSheetByName("SHEET10");
var sheetoperations11 = ss_operations_0.getSheetByName("SHEET11");
var sheetoperations12 = ss_operations_0.getSheetByName("SHEET12");
var sheetoperations13 = ss_operations_0.getSheetByName("SHEET13");
var sheetoperations14 = ss_operations_0.getSheetByName("SHEET14");
var sheetoperations15 = ss_operations_0.getSheetByName("SHEET15");
var sheetoperations16 = ss_operations_0.getSheetByName("SHEET16");
var sheetoperations17 = ss_operations_0.getSheetByName("SHEET17");
var sheetoperations18 = ss_operations_0.getSheetByName("SHEET18");
var sheetoperations19 = ss_operations_0.getSheetByName("SHEET19");
var sheetoperations20 = ss_operations_0.getSheetByName("SHEET20");
var sheetoperations21 = ss_operations_0.getSheetByName("SHEET21");
var sheetoperations22 = ss_operations_0.getSheetByName("SHEET22");
var sheetoperations23 = ss_operations_0.getSheetByName("SHEET23");
DIFFERENT GOOGLESHEETS DOCUMENTS (DIFFERENT URLS)
WITH THIS SCRIPT, THE WEB APP LOADS VERY SLOW
var ss_operations_1 = SpreadsheetApp.openByUrl("URL1");
var ss_operations_2 = SpreadsheetApp.openByUrl("URL2");
var ss_operations_3 = SpreadsheetApp.openByUrl("URL3");
var ss_operations_4 = SpreadsheetApp.openByUrl("URL4");
var ss_operations_5 = SpreadsheetApp.openByUrl("URL5");
var ss_operations_6 = SpreadsheetApp.openByUrl("URL6");
var ss_operations_7 = SpreadsheetApp.openByUrl("URL7");
var ss_operations_8 = SpreadsheetApp.openByUrl("URL8");
var ss_operations_9 = SpreadsheetApp.openByUrl("URL9");
var ss_operations_10 = SpreadsheetApp.openByUrl("URL10");
var ss_operations_11 = SpreadsheetApp.openByUrl("URL11");
var ss_operations_12 = SpreadsheetApp.openByUrl("URL12");
var ss_operations_13 = SpreadsheetApp.openByUrl("URL13");
var ss_operations_14 = SpreadsheetApp.openByUrl("URL14");
var ss_operations_15 = SpreadsheetApp.openByUrl("URL15");
var ss_operations_16 = SpreadsheetApp.openByUrl("URL16");
var ss_operations_17 = SpreadsheetApp.openByUrl("URL17");
var ss_operations_18 = SpreadsheetApp.openByUrl("URL18");
var ss_operations_19 = SpreadsheetApp.openByUrl("URL19");
var ss_operations_20 = SpreadsheetApp.openByUrl("URL20");
var ss_operations_21 = SpreadsheetApp.openByUrl("URL21");
var ss_operations_22 = SpreadsheetApp.openByUrl("URL22");
var ss_operations_23 = SpreadsheetApp.openByUrl("URL23");
var sheetoperations1 = ss_operations_1.getSheetByName("SHEET1");
var sheetoperations2 = ss_operations_2.getSheetByName("SHEET1");
var sheetoperations3 = ss_operations_3.getSheetByName("SHEET1");
var sheetoperations4 = ss_operations_4.getSheetByName("SHEET1");
var sheetoperations5 = ss_operations_5.getSheetByName("SHEET1");
var sheetoperations6 = ss_operations_6.getSheetByName("SHEET1");
var sheetoperations7 = ss_operations_7.getSheetByName("SHEET1");
var sheetoperations8 = ss_operations_8.getSheetByName("SHEET1");
var sheetoperations9 = ss_operations_9.getSheetByName("SHEET1");
var sheetoperations10 = ss_operations_10.getSheetByName("SHEET1");
var sheetoperations11 = ss_operations_11.getSheetByName("SHEET1");
var sheetoperations12 = ss_operations_12.getSheetByName("SHEET1");
var sheetoperations13 = ss_operations_13.getSheetByName("SHEET1");
var sheetoperations14 = ss_operations_14.getSheetByName("SHEET1");
var sheetoperations15 = ss_operations_15.getSheetByName("SHEET1");
var sheetoperations16 = ss_operations_16.getSheetByName("SHEET1");
var sheetoperations17 = ss_operations_17.getSheetByName("SHEET1");
var sheetoperations18 = ss_operations_18.getSheetByName("SHEET1");
var sheetoperations19 = ss_operations_19.getSheetByName("SHEET1");
var sheetoperations20 = ss_operations_20.getSheetByName("SHEET1");
var sheetoperations21 = ss_operations_21.getSheetByName("SHEET1");
var sheetoperations22 = ss_operations_22.getSheetByName("SHEET1");
var sheetoperations23 = ss_operations_23.getSheetByName("SHEET1");