Replace fields values templates from Google Sheets


I wanted to replace some value like the link in the “Message” column from the “Link” column. Is there a way to do this in n8n?



Let me make sure that I understand it correctly. You want to “Hello, this is link” be changed to “”, right?

Nope, I need it to replace Link with so that it says “Hello, this is

Maybe what you need is to concatenate google sheet’s function?

By this you can say to cell A1 being "here is link " + A2 (so if A2 = “” then A1 would be “here is link”)

If not please let me know if you will be changing A1 cell only once, or you need to check if was already link added or not and maybe after added link you can change link.