How to use google sheet

[Faraz_Firoz]

Part-1

- YouTube

Part-2

- YouTube

GsConnected extension GSConnected extension:- 🟩 [FREE] GS Connected - A Swiss Army Knife for Google Sheets

[TIMAI2]

Would be good to give credit and provide links to the extension developer that makes this all possible

Also, where the responseContent comes back as a stringified JSON you can use the following blocks to make a list, instead of all the text replacement blocks

[gordonlu310]

Can we also use the JsonObjectEncode block from the Web component?

[TIMAI2]

Use the jsonTextDecode block. This is the same as my jsonParse block

[com.prop]

Are you sure jsonParse block works?
I just tried it and it didn't work for me.
Instead, replaceText block works well.

And what does the option "useDefault"affect?

[TIMAI2]

@com.prop

Are you sure jsonParse block works?

@TIMAI2

where the responseContent comes back as a stringified JSON

@com.prop

what does the option "useDefault"affect?

Just set to true, no other setting will work.

[com.prop]

@TIMAI2

where the responseContent comes back as a stringified JSON

[TIMAI2]

Show the value of output, I would expect it to be:

[[Ankou],[Bandit],[Cocatrice]]

[com.prop]

Yes you right. may be i dont understand you correctly when you said

@TIMAI2

you can use the following blocks to make a list, instead of all the text replacement blocks

I'm new to this and trying to make an app without any coding knowledge. Do not be too harsh...)