When using IMPORTRANGE on Google Sheets, one has to "connect sheets" as follows:

enter image description here

Where can I check which sheets are connected, and what exactly (what access rights etc.) this "connection" implies?

  • @user0 Please don't add security as it's a meta-tag and meta-tags should be avoided. – Rubén May 23 '19 at 20:17

You are not able to check for "connection" anywhere in Google Sheets. Such a feature does not exist at the moment. As for the "what access rights" part: a spreadsheet that is connected can be read (scrapped) with IMPORTRANGE function and this can also be exploited to gain direct access (not ownership) to the whole spreadsheet.

| improve this answer | |

As it was mentioned on the other answer Google doesn't offer a place that include a list of the connected spreadsheets but you could create automatically that list by using Google Apps Script.

The access rights that the connection implies is read only and it's granted to the account that authorized the access. This connection will work while the authorizer has access to the spreadsheet, if they are removed then IMPORTRANGE will stop to import the data until another user authorize it again.

| improve this answer | |

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.