Hi @Naveh,
You need to pass an array of collections in Google Calendar, including email(mandatory) and name(optional). What you are passing is a primitive array which looks something like this, ["johndoe@example.org", "janedoe@example.org"]
, instead of required,
[{
"name": "",
"email": "johndoe@example.org"
}, {
"name": "",
"email": "janedoe@example.org"
}]
Since, Email address if you are setting up Attendees is mandatory, it is throwing an error thus causing the OK button not to work. So, To resolve this, what you need to do is create an array of collections as specified in the format mentioned above or the easier way to do this will be to use iterator and aggregator.
- After your GSheet, Add a New Module Iterator
- Iterate over split(email;,)
- Add an array aggregator, and over there set the destination data structure to Attendees and source to Iterator.
Something like this,