Webhook receive and process multiple files

Question:
Does anyone know how to set up a Make.com scenario so that when a webhook receives 1–6 evidence files, it:

  1. Uploads each file to Google Drive, and
  2. Adds one single row to Google Sheets with all file URLs concatenated in the same “Evidence” cell (instead of creating a new row per file)?

Any ideas on how to configure the modules/aggregator to achieve this?

Welcome to the Make community!

Yes, that is possible. You’ll need a minimum of five modules:

This is just an example. Your final solution may or may not look like this depending on your requirements.

What do you do when you have an array?

“Looping” Through Array Items

When you SEE an array in your module’s output, think of using an Iterator module.

In this example, responses is an array of items (collections). You’ll want to map this array in an Iterator module.


Question: Have you tried mapping your array variable into an Iterator module, ran the scenario, and view the output?

Next,

Combining Bundles Using Aggregators

Every result (item/record) from trigger/iterator/list/search/match modules will output a bundle. This can result in multiple bundles, which then trigger multiple operations in future modules (one operation per bundle). To “combine” multiple bundles into a single variable, you’ll need to use an aggregator of some sort.

Aggregators are modules that accumulate multiple bundles into one single bundle. An example of a commonly-used aggregator module is the Array aggregator module. The next popular aggregator is the Text Aggregator which is very flexible and can apply to many use-cases like building of JSON, CSV, HTML.

You can find out more about the other types of aggregator modules here:

Question: Which is the best aggregator do you think you’ll need for your use-case?

Hope this helps! Let me know if there are any further questions or issues. P.S.: investing some effort into the tutorials in the Make Academy will save you lots of time and frustration using Make!

@samliew