how to use google drive apps script for spreadsheets

But you can make custom text response with some Content service. This allows you to write scripts that act as “services”, responding to GET and POST requests and serving data of various MIME types.” – Means: Usually response is automated result from some HTML service. “ Instead of returning a user interface object created with the HTML service, the Content service can be used to return raw textual content. Get request can’t carry any payload, so we are not interested. “ When a script is published as a web app “(which is our case)”, the special callback functions doGet()and doPost() are invoked whenever a request is made to the script’s URL.” - So when we send Post request with some text to script’s URL, function doPost() fires and processes our text. So I’ll try to translate for someone alive. Lets read couple paragraphs of this: The worst manual on the Earth. Google doesn’t consider you a whole person.ĭone ! So we finished preparations on a Google side. Go to Drive > New > More > Google Apps Script Let’s make some Google things!Ĭreate test spreadsheet. We need to prepare our google files, and then we will connect our Codular app. So if you really need working solution, spend 2 hours and make next steps by hands. I prepared a working script example with most needed functions for you. And before theory, let’s make some things work. Google made everything possible with its Google Apps Script.

Yes, I want custom API for my app, with blackjack and hookers! Is it really that hard? It took me a week to find answers and compile all information, i want to share with you now.

They are adding (and possibly removing) rows and columns, reading (and possibly replacing) values in the required cells, and doing these things from my app. When I think about using Google sheets along with my application, I want a few basic things.

How to use google drive apps script for spreadsheets