Gummie send me this - https://www.gumloop.com/pipeline?workbook_id=cPMCRVw64dVQqE6hLNXrS1&run_id=fnH3fQn4AK7VvXdpW992Gp
I have a google sheet with several collumns. I want the scoring node to score on two collumns. Not every row (in these collums) has something to score so I put a error shield arround the two scoring nodes. But I get still an error. See also the screenshot
Tried to include 2 filter nodes but stil this error - https://www.gumloop.com/pipeline?workbook_id=cPMCRVw64dVQqE6hLNXrS1&run_id=F3cXuPL8fY5HtxfBxM22a8
@Donna - I’ve requested access to view the flow. You can also enable ‘anyone with the link can view’ under the share button.
Just did that. Gave acces
Thank you! In loop mode all the inputs going in a node should have the same list length, otherwise the node will not know how to pair them up and will fail with the List size mismatch error.
In your case, one of the inputs in the Filter node is coming from the Scorer node which is wrapped in an Error Shield meaning it can have a smaller list size if certain inputs fail while the other input is connected directly from the Google Sheet.
I’d recommend making a subflow and then wrapping the entire subflow in an Error Shield. That way if anything fails the entire process within the subflow will be skipped.
Here’s an example setup: https://www.gumloop.com/pipeline?workbook_id=jA75XK3HTzBB7QKHyfwijQ
Let me know if this makes sense and works for you.m
Hey, you have been helping me enourmusly the last couple of weeks, and I’m making much progress. (Gumloop is cool … ) … But this solution is next level … 
Awesome, glad to hear that!
no … not yet … Just ran it : Filter Failed!
Node ‘Filter’ running in List Mode has an input ‘input1’ which is a list of 290 items. This is not matching the size of another one of the inputs, which has 368 items.
Please make sure all lists that go into this node are the same size.
Could we give the empty cells a (“manual”) score of zero with an If … Else maybe?
Can you share the run link?
Done. (do these “link shares” expire?)
Ah it seems like you’re still running the same old flow not the one with the subflow. Try this: https://www.gumloop.com/pipeline?workbook_id=krEgdXMdjMYF8vTzCQxk2N
No but the run link (run_id) changes everytime you run the flow.
You did it … Still … “next level” … Be well
Would this have worked?
Yes but the IF-ELSE node does not natively work with list inputs. You’ll have to pass the data from the Google Sheet onto a combine text node and then wrap that in an IF-ELSE node. Kind of confusing so if you get stuck feel free to share the run link here.
This topic was solved and automatically closed 3 days after the last reply. New replies are no longer allowed.
