What is your goal?
I want the Google Sheets Search Rows filter to correctly extract one clean value from a callback_data string using get(split()), so the module can find the matching row and the rest of the scenario (Update Row, send Telegram reply) can run.
What is the problem & what have you tried?
Hello,
Following up on a previous issue (already solved) with parsing Telegram callback_data. Now I’m stuck on a new problem in the same scenario.
Scenario: Telegram Bot (Watch Updates) → Filter (data exists) → Router → [branch “correct”] → Google Sheets (Search Rows) → Google Sheets (Update a Row) → Telegram Bot (Send a Text Message).
What works: The Router filter correctly extracts a single value using this formula, which is confirmed working (green checkmark, correct output):
get(split(2.callback_query.data; “|”); 1)
What doesn’t work: In the next module, Google Sheets → Search Rows, I need to filter column B by the second value from the same callback_data string (the word itself). I copied the exact same working formula from the Router filter and only changed the last index from 1 to 2:
get(split(2.callback_query.data; “|”); 2)
However, when I check the module’s actual input data, the filter value shows as “correct, Das Auto2” — two comma-separated values instead of one clean word. It looks like only the inner split() part is being evaluated (returning the full array as text), while get() is not correctly wrapping it, even though the formula field itself displays correctly with proper colored tokens.
As a result, Search Rows returns 0 bundles, and the entire rest of the scenario (Update a Row, Send a Text Message) never executes — no reply is sent to the user in Telegram.
I’ve tried: retyping the formula manually, copy-pasting from the working Router filter, rebuilding split/get through the function picker one click at a time — same result each time.
Could someone explain why get() isn’t wrapping split() correctly in this specific field type (Search Rows filter value), even though the exact same formula works fine in a Router filter condition? Is there a different syntax needed for filter fields inside Search Rows specifically?
Screenshots attached: the filter field with the formula, and the module’s raw input/output showing the “correct, Das Auto2” issue.
Thank you.
Screenshots (scenario flow, module settings, errors)