{"id":12794,"date":"2025-05-27T15:19:52","date_gmt":"2025-05-27T14:19:52","guid":{"rendered":"https:\/\/gatlabs.com\/knowledge\/?post_type=docs&p=12794"},"modified":"2025-05-27T16:54:32","modified_gmt":"2025-05-27T15:54:32","password":"","slug":"find-google-spreadsheets-linked-to-others-with-gat","status":"publish","type":"docs","link":"https:\/\/gatlabs.com\/knowledge\/tech-tips\/find-google-spreadsheets-linked-to-others-with-gat\/","title":{"rendered":"Find Google Spreadsheets Linked to Others with GAT+"},"content":{"rendered":"

Spreadsheet upon spreadsheet: Torn Apart, but Forever Linked<\/h3>\n

When using Google Sheets<\/a>, there is a function embedded that will allow you to link specific parts of some spreadsheets together. This can be really useful for incorporating multiple datasets from different spreadsheets, and incorporating them into one.<\/p>\n

However, trouble can arise when one spreadsheet gets deleted, or the user that owns one of the spreadsheets gets deleted. It’s important to be able to keep track of where the different parts of the data are kept.<\/p>\n

GAT+<\/a>, our powerful Audit Tool for Google Workspace, can help you find these spreadsheets and ensure that they are not lost with its scheduled reporting feature.<\/p>\n

First off, let’s explore how the spreadsheet import feature itself works with the following example. If you are already familiar with this process, skip to Part 2<\/strong><\/a>.<\/strong><\/p>\n

Part 1: Linking Spreadsheets together<\/h2>\n

Both Olivia and the members of her team have a shared To-Do list. Olivia also has her own personal To Do list. In this example, we will incorporate Olivia’s To Do list spreadsheet into the shared spreadsheet that her team uses , so that the tasks Olivia adds are automatically reflected on her teams To Do list.<\/p>\n

Step 1: Prepare Your Source Spreadsheet<\/strong><\/p>\n