Definition and Usage
This command inserts one or more blank rows at a specified position in a Google Sheet. You can choose to insert rows either below or above a specified row number, allowing you to create space for new data in your spreadsheet.
Parameter Values
Input parameters
Parameter | Description | Possible Values | Required | Options / Notes |
Google Sheet | Select the Google sheet to read |
| Yes | Must be a valid Google Sheet reference |
Insert position | Select the position to insert rows | Below, Above | Yes | Determines whether rows are inserted below or above the specified row |
Row | Enter the row number (starting from 1) where the blank row(s) will be inserted |
| Yes | Must be a valid row number in the sheet |
Number of rows | Specify how many rows to insert |
| Yes | Must be a positive integer |
Error handling
Parameter Name | Description |
Throw error & stop | When an error occurs, the action will trigger an error and stop the execution of the entire app. |
Retry command | If an error occurs, the action will retry the command in an attempt to resolve the issue and continue the process. |
Ignore error & continue | When an error occurs, the action will be ignored, and the workflow will continue without interruption. |
Variables produced
This action doesn't produce any variables.
Using Variables in Conditions
Parameters marked with {x} icon can accept variables. You can use variables to dynamically determine:
Which Google Sheet to modify
The target row number where blank rows should be inserted
How many blank rows to insert
For example, you could use a variable to insert a dynamic number of rows based on a calculation or user input from a previous step in your workflow.
Notes
Before using this command, ensure you have properly connected to the Google Sheet and have appropriate permissions to modify it.
The row number starts from 1 (not 0), following standard spreadsheet conventions.
If you specify a row number that exceeds the current number of rows in the sheet, the blank rows will be added at the end of the sheet.
This command is useful when you need to create space for new data entries while preserving existing data structure.