a. Reading cell ranges.
b. Adding rows to the end of a spreadsheet.
c. Updating the content of a cell range.
d. Clearing the content of a cell range.
Node configurationBelow are the fields required for its configuration:
- Name (optional): allows you to customize the node’s name within the flow, replacing the default value.
- Credentials (required): Microsoft Authentication Library authentication credentials (Client Credentials). Multiple credentials can be stored, although only one can be active at a time.
- Location Type (required): defines the workbook location type. Available options are SharePoint Site and Shared Drive.
-
SharePoint Site Domain (required): SharePoint site domain.
→ Example: contoso.sharepoint.com -
SharePoint Site Name (required): SharePoint site name.
→ Example: MySite - Shared Drive Name (required only for Location Type = Shared Drive): name of the shared document library.
- Workbook URL (required): full URL of the Excel workbook stored in the drive. This URL is obtained through the Copy Link option in SharePoint.
- Action (required): defines the type of operation the node will perform.
-
Output Path (required): variable where the operation results or metadata will be stored.
→ Example: msg.output
You can download an example flow from this link. Credential configurationBelow are the required fields to configure Microsoft Authentication Library:
- Tenant ID (required): Azure Active Directory tenant identifier.
- Client ID (required): identifier of the application registered in Azure AD.
- Client Secret (required): client secret of the application registered in Azure AD.
The SheetName/Cells field accepts different formats depending on the selected action:- Sheet name only: Sheet1 - Valid only for the Append Rows action.
- Full range: Sheet1!A1:C3 - Valid for the Get Cells, Update Cells, and Clear Cells actions.
It is also possible to use templates to dynamically build ranges.→ Example: {{{sheetRange}}}
Operation configurationBelow are the specific fields for each action:
Get Cells: Reads a range of cells from the Excel workbook and stores the result in an output message property.- Cells (required): cell range to read.
→ Format: SheetName!A1:C3 - Flatten Output (optional): when enabled, converts the resulting two-dimensional array into a one-dimensional array.
By default, this option is disabled:→ Example:
- Default result: [["John"], ["Smith"]]
- With Flatten Output enabled: ["John", "Smith"]
Append Rows: Adds new rows to the end of the used range in the specified sheet.-
SheetName (required): target sheet name.
→ Format: SheetName (without cell range) -
Input Data (required): variable from which the data to be stored is read.
→ Example: msg.input
This field can contain:- A single value: "John" → adds a row with a single cell.
- An array of values: [["John", "Smith"]] → adds a row with multiple cells.
- An array of arrays: [["John", "Smith"], ["Anna", "Garcia"]] → adds multiple rows.
Update Cells: Replaces the content of the specified cell range with the new provided values.-
Cells (required): cell range to update.
→ Format: SheetName!A1:C3 -
Input Data (required): the variable from which the data to be stored is read. It must be a two-dimensional array matching the specified range.
→ Example: msg.input
Example: To update the range Sheet1!A1:B2, the Input Data field must contain → [["Value A1", "Value B1"], ["Value A2", "Value B2"]] Clear Cells: Removes the content of the cells within the specified range while preserving the applied formatting.-
Cells (required): cell range to clear.
→ Format: SheetName!A1:C3
This operation only removes cell values. Formatting, borders, and styles are preserved.
In the following video, we show you how to configure the node in Studio: