Skip to content

Instantly share code, notes, and snippets.

@PatilShreyas
Last active November 7, 2020 11:51
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save PatilShreyas/812ec4855499ec7726e3444d6b677b59 to your computer and use it in GitHub Desktop.
Save PatilShreyas/812ec4855499ec7726e3444d6b677b59 to your computer and use it in GitHub Desktop.
function doPost(request){
// Open Google Sheet using ID
var sheet = SpreadsheetApp.openById("1OOArrqjOqmD4GiJOWlluZ4woTMH_qaV6RKv4JXnT3Hk");
var result = {"status": "SUCCESS"};
try{
// Get all Parameters
var name = request.parameter.name;
var email = request.parameter.email;
var mobileNo = request.parameter.mobileNo;
var feedback = request.parameter.feedback;
// Append data on Google Sheet
var rowData = sheet.appendRow([name, email, mobileNo, feedback]);
}catch(exc){
// If error occurs, throw exception
result = {"status": "FAILED", "message": exc};
}
// Return result
return ContentService
.createTextOutput(JSON.stringify(result))
.setMimeType(ContentService.MimeType.JSON);
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment