Add single row
The Google Sheets Add Single Row tool allows users to efficiently append individual rows of data to any specified Google Sheets spreadsheet, streamlining data management and integration workflows. It supports both personal and shared drives for versatile document access.
Features
- Supports adding data to custom worksheets within Google Sheets using sheet and worksheet IDs.
- Works with both 'My Drive' and Shared Drives for flexible data storage options.
- Retrieves header information automatically when the spreadsheet has headers to facilitate easy data input.
- Integrates seamlessly with automation platforms like Pipedream for streamlined app workflows.
- Provides detailed configuration options to specify exact locations and data structure for row insertion.
Benefits
- Simplifies the process of adding new entries to Google Sheets without manual input.
- Enhances team collaboration by allowing shared drives integration.
- Reduces errors by using header-based data mapping for accurate column insertion.
- Automates repetitive data entry tasks to save time and improve efficiency.
- Enables dynamic and scalable data management within cloud-based spreadsheets.
Description
Add a single row of data to Google Sheets. See the documentation
Parameters
4 parameters
| Name | Type | Description |
|---|---|---|
| drive | string | Defaults to |
| sheetIdrequired | string | Select a spreadsheet or provide a spreadsheet ID |
| worksheetIdrequired | string | Select a worksheet or enter a custom expression. When referencing a spreadsheet dynamically, you must provide a custom expression for the worksheet. |
| 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. |