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.
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.
Provide Row Number and leave Overwrite off. New sheet rows are
inserted at that position, shifting existing rows down.
Provide Row Number and enable Overwrite. Values replace cells in the
destination rows without shifting existing data.
Outputs
In insert and overwrite modes, values are written as strings. Missing column
values are written as empty strings across the table width.
Troubleshooting
No matching column was found
Confirm Header Row Number and the sheet name, then use column names
close to the visible header text.
