Skip to main content
Best answer

Read text from spreadsheet and merge other variables

  • August 15, 2022
  • 4 replies
  • 43 views

Hello,

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
Markus 

Best answer by Troy Tessalone

Hi @markusmazur 

Try using the Formatter > Text > Replace option.

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

Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • August 15, 2022

Hi @markusmazur 

Good question.

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


  • Author
  • New
  • August 15, 2022

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.

 

Regards,

Markus

 

 

 

 


Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • Answer
  • August 15, 2022

Hi @markusmazur 

Try using the Formatter > Text > Replace option.


  • Author
  • New
  • August 15, 2022

Hi @Troy Tessalone,

thanks a lot for your help! That works!