Hi –
I’m just learning Make, and would like to automatically create Notion database records for meetings in my Google Calendar. My Notion configuration has a Meetings database and a People database, and the two are related by a one-to-many relationship to capture the meeting attendees.
I’m trying to automate this such that new People records will be created for attendees if I haven’t met with them before, and existing People records will be found and used if I have met with them bfore.
My scenario is below, showing new Meeting records created for each calendar event, and then iterating through each event attendee to search for them in Notion and then take one or two branches via a router that checks to see the search produced any results:
I’m having trouble producing an aggregate array of attendees that contains the ids of a mix of new and existing Notion record that can then be used to update the newly-created Meeting record as the last step. In particular, I can have an Array aggregator that collects the newly created records, but I can’t seem to connect the lower branch to that same Array aggregator to produce a single final array to use to update the Notion record.
Is there a different idiom to use when iterating through a set of values, each of which goes through a “find or create” path, all of which need to be aggregated at the end of the iteration?