Gviz Private Gsheet

[sugarlesscreator]

Try this script Gvizscript.txt (577 Bytes)

I have success with my test project.
Ex : https://script.google.com/macros/s/AKfycbwAH0Yb2kV_C9sL3KaGqqpx9p5LnvD4NSybOEPyMQ/exec?sheet= Sheet name &query= query

https://script.google.com/macros/s/AKfycbwAH0Yb2kV_C9sL3KaGqqpx9p5LnvD4NSybOEPyMQ/exec?sheet=Sheet1&query=SELECT A,B,C

Click query SELECT A,B,C

Click query SELECT B WHERE A = 3

Click query SELECT C WHERE B = ‘Red’

[King1 (King.sage)]

It was the missing piece for my puzzle!

In this case, we do not edit the Manifest. What is the real function of that? Could you describe it?

[sugarlesscreator]

Use double qoute sign (") to id in script

var id = “blablablablablab”;

[King1 (King.sage)]

Thank you for your help. I can now proceed on my app.

Thanks!

[sugarlesscreator]

No, big thanks to @TimAi2 for tutorial

@King1

METRIC RAT AI2 - Use gviz to get or query PRIVATE google sheet data

[King1 (King.sage)]

You are right.
Thanks @TimAi2 and @Still-learning , for taking the time to help me.

[Still-learning (1-2-3-4...)]

ha ha this is what we advised for him along with script code and manifest code