How to allow access for importrange function via apps script?
@Franzi suggested using undocumented approach which works and does not require making a donor/source spreadsheet public. Here’s how you can do it from Google App Script: function addImportrangePermission() { // id of the spreadsheet to add permission to import const ssId = SpreadsheetApp.getActiveSpreadsheet().getId(); // donor or source spreadsheet id, you should get it somewhere const … Read more