Hi. Apparently “=” in the beggining switch value of the N8N node from static to expression. But how to still keep this “=” in the beggining of the value expression as long as it needs to be GSheet formula that start from it? When I run with open node settings it works. But once I close node settings = disappears form value expression.
=UPPER(RIGHT(LEFT(IMPORTXML(“https://www.linkedin.con/in/burykin","(//a)[14]/@href - Google Suche”),17),2))
It looks like your topic is missing some important information. Could you provide the following if applicable.
Hey @Dan_Burykin , it might disappear from the UI but still seems to be working for me in the actual data. I believe that = is used internally and is served as a marker that triggers expression invocation.
Moreover, when chaining to the next node the value retains = even in expression.
Regardless, why would you use GSheet formula as a value in n8n? The formulas should be applied in the sheet itself and not set dynamically by n8n.
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.
