Unexpected filter results from checkbox in Google Sheets

[Rebecca_Katz]

I am running a scenario that starts with data in a Google Sheet. One of the columns in the Google Sheet is a checkbox. The output correctly displays as TRUE or FALSE as seen in this screenshot:

The scenario then has a router, with filters directing the action to take: one route where Opt-out is true, and one route where it is false:

HOWEVER regardless of whether the checkbox is checked or not, it is passing through the opt-out = true filter.

As per usual when I am coming to this community for help, I would not be surprised to find that the error is something incredibly easy to fix, but I need help identifying what that error is.

Thanks!

[Probotic_Solutions]

Hi @Rebecca_Katz,

1. Set the fallback route to “No” after the Router to ensure this filter is only used when conditions match exactly, and not as a backup/default route.
2. Add a filter condition using a text operator set to “Equal to (case insensitive)” and compare the value with either "TRUE" or "FALSE" to properly handle boolean like text inputs.

Let me know if you need further clarification!
If this helps, kindly mark it as a solution

[Rebecca_Katz]

Changing the filter to a text condition instead of boolean solved the problem. Thanks!