Zystkmt

I do not know Script.

I have found a way to reference an external sheet faster than ImportRange, but I do not know how to use this script.

Can I get an example that uses this script?

I need help.

 // this function creates a menu item on the top that you can click the refresh the data, you could also use triggers to refresh

function onOpen() {

  var spreadsheet = SpreadsheetApp.getActive();

  var menuItems = [{name: 'Refresh', functionName: 'getData'}];

  spreadsheet.addMenu('Menu', menuItems);

}

function getData() {

  var key = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Sheet1").getRange("A1").getValue(); // you would place the spreadsheet key in A1, alternatively you can enter the key directly here rather than referencing

  var sourceSs = SpreadsheetApp.openById(key);

  var sourceSheet = sourceSs.getSheetByName("Sheet1");

  var sourceRange = sourceSheet.getRange("A1:C");

  var sourceValues = sourceRange.getValues(); 

  var destSs = SpreadsheetApp.getActiveSpreadsheet();

  var destSheet = destSs.getSheetByName("Sheet1");

  var desRange = destSheet.getRange("A1:C")

  destRange.setValues(sourceValues);

}

Sorry. I do not seem to be properly delivered because I am not fluent in English.
I had to come to StackOverFlow because there were very few GAS users in Korea.

Initially, // my level knows how to use most of the functionality of a spreadsheet, except scripts.

I've had over 100,000 rows in my experience, and after splitting the sheet, I used the IMPORTRANGE function to collect the results in a single spreadsheet.

However, this spreadsheet had a huge amount of real-time updates, so we had to find a way to speed it up.

After that, I found the source code above and saved it. However, an error occurred at destRange.setValues ​​(sourceValues); at the bottom.

I tried to modify the source code, but the result is the same.

I think you can see how to use the source code in the examples that are actually applied.

You need to do a few things, not hard but specific:
1) Get the keys to the source and target spreadsheets. These are the long gobbledy-gook strings inside the URL that opens the sheet. If you see a URL like this: https://docs.google.com/spreadsheets/d/1fPvp5o2-xeH04STyeaoC_iJTy1JRGQZki3_j1l39wMQ/edit#gid=0, the ID of the sheet is the part after spreadsheets/d/ and before /edit. Place those keys in the code for sourceSs and destSs.

Open the target sheet. From the menu choose Tools -> Script editor. Assuming you've done nothing so far, you'll get a default "MyFunction()". Clear that text and copy/paste your code above, including the keys. Save the code. Close the code window, close the spreadsheet and reopen the target spreadsheet.

To actually update the values on the target spreadsheet, the user will be required to select the menu item "Refresh". The first time, the user will be required to authorize permissions to the script.

Give this a try. It's quite straightforward, once you know how.