In this post, I demonstrate how to clear, delete, insert, and replace rows using Google Apps Script on Google Sheets.
How to Video:
Video Notes:
- Legacy Apps Script Editor Used in Video
- Apps Script (Script Editor) is now located under tab ‘Extensions’ instead of ‘Tools’ on Google Sheets
Code in Video:
function clearRow() {
var ss = SpreadsheetApp.getActiveSpreadsheet();
var editSheet = ss.getSheetByName("EDIT");
var lastRowEdit = editSheet.getLastRow();
for(var i = 2; i <= lastRowEdit; i++)
{
if(editSheet.getRange(i,1).getValue() == 'TRAIN')
{
editSheet.getRange('A' + i + ':C' + i).clear();
}
}
}
function deleteRow() {
var ss = SpreadsheetApp.getActiveSpreadsheet();
var editSheet = ss.getSheetByName("EDIT");
var lastRowEdit = editSheet.getLastRow();
for(var i = 2; i <= lastRowEdit; i++)
{
if(editSheet.getRange(i,1).getValue() == 'TRAIN')
{
editSheet.deleteRow(i);
}
}
}
function insertRow() {
var ss = SpreadsheetApp.getActiveSpreadsheet();
var editSheet = ss.getSheetByName("EDIT");
var lastRowEdit = editSheet.getLastRow();
for(var i = 2; i <= lastRowEdit; i++)
{
if(editSheet.getRange(i,1).getValue() == 'TRAIN')
{
editSheet.insertRowAfter(i);
}
}
}
function replaceRow() {
var ss = SpreadsheetApp.getActiveSpreadsheet();
var editSheet = ss.getSheetByName("EDIT");
var lastRowEdit = editSheet.getLastRow();
for(var i = 2; i <= lastRowEdit; i++)
{
if(editSheet.getRange(i,1).getValue() == 'TRAIN')
{
editSheet.getRange('A' + i + ':C' + i).setValues([['AIRPLANE', 'ORANGE', 30]]);
}
}
}
Related Posts



















