0
votes

I am trying to publish chats data in web apps, Code reference used from "https://mogsdad.wordpress.com/2015/07/19/converting-from-uiapp-chart-service-to-html-service-google-visualization-api/" I am not getting any error in code but not able to view the data in webapp error snap updated below, help me to fix the issue

Please refer the complete script in below link Script Sheet Sample Sheet

Error

1

1 Answers

1
votes

I've also experienced this and it may be because the Sheet file is set to private.

Steps I've done to fix this:

enter image description here

Result:

enter image description here

NOTE:

The Google script needs to be published as a Web App and the access should be set to anyone (including anonymous) or you can also limit it to users of your own Google Apps Domain.