Help

Integromat - Saving Gmail attachment to Airtable

7111 17
cancel
Showing results for 
Search instead for 
Did you mean: 
Keith_Cheung
4 - Data Explorer
4 - Data Explorer

Hi! looking for help using Integromat - i’ve been trying to use Gmail Watch function and extract the attachment to Airtable but couldn’t get it working.
What should I choose ? just click “choose” and select the attachment doesn’t seem to work. If I click Map and then add item, what should I select in the file URL? I selecting the attachment but it doesn’t work either.

screen-shot-2018-02-20-at-115024-pm
Thank you for any advice!

17 Replies 17
Bryan_Smith
6 - Interface Innovator
6 - Interface Innovator

Hi Keith, did you ever get this working. I’m trying to get the same from Google Drive but haven’t got the correct data or result in my attachment field.

M_k
11 - Venus
11 - Venus

Hi

You might want to also try Facebook, where there is an Integromat Community. They now have support people that are associated with Integromat, assisting users/members. They have been very helpful to me, a beginner.

MK

Hi

Looking at this, I think it’s because the Gmail app in Integromat is returning the actual file whereas the Airtable attachment field wants a URL of a file to load (which isn’t available). I would be delighted to hear there’s a solution to this - maybe a support request to Integromat is in order…

OK - I contacted Integromat and they suggested saving the file to Dropbox first - and then copying from there to Airtable - but I couldn’t get this to work on my Dropbox account.

However, I tried with Google Drive and have a working solution - here’s the overview of the Scenario:

Screenshot 2018-11-12 at 12.40.06.png

Note that I am also using an Iterate Attachments Gmail app which will allow you to do something with each attachment. Each is then stored in Drive, a record is created in Airtable and then I delete the file from Google Drive.

Hope this helps!

Hey Julian, I know that I’m way late to the conversation, but would you mind showing me what “value” you put in the Airtable dialog for the attachment field? Like this:

a1

I can’t find the right output of the Google Drive (upload file) block to make this work. I know the file is getting saved in Drive and the record gets created in Airtable, but no attachment.

Thanks.

Hi @augmented

To be honest I’m not certain - I don’t have this scenario any more. However in a similar one I am using the Direct download link to pick up the file for Airtable. If this doesn’t work it could have something to do with your Drive settings.

Also it may be worth trying the Get a share link Drive module.

Juiian

augmented
10 - Mercury
10 - Mercury

Thanks Julian, will try your suggestions.

Hey Julian, just thought I should let you know that one of your suggestions was the answer. I needed to make the folder in Drive viewable with link, instead of private to me.

Thanks again!!!

sarah_chamberli
5 - Automation Enthusiast
5 - Automation Enthusiast

Related question: I have an integromat scenario which retrieves a labeled email, creates an AT record, and then interates throught the email attachments to add them to that record. However, if there are multiple attachments, when i use Integromat’s UPDATE AT RECORD action, it REPLACES the current attachment with the new one (each iteration) so in the end I only have the last attachment, not all of them. It seems like AT should ADD to attachments, not replace, since that field allows multiple attachments. any solutions/ideas? Thanks.