I have to work with google spreadsheets.
I am using some template spreadsheets which all contain a lot of links to other spreadsheets.
The problem is that whenever I make a copy of the template spreadsheet to use most of the links(created with the importrange function) require me to give them access again
What I want to do is make a script that would allow me to import all the links in one press. I tried to make an app script but I can't found any way to access the textbox with the "allow access" button so that i can make my script. My questions are: is there any way to access the "allow access" button programatically? or is there any other way to solve my problem and allow access to all links in one press?
See Question&Answers more detail:
os 与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…