Is there auto " allow access " for importranges in Google Sheets?

These users are not going to be able to figure out how to Allow Access (for example, some of the IMPORTRANGEs are buried in queries and need to be copy-pasted out manually to trigger the Allow Access button). Is there a script, or some other solution, that will auto-Allow Access in a spreadsheet?
For More Information Please Refer:

You May Also Like to Read: