How to add scripts to Google apps If you’re comfortable with JavaScript, you can write your own original programs. Just open Docs or Sheets and go to Extensions, then click on Apps Script.

First, you need to identify the Google Sheet document from which you want to embed data from in another sheet, and grab the url. Second, you need to determine which subsheet you want to import ...