According to the page on IMPORTRANGE, "In the new version of Google Sheets, spreadsheets must be explicitly granted permission to pull data from other spreadsheets using IMPORTRANGE.". I'm using apps script to automatically create sheets based on a template that contains a cell with IMPORTRANGE so do I have to manually go into each newly created sheet after it is created in the script to approve the connection between each sheet or is there a way to do this in apps script after it is created? Both sheets are owned by me but I guess this requirement to connect the sheets is not related to ownership.
