Easily import data from other Sheets without impacting performance.

- google sheets tagJavaScript tag Google Workspace Marketplace


This add-on allows you to import data from a list of other Sheets without impacting performance. Great for periodic updates of data-sets spanning multiple documents. You can also create documents from form submissions to make imports as easy as possible.


Import data from other documents listed in a spreadsheet.

If any sheets/ranges cannot be found, or you do not have access to them, they will be displayed in a dialog once the import has completed. IMAGE

The import will output the values from the target sheets in the specified tab, overwriting existing data. IMAGE.

​Template Setup

Create documents from templates based on form submissions.


Tags identify the questions in a form and can be used to set the folder, file name and variables of the created document dynamically based on a form response. For example, a path of “DataPull Documents/<<1783560853>>/<<1481065390>>” could become “DataPull Documents/Europe/London”. IMAGE


Here’s what DataPull does with each of the permissions it requires:

Uh-oh, Something Broke!

Contact me, giving as much detail as you can.