Gemini outputs those pesky ```json ``` markdown formatting, so you CANNOT directly use the Transform to JSON module.
First, you will have to use the built-in function replace —
{{ replace(text; search_string; replacement_string) }}
For more information, do view these similar questions previously asked by other community members, which may answer your question:
- Strip the code block markdown - #3 by samliew
- Need to remove the "bad characters" from the start of a JSON output from GPT - #2 by samliew
Hope this helps! Let me know if there are any further questions or issues.
— @samliew