I have made a Google Sheet that links to another Google Sheet, using IMPORTRANGE(). Although the linked sheet has Public accessibility, I am still required to authorize access to the linked sheet. Why is that?

  • Can you edit your question and elaborate or add some details (what you want to achieve, what type of link between sheets, etc..) ? For what it's woth, when using IMPORTRANGE you must explicitly grant permission (source : importrange documentation). Related Q&A : 1. IMPORTRANGE connect sheets 2. Automatically “Allow Access” for IMPORTRANGEs in Google Sheets? – pjmg Oct 10 '19 at 19:43
  • I wonder what is the criteria behind this. If a sheet is shared with "anyone with the link", this means the sheet may be accessed by anyone. Period. Why now GAS requires additional auth. process? – Riccardo Oct 11 '19 at 8:06
  • My guess is maybe google doesn't want people to abuse the tool. (I dunno, there's like a ton of way of achieving that. First that come to mind is automate scraping at mass scale with 1000+sheets for free) – pjmg Oct 11 '19 at 8:58
  • Questions about company internal policies, app design decisions, etc. are off-topic on this site. – Rubén Oct 11 '19 at 21:44

Your Answer

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

Browse other questions tagged or ask your own question.