Creating gmail draft with attachment extracted from Google Drive and recipients defined in Monday.com

Hi,

Here’s scenario:

End product: I want to create a draft with recipients retrieved from certain Monday column and file from google drive (link to it is on Monday column) as an attachment.

1st problem: Under certain item in monday I have several addresses in format “address1@gmail.com ; address2@gmail.com”. How to place a couple of people in “to” section?

Potential problem: With one recipient it seems all is good, there is no error in workflow, recipient is defined, but when I check it on gmail and click into the message it’s damaged (can’t click into it)


It seems there is attachment, but when I click into message I can’t find it:

Recipient is not defined:

Maybe you should use the split function to handle and separate the email addresses. As for the attachment in the email, it was not possible to understand the problem very well. What type of file is it? What is its size?


Thanks, Helio!
Wemakefuture
If you have questions reach out :wink:

1 Like

PDF, it’s single page so no more than 100KB

But under the area “Email address 1” I can’t insert 2 addresses’ emails even if I use the split function, can I? Thus, should I use array aggregator? How should this look like?

I got it. Really yo cannot send the email for mutiple recipients. Sorry.


Thanks, Helio!
Wemakefuture
If you have questions reach out :wink:

@hubehe

Try using the split() function AND setting the map flag on the address parameter.

Jim - The Monday Man
Get Custom Apps, Integrations & Automations for monday

1 Like