Gviz Private Gsheet

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

how edit at the end??? Your url seems to be wrong

at the end it have to be exec

this is my script url without any query

https://script.google.com/macros/s/AKfycbwMQ02w4B9MhidvLrZLdAxKJOYBv3G0Q4867LQsS-YYDzIjTToe/exec

[King1 (King.sage)]

sry, I pasted the edited URL. It’s like that in my APP.

https://script.google.com/macros/s/AKfycbwn19s9EzKd9Fovi7r3TZgCONifasL8uPcCj0mKyK-bd__qZl0/exec

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

result should not appear like this… Did you follow all the methods correctly?
I think you forget to do i think

[King1 (King.sage)]

Yes, I followed all the methods correctly.

I will follow the guide again and see what I can get.

Just remembering: I can add values to the spreadsheet. I’m just not getting the values.

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

Follow the steps. Do not forget, two times you need deploy it. If u miss result wont appear as said by TimAi2

[sugarlesscreator]

Use Response content

Response code 200 is success to get data.

[King1 (King.sage)]

This has been fixed. But it is not yet possible to fetch data.
I am following the steps again.

[King1 (King.sage)]

@Still-learning ,
I feel like I’m committing a crime for getting that result every time.

Summary

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

can you add my mail id as a editor till the problem solve?

[King1 (King.sage)]

Of course, I am very grateful for your attention.

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

check ur pm

[TimAi2 (metricrat)]

You appear to be mixing two things, “the gviz private sheet query”, and “a doGet(e) submit data to a spreadsheet”.

These require different approaches. it may be easier to have a different web app for each, then you do not have to run any if tests in the web app (if query then, else submit) and send additional parameters from the app for this.

You may be OK if you use doGet(e) for the query and doPost(e) for the submit though…

[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