Tool
Add row
The Microsoft Excel Add Row tool seamlessly integrates with Pipedream to enable users to insert new rows into specified Excel worksheets effortlessly. Designed for automation and efficiency, it supports precise data entry into your spreadsheets via simple API calls.
Features
- Inserts a new row into any specified Excel worksheet with ease.
- Supports specifying folder ID, spreadsheet ID, and worksheet name for precise targeting.
- Accepts an array of string values representing each cell in the new row.
- Fully compatible with Microsoft Graph API for robust and secure data manipulation.
- Includes clear documentation and format instructions for accurate usage.
Benefits
- Automates data entry in Excel, saving time and reducing errors.
- Enhances workflow integration by connecting Excel with other applications through Pipedream.
- Enables dynamic and real-time updates to spreadsheets, improving data accuracy.
- Simplifies bulk data management by allowing easy insertion of multiple values at once.
- Boosts productivity by eliminating manual Excel editing through programmatic control.
Description
Insert a new row into a specified Excel worksheet. See the documentation
IMPORTANT: The arguments have specific formats. Please follow the instructions below:
- values: Return JSON in this format: string[]
Parameters
4 parameters
| Name | Type | Description |
|---|---|---|
| folderIdrequired | string | The ID of the folder where the item is located |
| sheetIdrequired | string | The ID of the spreadsheet you want to use |
| worksheetrequired | string | The name of the worksheet to use |
| valuesrequired | string[] | An array of values for the new row. Each item in the array represents one cell. E.g. |