What is your goal?
I’m building an automation that creates meeting summaries from transcripts stored in Google Docs. Later, I want to send those summaries to the meeting participants retrieved from Google Calendar.
What is the problem & what have you tried?
My main problem is that I’m not getting all the participants’ email addresses. In the Google Calendar module output, the Attendees array contains two email addresses, and I can see both of them in the bundle. However, when I try to use this data later in the scenario (or even save it to Google Sheets for testing), only one email address appears.
Someone suggested that I need to use an Iterator to process each attendee separately. I tried that, but it didn’t solve the issue, so I may be doing something wrong. I’m a total beginner, so I don’t understand it fully yet.
Also, does this overall approach sound reasonable or would it be easier to build this automation with Fireflies, despite its limitations?
Screenshots (scenario flow, module settings, errors)
Hi Nat,
Make.com doesn’t automatically iterate an array for you. Would love to see what formula or mappings you made inside your iterator. If you would need to put 2 emails into one cell you can use an aggregator instead and use Google calendar as your source module. You can use target structure type; Google sheets → add a row → email.
Formula: {{5.Attendees[].email}} the array will go through an internal loop and produce something like : [“email1@gmail.com”, “email2@gmail.com”] then you can use a set variable = my_emails
Value: {{join(6.array; ", ")}}
But if you want to place the emails 1 per row for personalization then you’ll sure need an iterator but you should consider placing your sheet right after the iterator. Google Calendar → Iterator Array: {{5.Attendees}} → Sheets Email = {{6.email}}
Give it a shot. I recommend option 2 as it’s cleaner.
Hi Daraima Bassey N,
Thank you for responding and for your willingness to help. The iterator you see in the screenshot I sent you iterates only the text content from the Google Docs, and unfortunately, in this doc, there is no info about the attendees’ email addresses, which is why I’m trying to add it through Google Calendar. I added the array aggregator after Google Calendar and it maps the email addresses correctly now, but I’m stuck on what to do next. I added a tool - “set a variable” after the aggregator, but its output is {object} instead of the addresses separated with a comma. Do you have any ideas how to fix it?
Hello again,
Thank you for your help so far! The issue still appears and I have been wondering if any additional function would be needed here since it’s a nested array. Also, I tried to type it exactly like you did, but maybe I missed something. As you can see on the screenshots, even the variable value in the input is empty, so it’s like it didn’t read it correctly from the start. I have been trying many different combinations, but so far nothing seems to work :') Now I have been wondering whether I should give Fireflies a shot even though it’s paid, but I really wish there could be a solution to this problem.
Hey there,
You need two map functions on top of eachother to pull data from the nested array. First map the array to get the attendees subarray, then map that to get the emails.
