How can I use "=importrange" with G Merge Plus?

1. Do you collect data from a Google Form in a Google spreadsheet and use the function "=importrange" to pull some data from the Form response Sheet to a second Sheet?

 

To use G Merge Plus on this second sheet to generate documents or emails automatically based on the second sheet content use Generate On form Submit. 

If you want to Generate Now, or another time slot, ensure you have set a row filter on a criteria column that does not have a formula, like "qty Is Not Empty".

Warning: If you do not add a row filter G Merge Plus will generate a document and/or email for every row indicated in the range of your formula.

2. To generate 2 separate documents based on a Google Form response use =importrange to copy responses to a 2nd spreadsheet.

You will then be able to set up a separate document template and generate 2 documents from the same Google Form.

On this 2nd spreadsheet:

1. Create a row filter on a criteria column that does have a formula: Criteria column "Is Not Empty"

2. Generate every hour or daily.