Gviz Private Gsheet

Discuss
43

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’

1 Like