What are you trying to achieve?
My goal is to fill the MS Word template with data from Google Forms and Excel file. Excel rows needs to be filtered by matching values from multiple choice answer from Google Form. These rows also contains other necessary data in other columns. Few of the columns needs to be put in the Word as a table. Other columns values needs to be summed up and put into Word as one value. There are also few other fields from Google forms that needs to land in the Word document.
I managed to do almost all of the work, but I don’t know how to sum values from one excel column and put this sum into Word. Every time I’m getting the last value from all filtered rows instead of sum. Please refer to the screenshots.
Screenshots: scenario setup, module configuration, errors
blpr.blueprint.json (87.3 KB)