Route Form Submissions by Company Type

Why this solution works:

You have multiple leads that need to go to different destinations based on their company_type value. Instead of building separate workflows or using complex IF/ELSE chains, the Switch node lets you define all routing rules in one place and creates multiple output paths.

How it solves the problem:

1. HTTP Request fetches all the leads at once. The API returns an array of submissions wrapped in a data field. Each submission has fields like name, email, company, and company_type.
2. Edit Fields extracts the array. The response comes as { "data": [...] }, so we use Edit Fields to pull out just the data array for processing.
3. Split Out turns the array into individual items. This is critical: without Split Out, the Switch node would only run once for the entire array. With Split Out, each lead becomes a separate item that flows through the workflow independently. This means 5 leads = 5 separate executions through the Switch node.
4. Switch node routes each lead to the right destination. The Switch evaluates $json.company_type against four conditions:
   • If it equals ideal_customer, the lead goes out Output 1 (to Slack)
   • If it equals high_value, the lead goes out Output 2 (to High Value Leads sheet)
   • If it equals low_value, the lead goes out Output 3 (to Nurture List sheet)
   • If it equals none, the lead goes out Output 4 (which has no connection, so nothing happens)
5. Each destination node only receives matching leads. The Slack node only sees ideal customers. The Google Sheets nodes only see their respective lead types. This happens automatically because the Switch physically separates the data flow.

Why Switch instead of multiple IF nodes: A Switch node is cleaner when you have more than two outcomes. With IF nodes, you would need to chain them together (IF ideal_customer, ELSE IF high_value, ELSE IF...), which gets messy. The Switch shows all your routing rules in one place and creates parallel paths that are easier to visualize and maintain.