LinkedIn
Twitter
Say, I want a part of JSON template to be included or excluded based on a condition and that part is a JSON object and not a simple string. Example:
<<IF(TRUE, '{"type": "text\ntext"}', '')>>
Currently, that would return a string with escaped text like
{\"type\": \"text\\ntext\"}
Note that above JSON is hand typing. So it might not have a valid format. Itโs just to give you an idea.
And current workaround is create multiple workflows with different JSON template files but it is only good for templates with one or two condition checks.
One suggestion is to include a JSON type in AppSheetโs column type list. Anything printed from the JSON type will not be escaped (or stringify). 
Thanks.
Solved
1 ACCEPTED SOLUTION
Unless I am completely misunderstanding your initial post, in your JSON body you can do things like:
{some JSON code}
<<If: (some condition in your table data)>>
{only sometimes JSON code}
<<EndIf>>
<<If: (a different condition in your table data)>>
{only sometimes JSON code}
<<EndIf>>
{more JSON code}
You donโt have to use the IF() from within AppSheet. You could even have multiple different JSON templates inside one file depending on a certain value from your data.
My personal example (JSON sent to Discord):
