Add outlook email with attachments to airtable

Hi, newbie here. Looked all over and couldn’t quite figure this out. Not sure if I need all of these modules or not. I’m basically having it watch a folder in outlook and then send that email into airtable. Works perfect until i get to the attachment. I’ve successfully setup Google drive and the attachment does show up there, however the PDF can’t be read from there for some reason. From there I can’t get it into Airtable.

Hello! Welcome to the Make Community!

According to what I see, you don’t need the Array Aggregator, because it’s here to group multiple bundles into an array (besides, the source module would then be “List Attachments”). You don’t need to group attachments into one single documents, so, you can remove the Array Aggregator.

Then, very often, what happens with Google Drive is that it expects a specific format for the Data. I never used Outlook, so I don’t know what format is used for the data of the attachment. But you could have a look at the toBinary, base64, toString functions and see if one can transform the format to one Google Drive accepts.

For Airtable, can you please show the error message as well as how you mapped the fields?

Benjamin

thanks, i went ahead and removed the aggregator. Here is the error i’m receiving from airtable.
image

Can you show the configuration of your Airtable module?

oh sure thing


Oh that’s interesting; apparently, your table expects an Array for attachments. So, you were almost done :slightly_smiling_face:

Put your array aggregator after Google Drive (because you still want to process each attachment individually.
Then in Source Module, select “List Attachements”
In target structure, you should find the “attachments” from Airtable, select it. You should be able to map the requires fields.
Then open your Airtable module again, remove what you put in Attachments, and map the array from the Array Aggregator instead.

Let me know the outcome.

benjamin

So no error that time, but also no attachment. What do I need to put in the aggregator for File URL ?

Ah… apparently, Airtable wants the url of the images and not the images themselves…
It means that it’s more complex, since you need to upload them first in a SaaS like Google Drive, Box, Dropbox, etc, and then get a shared url that you map in the field « url »…

Benjamin