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?
Trying to mail merge information from several different tabs of a Google sheet
google spreadsheets