How to Send Multiple Files from Google Drive via Email: A Guide for Make.com Users

Have you ever found yourself in a situation where you need to send multiple files from your Google Drive to someone via email? And not just once, but on a regular basis, like every month? If so, you're not alone. Many of us have been there, and it can be quite a hassle. But don't worry, there's a solution to this problem.

The Problem

Let's say you have a Google Drive with different folders for different clients. Each client's folder contains multiple files. Every month, you need to look into each client's folder, download the files, and send them through an email as attachments. Sounds tedious, right?

One might think that using the aggregate module to store the names and data of the files and insert them into email attachments would solve the problem. However, the aggregate module gives multiple outputs, making it impossible to have one output with the name and data of every file in the folder.

The Solution

The solution to this problem is quite simple. Instead of choosing the 'Download file module' as the source module for the array aggregator, change the source module to 'Search for file/folders'. This will create one array with all the files.

But the job is not done yet. You still need to download the files and map them to the email module. And here's how you do it:

  1. Map the array directly to the attachment.
  2. Make sure you have selected the Target structure type of aggregator as Gmail attachment.

Troubleshooting Tips

If you're having trouble mapping the email attachments with the array, remember that it won't work if you map the whole array. You need to map each file individually.

Conclusion

And there you have it! A simple and effective way to send multiple files from your Google Drive to someone via email on a regular basis. No more manual downloading and attaching files one by one. With this method, you can automate the process and save a lot of time and effort.

You do have further questions?

Ask your question via E-Mail: Richard@make-app.de
Book a paid Support & Consulting Session
New Make.com user? Sign up through this Affiliate Link to receive 10.000 operations for FREE.