Add single row
The Google Sheets Add Single Row tool enables users to seamlessly insert a new row of data into their Google Sheets spreadsheet. It offers flexibility in adding data either at the end of the sheet or at a specific position, supporting dynamic spreadsheet management.
Features
- Add a single row of data to any Google Sheets spreadsheet easily.
- Optionally insert the new row at a specified index to control data placement.
- Supports both personal drives (My Drive) and Shared Drives for flexible access.
- Automatically detects header rows to simplify accurate data entry.
- Complies with Google Sheets API standards for reliable and secure operation.
Benefits
- Streamlines data entry by automating the insertion of rows in Google Sheets.
- Enhances spreadsheet organization by allowing precise row placement.
- Saves time for users managing large datasets or reports.
- Integrates smoothly with various workflows leveraging Google Drive and Sheets.
- Improves data accuracy by respecting existing header structures and formatting.
Description
Add a single row of data to Google Sheets. Optionally insert the row at a specific index (e.g., row 2 to insert after headers, shifting existing data down). See the documentation
Parameters
5 parameters
| Name | Type | Description |
|---|---|---|
| drive | string | Defaults to You can use the "retrieve_options" tool using these parameters to get the values. key: google_sheets-add-single-row, propName: drive. |
| sheetIdrequired | string | Select a spreadsheet or provide a spreadsheet ID You can use the "retrieve_options" tool using these parameters to get the values. key: google_sheets-add-single-row, propName: sheetId. |
| worksheetIdrequired | integer | Select a worksheet or enter a custom expression. When referencing a spreadsheet dynamically, you must provide a custom expression for the worksheet. You can use the "retrieve_options" tool using these parameters to get the values. key: google_sheets-add-single-row, propName: worksheetId. |
| hasHeadersrequired | boolean | If the first row of your document has headers, we'll retrieve them to make it easy to enter the value for each column. Note: When using a dynamic reference for the worksheet ID (e.g. |
| rowIndex | integer | The row number where the new row should be inserted (e.g., |