How to iterate Outlook365 email attachments towards ChatGPT

How To
,
1

Hello everyone,

I was wondering how to realize the following use case:
When receving a specific email in our outlook365 mailbox, we want to iterate each attachment, send it to ChatGPT to check for two specific contents: a SKU and a date and then (for now) write both information in a google sheet.

I cannot find the “iterate attachment” option in the outlook365 module, only in the gmail module and in the email-module. I found an independent modul called “iterator” but I am totally unsure what to do with it, because filenames and message ids can vary all the time.

Thank you in advance,
Tom

3

Hey Tom,

you map the attachments array in the iterator module.

4

I now tried with the “Email” module as follows:

image
image3559×1237 253 KB

Step 1:

image
image1049×1643 95.2 KB

Step 2:

image
image1470×678 81.1 KB

Step 3:

image
image1537×1315 260 KB

Step 4:

image
image1054×1593 109 KB

But the result will be, that in Google Sheet it will only say: “It seems I don’t have access to the file you mentioned. Could you please upload the file you want me to analyze?”

How to access the file in the “message chatgpt” properly?

5

I believe you need to add the files to that Assistant’s personal Vector Store to access them.

6

Found a similiar approach in a youtube tutorial, thank you. Now I need to find out how to store the result in variables and using a separator to cut a string into several variables