Best answer

Read text from spreadsheet and merge other variables

  • 15 August 2022
  • 4 replies


I would like to implement the following:

- A text is stored in a Google spreadsheet
- I am reading this text
- I want to send this text via Gmail
- But: There are placeholders in the read text that have to be replaced by variables

Is this possible? Except for the variable replacement, everything works.

Does somebody has any idea?

Best regards


Best answer by Troy Tessalone 15 August 2022, 19:58

View original

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

4 replies

Userlevel 7
Badge +14

Hi @markusmazur 

Good question.

Probably best to outline a specific example for us in order to provide full context, thanks.

Hi @Troy Tessalone,


thanks for your reply. Assume the texts you get out of the Google Sheet looks like this:

Text A

{{Salutation}}, thanks for your reply.


Text B

{{Salutation}}, thanks for your answer.


I can pass the read out text to the body section in the Gmail Send Action, but I don‘t know how I can achieve that the variable {{Salutation}} will be exchanged with a variable I read out from another Google Sheet before.


Hope this explains my task a little bit better.








Userlevel 7
Badge +14

Hi @markusmazur 

Try using the Formatter > Text > Replace option.

Hi @Troy Tessalone,

thanks a lot for your help! That works!