function doGet(e) { var sheet = SpreadsheetApp.openById("1c9JP0KSgOqIcewJHLYoo796WdvkOIfjDBBORnlFR3Os"); var n = sheet.getRange("U1").getValue()+1; var time = sheet.getRange("C"+n).getValue(); var phone = sheet.getRange("E"+n).getValue(); sheet.getRange("U1").setValue(n); return 1; }

Writes that the script was executed, but the return value does not belong to the supported type.

http://joxi.ru/D2PegJRuvY1xA3 - this is the screen.

    1 answer 1

    For a long time I was looking for a way to transfer data from google spreadsheets when new lines appear.

    I hope that someone will be useful.

    Here is the solution