Supported
Triggers, Searches, Filters, and Actions
Search
Search Rows (Advanced)
Returns results matching the given criteria. This module doesn't return a row number.
Search
Search Rows
Returns results matching the given criteria.
Search
Get Range Values
Gets a range content.
Search
Get Many Spreadsheet Rows (Advanced, With Line Item Support)
Returns many rows (20 max.) as a single JSON value and flat rows (line items).
Search
Find Many Spreadsheet Rows (With Line Item Support)
Finds many matched rows (10 max.) by a column and value.
Search
Lookup Spreadsheet Row
Finds a row by a column and value. Returns the entire row if one is found.
Trigger
Watch Rows
Watches for new rows.
Trigger
Watch Changes INSTANT
Triggers when a cell is updated. Watches only changes made in Google Sheet app. Sheets Add-On required.
Action
Perform a Function INSTANT
Receives data passed to the function INTEGROMAT used in a sheet. Sheets Add-On required.
Trigger
New Spreadsheet
Triggered when you create a new spreadsheet.
Trigger
New Worksheet
Triggered when you create a new worksheet in a spreadsheet.
Trigger
New or Updated Spreadsheet Row (Team Drive)
Triggered when a new row is added or modified in a spreadsheet - works best with Team Drives.
Trigger
New Spreadsheet Row (Team Drive)
Triggered when a new row is added to the bottom of a spreadsheet - works best with Team Drives.
Action
New or Updated Spreadsheet Row
Triggered when a new row is added or modified in a spreadsheet.
Action
New Spreadsheet Row
Triggered when a new row is added to the bottom of a spreadsheet.
Action
Update a Row
Updates a row.
Action
Update a Cell
Updates a specific cell.
Action
Perform a Function
Responder Returns processed data as a result of the INTEGROMAT function. Sheets Add-On required.
Action
Get a Cell
Gets a specific cell.
Action
Delete a Row
Deletes a specific row.
Action
Create a Spreadsheet
Creates a new spreadsheet.
Action
Clear a Row
Clears values from a specific row.
Action
Clear a Cell
Cleares a specific cell.
Action
Add a Sheet
Adds a new sheet.
Action
Add a Row
Appends a new row to the bottom of the table.
Action
Create Spreadsheet
Create a blank spreadsheet with a title. Optionally, provide headers.
Action
Delete Spreadsheet Row
Deletes the content of a row in a specific spreadsheet. Deleted rows will appear as blank rows in your spreadsheet. Please use with caution.
Action
Create Spreadsheet Column
Create a new column in a specific spreadsheet.
Action
Create Spreadsheet Row(s)
Create one or more new rows in a specific spreadsheet (with line item support).
Action
Update Spreadsheet Row
Update a row in a specific spreadsheet.
Action
Create Spreadsheet Row
Create a new row in a specific spreadsheet.
Action
Create Worksheet
Create a blank worksheet with a title. Optionally, provide headers.