3

Is it possible to get a list of the spreadsheets that are importing data from my sheet?

I maintain a spreadsheet that has raw data, and many other spreadsheets use IMPORTRANGE to import that data.

I need to update the structure of the original sheet, and would like a list of all the spreadsheets that depend upon it. Is there a way to find this out?

  • Are you using a common Google account or a G Suite account? – Rubén Dec 31 '18 at 19:01
1

There is no built-in feature that list the spreadsheets that use IMPORTRANGE to import data from a specific spreadsheet.

Considering that IMPORTRANGE to your spreadsheet could be added to any spreadsheet that any editor, viewer and commenter of your spreadsheet have access even if you don't have access to them, I think that there is no way to have a complete list other than asking those users to give you that information even manually or by running a script.

  • 1
    Thank you, Rubén. I just realized that I can use Tools > Activity Dashboard to see who has viewed the sheet and are the most likely people who need to be informed about the upgrades. – Michael Leahy Jan 21 at 17:27
  • @MichaelLeahy it's worthy to note that the Activity Dashboard is only available for G Suite accounts. – Rubén Jan 21 at 18:08

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.