Web Applications Stack Exchange is a question and answer site for power users of web applications. It only takes a minute to sign up.
Sign up to join this community
I use Autocrat (and love it) for pulling field information from one sheet into the letter. But the information I need to use is on separate tabs of the Google sheet file.
Another way would be to copy the data from all the sheets into one but it's a tedious process AND if any data changes on the original sheets, it won't be updated on the copy.
Any recommended apps or am I missing another easy way?
You cannot use more than one sheet with Autocrat, so the best work-around as you allude to is to aggregate the data in one sheet. There is a way of doing this while also preserving the integrity of your data: the function importrange. See the Google help page on it here.
With this function, you can import data from one sheet or many sheets into one "master" sheet and preserve a live link, so to speak. Once the connection is established, you will see nearly live updates in the destination sheet after a change is made in a source sheet.
Two things to note before using it:
You must be the owner of any/all sheets you want to use as source documents in your importrange function as you have to request access to that data.
You may need to refresh the page once or twice to get your data to load the first time. However, once it does load successfully, you should see that connection in pretty close to real time.
You can then run Autocrat from the one sheet that is acting as the destination of all your source data.
