Web Applications Stack Exchange is a question and answer site for power users of web applications. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

This is what I'd like to do:

The public (even you!) would have view access to a particular Google sheet. It would draw data from another Google sheet, which you DO NOT have any access to. Using formulas I would filter out the non-public data in the public sheet.

My understanding is that ImportRange will not let you reference a sheet you do not have direct access to, but I am no Google sheets wizard, there may be another way to accomplish my goals.

This seems to be pretty close, still digesting how to implement it: http://stackoverflow.com/a/14558223/2589506

Otherwise, I cannot have this automated, which would be lame.

Thanks for the help!

share|improve this question
I ended up using a Google script. Never used that before... heck, I didn't know it existed. It's really cool! Far better than Visual Basic scripting for Excel! – Zoop Jul 19 '13 at 14:41
Might you share it for the benefit of others? – pnuts Sep 25 '14 at 17:56

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.