In the automation system, I have a google form which is connected with a google sheet called the Main Sheet where the data is getting updated and saved. I have written a code in apps script using toGet() function. The code is executed successfully and data is shown in the output. After that i deploy the script as web app and get the url for it.
In the vba editor, I use the getRESTRICTEDgooglesheets ()function and code is getting executed but the output recieved is not the data in the sheets but an html code for the given scripts tab. What I can do for this??
New contributor
Shristi Krishna is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.