My goal is for the scenario to retrieve a excel workbook from an attachment in an email i receive, download it and list worksheets (which its doing successfully as there are 3 separate tabs). But i can’t figure out how to get the data in the excel in a format which Open AI can analyse and provide inisights to me for as its not reading the data. also, i want the sheets all to be combined so its done in one operation and not 3. and i want it to send me 1 report in the end and not 3. HELP?!
Every result (item/record) from trigger/iterator/list/search/match modules will output a bundle. This can result in multiple bundles, which then trigger multiple operations in future modules (one operation per bundle). To “combine” multiple bundles into a single variable, you’ll need to use an aggregator of some sort.
Aggregators are modules that accumulate multiple bundles into one single bundle. An example of a commonly-used aggregator module is the Array aggregator module. The next popular aggregator is the Text Aggregator which is very flexible and can apply to many use-cases like building of JSON, CSV, HTML.
You can find out more about the other types of aggregator modules here:
I would suggest completing the Make Academy before jumping into building a complete scenario. If you need specific assistance when you are building a scenario it’s easier to help you then. Otherwise, you can also hire a professional by posting a request in the Hire a Pro category.
Here are some useful links and guides you can use to learn more on how to use the Make platform, apps, and app modules. I found these useful when I was learning Make, and hope they might benefit you too —