The first time you use IMPORTRANGE to import data from another sheet, you have to grant permission for the destination sheet to access the source sheet. To do this you can click on the “Allow Access” button that appears in the cell with the formula.
I would like to avoid to use “Click it” activity. How to give this permission it in different way?
oh man I need this information as well, did you manage to solve it?
ashokkarale
Akash_Javalekar1
KezayAlperen
Yoichi
naveen.s