I have a joined list with email addresses of several clients.
My intention is to send this list to Make (Webhook), use an Iterator and send to each of the clients an email.
Iterator need an array, and I don’t know how to solve this
You can send over a list of comma-delimited emails, and then use a split function to iterate and send the emails. Something like this.
Then put the “value” in each iterator as the “receiver email” in the email module.
However, you can also consider this approach, which uses only 1 email module “run”, compared to X “runs” with X being the number of emails in your list.
I would recommend using a webhook inside the Google apps script, which includes a split function first and post-split the email being sent to the respective user. If you need help in making a webhook using an apps script, I can help you with that.
This is a great solution Thinh. I’m currently facing a similar issue, I wonder if you could help me:
I need to do the same with two sets of comma-delimited values. They are a list of line items and a list of their corresponding quantities.
How can I deal with them in Make if I’m trying to build an array that contains them both to send to a store, e.g., Shopify?
Where did you get those two comma-delimited sets? I wonder if it’s from Glide, you can make it a JSON object instead to be able to have them in a better format when passed to Make.
Correct, they’re coming from Glide. But you’re right, I should be passing them in a better format. This is what I came up with:
But I’m still wondering if this is the right way. Because I still can’t figure out how to get them parsed in Make. This is what I’ve got so far:
But the error on the Parse JSON module says it’s not a valid JSON object. The thing is Glide does not let me send JSON objects in webhooks.
If you have a suggestion I’d greatly appreciate it!
It’s not a valid JSON object. It should contain square brackets at both ends. Please try adding them with a template column, pass that template column value to Make and see if it works.
You were right, just adding those square brackets solved everything. Thanks a lot, man!
Great to hear! You can try https://jsonlint.com/ next time if Make tells you that your JSON is not valid.
Awesome, will do. Thanks again!