sheets_insert_rows
Insert new rows into a Google Sheet at a specified anchor point, optionally filling them with data and controlling formatting inheritance.
Instructions
Insert new rows at a specific position with optional data
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| rows | No | Number of rows to insert (default: 1) | |
| range | Yes | The A1 notation anchor point where rows will be inserted (e.g., "Sheet1!A5") | |
| values | No | Optional 2D array of values to fill the newly inserted rows | |
| position | No | Position relative to the anchor row (default: BEFORE) | |
| spreadsheetId | Yes | The ID of the spreadsheet (found in the URL after /d/) | |
| valueInputOption | No | How the input data should be interpreted (default: USER_ENTERED) | |
| inheritFromBefore | No | Whether to inherit formatting from the row before (default: false) |