Skip to main content
The Insert Table Rows action maps named values to a sheet’s headers, then appends them or writes them at a specific row. It is easier to maintain than a raw range write when a table’s columns have meaningful names.

​
Inputs

For each row object, column names are matched to the closest header ignoring capitalization, within a small spelling distance. Missing columns become empty cells.

​
Behavior by mode

Leave Row Number empty. Sheets appends the rows after its detected table and returns the appended Updated Range.

​
Outputs

In insert and overwrite modes, values are written as strings. Missing column values are written as empty strings across the table width.

​
Troubleshooting

Confirm Header Row Number and the sheet name, then use column names close to the visible header text.