Create Row
Add a new row to the bottom of a spreadsheet.
Options
Field | Definition | Type | Required |
---|---|---|---|
Use Spreadsheet ID? |
Option to specify a Google Sheets spreadsheet by ID.
If you select If you select The Spreadsheet ID is the last string of characters in the URL for your spreadsheet. For example, in the URL |
Dropdown | TRUE |
Spreadsheet |
List of spreadsheets in your Google Sheets account.
![]() Due to an API limitation, a maximum of 100 spreadsheets are returned in a search. To search for a specific spreadsheet, use the Enter Spreadsheet ID option. |
Dropdown | TRUE |
Spreadsheet ID | Unique identifier for your selected spreadsheet. | String | FALSE |
Worksheets | List of worksheet tabs in your selected spreadsheet. | Dropdown | TRUE |
Input
Field | Definition | Type | Required |
---|---|---|---|
Columns | Dynamically generated list of columns from Row 1 of your sheet (the header row must be created manually to generate this input). | String | FALSE |
Output
Field | Definition | Type |
---|---|---|
Updated Range | Range address of the new row. For example, Sheet1!A20:M20 . |
String |
Row Number | Number of the new row. | Number |