Append values to Sheets with quotation marks in text

[k2trix]

Hey everyone reading this.

I have an issue when i try to append a formula(string) wich contains quotation marks :

When i use """ the json structure is broken, then it doesnt work.
How can i send quotation marks in my text ?

I know we can use {{blank}} {{space}} already, but i cant find a way for "

please help me

 

[Pabblymember11]

Hey @k2trix

Can you please share the workflow URL once you have tried the same so that we can look into it.

Further, can you please try passing the formula in the "Add New Row" action step of Google Sheets once in place of the "Append Values" action step?

 

[k2trix]

Thanks, I found an other way doing this.
I format text values into the sheet directly.
So i dont need to send json data containing quotation marks into their strings.

And i found a way to do it anyway : In any JSON file there's a few tricks.

 

[Pabblymember11]

Thanks for the update, I hope this might help you out.