5

I have a set of Google Spreadsheets I want to reproduce (not share) for several users. 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?

4

Short answer

Is there a script, or some other solution, that will auto-Allow Access in a spreadsheet?

The only solution is that the owner or any editor do the mandatory authorization for each of the external spreadsheets.

Explanation

Google Apps Script doesn't include any class or method for Google Sheets built-in functions, so the authorization should be done on the Google Sheets UI by the owner or an editor of the spreadsheet.

The good news is that the access authorization is required only one time by external spreadsheet, so you could add a sheet having something like =IMPORTRANGE(url,"A1") for each spreadsheet, authorize the access to each one, and after that delete that sheet.

Note: The user who granted the permission should not be removed from the sharing settings.

References

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.