Google Forms and MS Word template

[3dbesta]

What are you trying to achieve?

My goal is to fill the MS Word template with data from Google Forms. One of the fields in template is table, which needs to be populated with data from multiple choice answer. Some of the additional data for this table needs to be pulled from the excel, based on values from multiple choice answer in Google Form.

The problem is, that if there are multiple matches between multiple choice answer and excel rows I am getting the same amount of output Word documents instead of only one.

How I prepared the flow:

1. Check for the new responses in Google Form
2. Get additional data from Excel based on multiple choice answer
   2.1. Create an Array based on multiple choice answers
   2.2. Filter excel rows - take only rows matching the values from array
   2.3. Aggregate Excel rows to one array
3. Download word template
4. Fill word template

Screenshots: scenario setup, module configuration, errors

Integration Google Forms.blueprint.json (62.6 KB)

[3dbesta]

OK, fixed by myself. The mapping was incorrect, also there was too many steps and wrong Word template module - should’ve take the one for batch.

Solution from Word template with loop not working with array aggregator helped