Logo Questions Linux Laravel Mysql Ubuntu Git Menu

Crud Webapp Google Apps Script

Is it possible create Crud Webapp with Google Apps Script. I need to create a web table able to update and get values from Google spreadsheet?

like image 974
Pasquale Martucci Avatar asked Mar 11 '23 21:03

Pasquale Martucci

2 Answers

yes its possible, you can insert, update a row, delete and retreive a row using google app scripts try this link https://github.com/AishwaryT/Google-app-script-crud let me know if you face any problem.

like image 130
Aishwary Tiwari Avatar answered Mar 19 '23 04:03

Aishwary Tiwari

Yes absolutely it is possible. Write a code in Google app script for CRUD operation over the Google spreadsheet (like Insert, Update, delete). accept the parameters using doGet() / doPost() method to insert/update data into the Google spreadsheet and return the updated data or any response in the JSON/XML or in the string format, deploy your app script (with "anyone even anonymous"), copy the URL of the deployed script and call to that URL from your your web application (in java script AJAX call) and get response from app script to your application.

Reference :https://developers.google.com/apps-script/

like image 39
Nitin Dhomse Avatar answered Mar 19 '23 04:03

Nitin Dhomse