Master Aggregating Multiple Operations on Make.com

Have you ever found yourself stuck trying to aggregate multiple operations into a single variable separated by a comma? You're not alone. This is a common challenge faced by many Make.com users, especially when dealing with arrays of varying sizes delivered by a webhook and looping a spreadsheet look-up of URLs.

Understanding the Problem

The problem arises when you try to use the text aggregator to loop all these URLs into one variable. Despite going through all the videos, documentation, and community posts on Iterators, Array Aggregators, JSON Parsing, you might still find yourself stumped.

The Solution

The solution to this problem lies in handling the data as an array and structuring your original query to sheets so that it returns bundles, not operations. Here's a step-by-step guide on how to do it:

1. Query your Google sheet for the data you need.
2. Amend the query using the same method but with a different delimiter for each “Or” statement.
3. Ensure that it returns “Bundles”.
4. Use a text Aggregator to make them comma delimited.
5. Feed this comma delimited list of URLs into pdfco to merge all your PDFs.

Troubleshooting Tips

If you're still having trouble, make sure you're correctly querying your Google sheet and that it's returning bundles. Also, check that you're using the text Aggregator correctly to make the results comma delimited.

Conclusion

By following these steps, you should be able to aggregate multiple operations into a single variable separated by a comma. Remember, the key is to handle the data as an array and structure your original query to return bundles, not operations. Happy automating!

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.