appmixer.google.spreadsheets.NewRow

Component Details

v1.0.0

Basic Information

appmixer.google.spreadsheets.NewRow

1.0.0

Public

This trigger fires whenever a new row is added to your Google Spreadsheet. It works by monitoring a specific column (chosen by you) as the 'Index Column'. The worksheet must have a header row for proper operation. Note: The trigger is optimized for detecting rows added at the bottom of the sheet. If rows are added in between existing rows, or if there are non-unique values in the index column, the trigger may not function as expected.

Properties

FieldTypeDescription
Spreadsheet select Select spreadsheet.
Worksheet select Select worksheet.
Index Column text Specify the column letter that will be used as the Index Column (e.g., 'A' for the first column, 'AA' for the 27th). The trigger will monitor this column to detect new rows. For best results, use a column where each value is unique. Note that if rows are added in between existing rows, the trigger may not detect the change as expected. Learn more about Google Sheets A1 notation: Google Sheets A1 notation.

Output Ports

out

Dynamic variables loaded from /component/appmixer/google/spreadsheets/ListColumns?outPort=out

Full Metadata