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.