How to make a Google Sheet row divide in different conditions?

[SleepyDolly]

Describe the problem/error/question

Hey there!

I’m a little confused on how to get a specific row (In this case, a “state or city” row) from Google Sheets to divide into different conditions (Fort Myers, Orlando, Miami, Colorado) for my IF node. I want to send the information to different processes, so I need to separate them by state.

When row is updated —> Check IF Google Sheets contains Miami, Fort Myers, Orlando, or Colorado

What is the error message (if any)?

N/A

Please share your workflow

Share the output returned by the last node

1. This is how the information shows once I tried testing a specific row that contained 1 state (IF NODE):
   
   
2. BUT if I run all the information inside the Google sheet, it can identify correctly which rows go in the conditions based on the state (IF NODE):
   
   

Information on your n8n setup

• n8n version: version [email protected]
• Database (default: SQLite): default
• n8n EXECUTIONS_PROCESS setting (default: own, main): default
• Running n8n via (Docker, npm, n8n cloud, desktop app): n8n cloud
• Operating system: Window

[barn4k]

hello @SleepyDolly

Instead of using bunch of IF nodes, use one Switch Node

[SleepyDolly]

Thank you!