Hi, I’m trying to get Chat GPT to analyse data from a looker report and deliver this into a Google Doc, using Outlook to deliver the content.
I’ve created a flow where I email a Looker Studio report to Outlook, then pass the email from Outlook to ChatGPT for analysis. I’m struggling to make the right connection between Outlook and ChatGPT. The Outlook email is delivered with two attachments: a PDF and a JPEG. I can’t seem to locate the JPEG attachment content in the Outlook modules to send it to ChatGPT. Here is the automation I’ve been working with, but it’s broken and doesn’t seem to work. I have another automation that passes through the PDF.com, but the information gets scrambled, and ChatGPT cannot use it correctly. Any thoughts on an alternative way to do this would be great! Big thanks in advance.
You might need to use the Text Aggregator instead of an Array Aggregator.
By selecting a sub-property in the array, you are basically referencing the FIRST item in the array.
Also, in your Iterator module, you selected the “Source Module” incorrectly. It should be aggregating all the attachments, hence you should point it to the “List Attachments” module, and NOT the Download an attachment module.
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 has applies to many use-cases.
I recommend going through the Make Academy to find out more.
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 —
