Replace fields values templates from Google Sheets

Questions
#1

Hi,

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?

Screenshot_20220128-221825_Sheets

Thanks!

#2

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

#3

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

#4

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 = “link.com” then A1 would be “here is link link.com”)

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.