Send Emails with email list in excel file and attachments in google drive

[MotazHakim]

Another easy approche

In Excel file, i’ve added a Folder ID (Will make this folders permanent)

only the Pdfs inside each folder is changable

---

So, the idea is as this workflow:

Results

---

So to explain it

will open the spreadsheat, split it, Google Drive List based on the Folder ID on the split node
download the folder with the folder ID, send email to email in the split node, use the name and country in the subject and body

This workflow is working perfectly and exactly as i want, and i’ve used this function to merge multiple binaries as attachments

Merge multiple binaries with distinct names into one result to send multiple attachment

Hello @mediana, welcome to the community. Sorry, I do not understand exactly what you mean so I hope this example is helpful. I used now for simplicity reason HTTP Request nodes. All I did is to write each of the files to different binary properties and then set them it to the Send EMail node. If it is not helpful please supply a simple example workflow. I can then use that as a base and make it work. Thanks!

Thanks alot for your help