Thursday, 4 December 2025

Using JS in GoogleSheets

function func() 
{
    // sheet initial
    var app= SpreadsheetApp;
    var activeSheet = app.getActiveSpreadsheet().getActiveSheet();

    // get value
    var cell = activeSheet.getRange(row, col).getValue();

    // set value
    activeSheet.getRange(row, col).setValue(cell);

    // console log
    Logger.log (cell);
}


No comments:

Google Form using App Script

Create a Google Sheet with the following headers: First Name, Last Name, DoB Create a Google Form with the exact headers as Google Sheet he...