insert_sheet_rows
Insert blank rows at any position in a Google Sheet, pushing existing content down instead of overwriting it. Optionally fill the new rows with values in the same call.
Instructions
Insert blank rows at a position, shifting existing rows down.
This is the one placement that update_sheet_range can't do: it makes
room by pushing existing rows down instead of overwriting them. Use it to
prepend at the top, or to insert into a sorted region. If values is
given, the freshly inserted rows are populated in the same call.
sheet_id is the spreadsheet's ID (from its URL) and is required.
tab is the worksheet title (see list_sheet_tabs). row_index
is the 1-based row number the inserted rows will occupy — content
currently at that row and below shifts down. Use 1 to insert above
everything; with a header in row 1, pass 2 to insert just below it.
values is an optional list of rows (each a list of cell strings) to
write into the new space; the number of rows inserted matches its length
(or 1 blank row when omitted). value_input_option USER_ENTERED parses
dates/numbers/formulas like typing; RAW stores text verbatim. Returns a
summary of what was inserted.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| tab | Yes | ||
| values | No | ||
| sheet_id | Yes | ||
| row_index | Yes | ||
| value_input_option | No | USER_ENTERED |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |