Google Calendar -> Notion

[Marcelo_Rossi]

What is your goal?

Spent hours and hours, couldn’t make this work.

I have this flow:

1. Google Calendar New Event

2. Notion Seach objects (which will get the Project name, this works fine)

3. Text Parser “Pattern: Staff:\s*(.+)” Global No (and others No) Text: “1. Description” (to extract staff names which are inside booking description, “Staff: Name 1, Name 2”)

4. Text Parser “Pattern: [^,]+” Global YES (and others No) Text: "7. $1 (to separate them with “,” )

5. Iterator: “Array 12. Fallback Match”

6. Notion: Search Objects - Matching the staff names

7. Array Aggregator: Which “Should” add them up, (Source module, Notion Search Objects 6) Target: Custom, Aggregated fields: Page ID (notion 6), Group EMPTY (tried all variations here)

8. Notion create data.

Any help?

For context, I have a staff database, with their dayrates, etc.. etc..
The event should add them into the relation property of the task. “Staff”.

Ideia is to book something on google (which staff have access) this booking will create a task on Notion which will be on Related Project, and multiple staff there… this will save me time double entry all those info

What is the problem?

Whats happening… Its creating ONE event per number of staff. If I add 2 member of staff, it will create 2x notion entries, instead of 1 with the 2x members of staff…
Creating booking with 3x member of staff, will create 3x Notion events, one for each member

What have you tried so far?

Tried everything, ai’s like claude and grok was sending me into endless loops

Screenshots: scenario setup, module configuration, errors

[tuliosousapro]

@Marcelo_Rossi

• Pattern: Staff:\s*(.+)" Global No (and others No) Text: “1. Description” (to extract staff names which are inside booking description, “Staff: Name 1, Name 2”)
• Text Parser “Pattern: [^,]+” Global YES (and others No) Text: "7. $1 (to separate them with “,” )
• Iterator: “Array 12. Fallback Match”
• Notion: Search Objects - Matching the staff names

send a print of the last module, so we can see what you’re trying to send and give you proper help.

[Marcelo_Rossi]

@Marcelo_Rossi

Whats happening… Its creating ONE event per number of staff. If I add 2 member of staff, it will create 2x notion entries, instead of 1 with the 2x members of staff…
Creating booking with 3x member of staff, will create 3x Notion events, one for each member

Hi Tulio.

Thanks man. Please see below some screenshots that might help… PS this flow screenshot I had 2x members of staff allocated into the booking, first Notion capture the project (1 operation) which works fine. Then they down the line modules pickup the 2 member of staff…

Any ideas? Thanks buddy

[Marcelo_Rossi]

This is what fixed if helps anyone: