200 people batching from Google Sheets into Google Calendar

Hi there people, I’m having trouble in make.com iterating through my entire Google Sheets that contain name and email and creating “groups” of 200 people to add to events in Google Calendar. The scenario needs to run until it creates as many events as necessary to include all the people in the spreadsheet. How can I logically “batch” 200 people at a time, create the event, and repeat the process until no one is left — making sure that, for example, if 30 people are left at the end, an event is also created for them?

Here is how it look the output from a regular search rows. the only thing that matters for the google callendar at this point is email.

Welcome to the Make Community!

Possible duplicate of A Better Solution for "How to group bundles in X amount of bundles" (Chunking Arrays)

You can also aggregate the bundles into an array, then use the Chunk Array module, which can be installed here: How to send multiple inline keyboard buttons in a single Telegram Bot message (in multiple rows) with dynamic data? - #5 by samliew

Hope this helps! Let me know if there are any further questions or issues.

@samliew