Automating Data Transfer from source to Destination Table Based on Project Id

[Keshava_p]

1. I have a Source Table (read-only) with dynamic data, including columns for Category (ENUM) and Business Unit (ENUM_LIST).
2. In my Project Table, I create new projects, each associated with a specific Category and Business Unit.
3. I need to transfer data from the Source Table to a Destination Table based on the Project. 

The Project ID column in the Source Table, referencing the Project Table.

The goal is to automatically transfer relevant data from the Source Table to the Destination Table when a new project is created in the Project Table. Since the Source Table can contain a large number of entries for a given Category and Business Unit, I need to perform this data transfer in batches.

My question: What would be the most efficient row filter condition in my bot event to achieve this? Specifically, I need help with configuring the bot to: Trigger when a new project is created in the Project Table. Identify the corresponding records in the Source Table based on the Project ID. Transfer those records to the Destination Table in batches, given the potentially large number of records in the Source Table.

I'm specifically looking for a solution using Appsheet Automation features.