I am facing an issue with the delay in receiving results after sending data to Google Sheet from my mobile application.
The data transfer is successful, but the JavaScript code takes too long (around 360s) to provide a response. Here is the snippet of my code:
In this code snippet, I'm trying to update user information in Google Sheets based on the provided email and password. However, the process seems to be taking longer than expected to execute.
it's ok
var ss = SpreadsheetApp.openByUrl("https://docs.google.com/spreadsheets/d/177kUZc61U8huVsq2OcGsiF2OGdPCSxMjkoh2C4KIWPM/edit#gid=0");
var sheet = ss.getSheetByName('Info');
function doGet(e) {
var action = e.parameter.action;
if (action == 'UpdateInfo') {
//return UpdateInfo(e);
}
}
function doPost(e) {
var action = e.parameter.action;
if (action == 'UpdateInfo') {
return UpdateInfo(e);
}
}
// More functions and logic for updating user info in Google Sheets...