Filtering (Router) Google Sheets values

[organic_stax]

Hello guys!

I’m trying to create some conditionals based on values in Google Sheets, but I’m having some issues.

For example, in a Sheet with the following two columns:

Team member Name | Role

…and let’s say each column has many different cells with different string values.

Let’s say I’d like to filter specific team members based on their role and then fill in a new Sheet with the filtered values.

Any help?

Thank you!

[organic_stax]

Another thing, is that I choose the Column I want to find a row, but it returns all rows as the output. Maybe I do something wrong?

[kishanprmr]

@organic_stax Welcome to the community ,

@organic_stax

Another thing, is that I choose the Column I want to find a row, but it returns all rows as the output. Maybe I do something wrong?

Can you try the Find Rows action for that particular column?

[organic_stax]

Happy to be here

Well, I figured it out. All good. The only thing, is that I’m having troubles getting all the values from the Sheet one by one by filtering. For example if I have 3 columns with:

Team member name | Role | Tasks

And I want to get the names of the team members that have less than 5 tasks. I am having troubles doing this with the Router piece. Maybe I do something wrong…

[kishanprmr]

Can you share the router step setup? How did you create the conditions?

[organic_stax]

Hello again and thanks for helping me with this

Yes, of course, here’s my workflow:

The value in the 3. Loop on items piece is “2. Get next row(s)”

I also used these setting in the nested Router section:

Branch

Insert Row

This is just a test/practice flow, I ran it and it seemed it worked, it written in the Sheet only the team members with more than 15 tasks. But, after than successful run, I’ve ran it again 3-4 times and for some reason, it seems it doesn’t work.

Thanks!

[kishanprmr]

@organic_stax

I’ve ran it again 3-4 times and for some reason, it seems it doesn’t work.

For these runs, can you check the run details and tell me the value of column C and the result of the branch condition?

[organic_stax]

Ran it again now. It worked! But I ran it again and it didn’t.

Here are my Run Details on the successful run:

And here are my Run Details on the run that did not worked:

The value of column C from the Sheet I try to filter the values and pass them to the other Sheet, is 10

And here’s the branch and the results:

Thank you so much for helping me with this, as passing Data from Sheets is one of my key use cases with automations

[kishanprmr]

@organic_stax

So for this run, which didn’t work, I can see that there is no router step. That means the ‘Get next row(s)’ step returned an empty result. Can you check the output of step 2 in this run and see what the result is?

[organic_stax]

It says the output is 0 items, which is weird, cause I’ve connected the Sheet and the first time the flow worked great.

When I test that step/piece, it returns zero results too after the first run.

Could this be an issue with the memory key?

[kishanprmr]

If the flow has fetched all the rows, it will return empty items. Check out Google sheet : How to reset the "Memory Key" parameter of the "Get Next Row" module at the end of a flow? for instructions on resetting the memory key to fetch rows from the start.

[organic_stax]

Thank you so much! This helps a lot!