Triggers when a form entry is submitted.
Nelio Form IdentifierRequired
Triggers when a new row is added to the bottom of a spreadsheet.
Dont Change Sheet Structure
No Team Drive
SpreadsheetRequired
WorksheetRequired
Triggers when a new row is added or an existing row is updated in a spreadsheet. Optimized for Team Drive.
Drive
Trigger column
Triggers when a worksheet is created in a spreadsheet.
Create a new row in a specific spreadsheet.
Use Timezone set up on the spreadsheet to format date values?
Creates a new spreadsheet row at the top of a spreadsheet (after the header row).
Apply conditional formatting to cells in a Google Sheets spreadsheet based on their values.
Cell RangeRequired
Condition TypeRequired
Background Color
Text Color
Bold Text
Italic Text
Creates a new worksheet by copying an existing worksheet.
Spreadsheet Containing the Worksheet to CopyRequired
Worksheet to CopyRequired
Copy Worksheet Destination
Creates a new worksheet in a Google Sheet.
TitleRequired
Overwrite existing worksheet with the same title
Headers
Permanently delete a worksheet from a Google Sheets spreadsheet. Warning: This action cannot be undone.
Confirm DeletionRequired
Apply date, number, or style formatting (colors, bold, italic, strikethrough) to a range of cells in a Google Sheets spreadsheet.
Format TypeRequired
Rename a worksheet in a Google Sheets spreadsheet.
New Sheet NameRequired
Sort data within a specified range in Google Sheets by a chosen column in ascending or descending order.
Sort by ColumnRequired
Sort OrderRequired
Update one or more rows in a specific spreadsheet (with line item support).
Find up to 500 rows based on a column and value as line items.
Lookup columnRequired
Lookup valueRequired
Supporting lookup column
Supporting lookup value
Search from last row
Row count
Get data from a specific range in a Google Spreadsheet using A1 notation (e.g., "A1:D10", "B2:E5").
A1 RangeRequired
Get a specific spreadsheet row by its row number (ID). Row 1 is typically the header row.
Row IDRequired
Find a specific spreadsheet row based on a column and value. If found, it returns the entire row.
Finds or creates a specific lookup row.
Triggers when a new row is added to the bottom of a Google Team Drive spreadsheet.
Triggers when a new spreadsheet is created.
Triggers when a new row is added or modified in a spreadsheet.
Create a new column in a specific spreadsheet.
Column NameRequired
Index
Create one or more new rows in a specific spreadsheet (with line item support).
Update Google Sheets properties like frozen rows/columns, sheet position, and visibility settings.
Frozen Rows Count
Frozen Columns Count
Sheet Position
Hide Sheet
Copy data from one range to another within a Google Sheets spreadsheet, with options for what to paste (values, formatting, etc.).
Source RangeRequired
Destination RangeRequired
Paste Type
Creates a new spreadsheet. Choose from a blank spreadsheet, a copy of an existing one, or one with headers.
Spreadsheet to Copy
Clears the contents of the selected row(s) while keeping the row(s) intact in the spreadsheet.
Info
Row(s)Required
Deletes the selected row(s) from the spreadsheet. This action removes the row(s) and all associated data.
Format a row in a specific spreadsheet.
RowRequired
Bold
Italic
Strikethrough
Set data validation rules on a range of cells in Google Sheets to control what data can be entered.
Validation TypeRequired
Input Message
Strict Validation
Update a row in a specific spreadsheet with optional formatting.
This is an advanced action which makes a raw HTTP request that includes this integration's authentication.
Stop on errorRequired
HTTP MethodRequired
URLRequired
Query string parameters
Additional request headers
Body
Finds a worksheet by title.
Return up to 1,500 rows as a single JSON value or as line items.
ColumnsRequired
Row countRequired
Output format
First row
Get a specific Google Spreadsheet by its ID. Returns the raw spreadsheet data from the Google Sheets API.
Spreadsheet IDRequired
Finds or creates a specific find worksheet.