GB | createList Tool⚙️

Workflow Overview This workflow automates the daily creation of service route lists for a pool maintenance company. It intelligently assigns customers to employees based on predefined groups or, if no groups are specified, distributes the workload evenly. The final, organized daily lists are then created or updated in an Airtable base. Automation Value This workflow provides significant operational value by automating a complex and time-consuming daily scheduling task. Instead of a manager manually figuring out which customers to visit today, who is available, and how to divide the work, this system does it automatically. It introduces two sophisticated assignment methods: 1. Group-Based Assignment: For specialized routes or teams, it ensures the right employee is assigned to the right set of customers by matching their assigned "Group". 2. Even Distribution: As a default, it ensures fairness and balanced workloads by algorithmically dividing the day's customers evenly among all available employees. This eliminates manual errors, saves significant administrative time, ensures workload fairness, and provides a consistent, reliable daily service list in Airtable that employees can access. Technologies Used - Airtable: Acts as the central database for customer information, employee details, and the final daily route lists. - n8n: The automation platform that coordinates the entire process, from data fetching and logical branching to custom data transformation and final list creation. Node-by-Node Analysis H3: When Executed by Another Workflow - Purpose: This is the entry point. It's designed as a sub-workflow, meaning it's triggered by a parent workflow (e.g., one that runs on a daily schedule). This modular design allows it to be a reusable "tool" within a larger operational system. H3: Get Pools🌊 & Get Experts (Airtable) - Purpose: These two nodes run in parallel to fetch the necessary data from Airtable. - Get Pools🌊: Connects to the "Customers" table and retrieves only the records where the Visit Day field matches the current day of the week (e.g., if run on a Monday, it only gets Monday's customers).