Skip to content

Instantly share code, notes, and snippets.

@emmaly
Created November 22, 2021 23:04
Show Gist options
  • Save emmaly/466d9881efd5a4a1ef379ee26e3be065 to your computer and use it in GitHub Desktop.
Save emmaly/466d9881efd5a4a1ef379ee26e3be065 to your computer and use it in GitHub Desktop.
Google Sheets onEdit range row walker
function onEdit(e) {
const range = e.range;
const sheet = range.getSheet();
if (sheet.getSheetId() == 123123123) { // whatever sheet ID
for (let i=0; i<range.getNumRows(); i++)
rowOnEdit(sheet.getRange(range.getRow()+i, 1, 1, sheet.getLastColumn()));
}
}
function rowOnEdit(rowRange) {
// const range = SpreadsheetApp.getActiveRange();
Logger.log("%d: %d", rowRange.getRow(), rowRange.getValues()[0][0]);
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment