Open an excel sheet

i have opened your gsheet and deployed from my side, see and test the url HERE

It reutns sheet datas which means i have did it correctly..

No problem with code/app/blocks/

Problem with script url. Dot.

you are not alone :wink:

Read through all the links I have provided with regard to creating a google apps script web app, and how to deploy it, and update the script with a new version. Understand all this and it may then become clear where you problem is.

Two of us have tested your app with our own versions of the script (on our own servers) and your app works with both of them. This points us to a problem with your google apps script

Ensure your last deployed web script url on google apps script, is the same one that you are using in your app.

yes it seems correct to me

Have you given the script permissions? It should ask you if you try to run the doGet(e) from the Script Editor (it won't ask if you have already done so).

I'm sorry, I'm giving up

You could try using the native spreadsheet component, this would require the setting up of a service account on Google Cloud Services.

Or you could try storing your data in a different "cloud", e.g. cloudDB / Firebase.

Hi, I attached the aia file, have you tried it? Maybe the problem is the way the app is made or the block code.

I solved i have change script uri in gsai21

1 Like

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.