Hi, as stated in the title above.
For context, I have 7 flows, and each flow runs with the triggers:
1. when a response is submitted via typeform
2. create item
3. get file content
4. create file
5. run script
In the run script trigger, there is a single spreadsheet that will be populated when a person answers our Typeform which then transfers the answers to the spreadsheet in each 7 flow based on topics.
Now, we have another spreadsheet that is a total of the questions located in all 7 flows (Typeform questions) which means the all of the content from the 7 typeform questions are put into, we need that (total spreadsheet) spreadsheet to be populated as well when the flow is being run. The difference is the spreadsheet used instead of containing one topic, it has all of the questions from the 7 typeform and answers of one single person in the total spreadsheet.
How do i do that? Is there a step I can do like creating another trigger "run script" and then put all the questions in the total spreadsheet in there or create an entirely new Master Flow where all of the results from the 7 flows are stored in there?