Google Sheets

Action: Add or Update Row

appKey: googleSheets
actionKey: addRow

Action Inputs

The following parameters are available when configuring this action:

sheetIdrequiredstring
A specific sheet id containing the rows of columns. E.g., 'Sheet1'.
spreadsheetIdrequiredstring
The google sheet id containing the relevant sheet.
columnsobject
The columns to add to the row. Loaded from existing headers on a sheet
fieldIdstring
The fieldId which will be used in conjunction with the searchValue to find the row to update. Includes any existing id values available in the dynamic schema for the selected trigger. (See Dynamic Schemas for more information.)
updateExistingRowboolean
If true, will update an existing row if found. If the row cannot be found a new row will be created