⚙️ GB | createLists tool

Daily Work List Generation & Assignment Workflow Overview This workflow automates the creation of daily work assignments for a field service company, likely specializing in pool maintenance. It retrieves customer and employee data from Airtable, applies sophisticated business logic to assign employees to customers, and then populates a "Daily Lists" table in Airtable with the generated assignments. The automation provides significant value by replacing a manual, time-consuming, and error-prone scheduling process. It ensures that customer assignments are distributed fairly among employees and, more importantly, that customers are matched with employees who have the appropriate skill level for the required service. Technologies Used - n8n: The automation platform coordinating the entire process. - Airtable: Acts as the central database (CRM) for storing customer information, employee details, and the final daily work lists. - JavaScript (Code Node): Used to implement the core business logic for assigning tasks, which includes conditional routing and round-robin distribution based on skill levels. --- Node-by-Node Analysis H3: When Executed by Another Workflow This is the trigger node. The workflow does not run on its own schedule but is instead designed as a modular tool that is called by another, likely time-based, workflow. This allows it to be integrated into a larger daily operations process. H3: Get Pools1 (Airtable) This node queries the "Customers" table in Airtable. It uses a formula ({Visit Day} = DATETIME_FORMAT(now(), 'dddd')) to fetch only the customers scheduled for a visit on the current day of the week. This is the first step in determining "what work needs to be done today." H3: Get Employees1 (Airtable) Running in parallel with the customer query, this node fetches the full list of employees from the "Employees" table in Airtable. It retrieves crucial data like Employee Name and Knowledge Level, which is used later for skill-based assignments. H3: Merge2 & Aggregate These two nodes work together to prepare the data for processing.