I need to restrict the ImportRange function below to show only visible rows as some of the rows are filtered and some of the rows are grouped.


Follow this answer.

  1. Create a new sheet within the same document
  2. Use filter function (Set the A1 cell to be =filter(Sheet1!A:X, Sheet1!A:A>1)). (See docs on the filter function.)
  3. Import range from this new sheet.

At this time IMPORTRANGE can't import only visible rows. Currently there isn't any built-in function that does that and this can't be done by using a custom function as accesing an external range require authorization and custom functions can't use methods that require it.

The alternative is to use another kind of script, and add-on or a third party application.

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