Help

Integromat - Saving Gmail attachment to Airtable

9377 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

Hey Sarah, can you please share a screenshot of your scenario? Also, I would encourage you to post your Integromat related queries on the Integromat community to get faster help. Here’s the link: intm.at/community

I ran into the same problem with such a use case

I cant figure out how to create one record per email and add multiple email attachments in one attachment field in Airtable

screen
This setup just iterates through each attachment overwriting the previous so you end up with only the last attachment in the field
screen2
If I add an array aggregator then I still can input only individual file URL and ID which gets the same result
screen3
Maybe mapping could solve it but I have no idea how to.

Hey! So this one is a bit complicated but once you see the solution, you will realize it makes sense.

In your Array Aggregator set up, you need to select the Gmail > Iterate Attachments module as the source module. Why? Because this is the module that is iterating the attachments array from Gmail to generate multiple bundles of data. When you select the GDrive module as the source, the Array Aggregator takes 1 bundle and aggregates it, instead of taking all the bundles generated by the Iterate module.

Next, under Target Structure type, you will see an option Record: Attachments AFTER you connect the Airtable module to the right of the Array Aggregator. This is because now Inetgromat can automatically generate the data structure of the array that is accepted by the Airtable module.

Lastly, you just need to map the elements (Name and Web Content Link) from GDrive to create the requisite array. See the screenshot below:

image

Pro tip: You can use text functions to modify the file name directly in the Array Aggregator module as shown below:

image

Happy Automating! :slightly_smiling_face:

Great - thanks! This got the necessary result. Still learning how iterating and aggregating arrays works so this was a good lesson!

You’re welcome! And you can learn all about Iterator and Array Aggregators in 12 minutes, check out this free course!

Cheers!

Hi @Arpit thanks for this response to @Krisjanis_Dzalbe questions about getting multiple gmail attachments into an Airtable record.

I think i now have this working, but the Airtable record winds up with its attachments field populated with a link to my GDrive - I want the file natively in Airtable so my other Airtable users dont need permissions on my GDrive, and also so I can use the file image thumbnail that Airtable generates.

Do you know how I can achieve native Airtable file attachments in a single Aitable record, populated from multiple Gmail attachments?

Thanks!

Thank you so much for noting this…I’ve been working on this problem for TWO DAYS!!! Found your suggestion to change the drive folder permissions to viewable with link - that fixed it!

Chartie
4 - Data Explorer
4 - Data Explorer

Hey, did the scenario and named it for ease of use, thought that could help others on this.
Thank you for your help!

Screenshot 2024-06-26 at 15.32.35.png