Google Sheets - New/updated row in sheet in Team Drive trigger

This trigger detects changes made to rows in your selected sheet, as well as new rows added at the bottom of your sheet.

Note that rows added in the middle of the sheet are not detected. Don't delete any row from the sheet when this trigger is active, as it can disrupt tracking.

LIMITATIONS

This trigger works exclusively with Team Drive. Use the New/updated row in sheet in My Drive trigger to monitor Team Drive.

Input

Input fieldDescription
Trigger poll intervalSpecify how frequently to check for new events. This field defaults to five minutes if left blank. The minimum value allowed is five minutes.
Google DriveSelect a team drive.
SpreadsheetSelect the spreadsheet to monitor for new/updated rows.
SheetChoose the sheet to monitor for new/updated rows. The sheet must have at least one header row and one data row.
Add column names manually?Indicate whether to add column names manually. Defaults to No.

Output

Output fieldDescription
Spreadsheet IDThe unique identifier for the spreadsheet.
Spreadsheet nameThe name of the spreadsheet.
Sheet nameThe sheet name.
Row numberThe row number.

Last updated: