Microsoft Excel 365

Trigger

Create a request filter that will invoke any of the actions below when an API request matches the filter criteria.

Actions

Any of the actions listed below can be triggered when a new request matches one of your request filters. These actions can also be incorporated into multi-step workflows, enabling the development of robust logic to fulfill your business requirements.

Add a Worksheet to a Workbook

Add a worksheet to a workbook

Append Row to Worksheet

Append row of values to a worksheet

Append Rows to a Table

Append rows to a table

Clear Cells by Range

Clear a block of cells (range) content or formatting.

Clear Column by Index

Clear contents/formatting of a column by its index.

Clear Row by ID

Clear contents/formatting of an entire row by its ID.

Clear Worksheet

Clear a worksheet

Convert to Range

Converts a table to a range

Create Table

Create a table in a worksheet

Create Workbook

Create a new workbook at the specified location

Create Worksheet

Add a new worksheet (tab) to an existing workbook with optional default headers.

Custom API Call

Send a custom API call to a specific endpoint

Delete Table

Delete a table from a worksheet

Delete Workbook

Delete a workbook

Delete Worksheet

Delete a worksheet in a workbook

Find Row

Locate a row by specifying a lookup column and value (e.g. find a row where “ID” = 123).

Get Cells in Range

Retrieve the values in a given cell range (e.g., “A1:C10”).

Get Row by ID

 Retrieve the entire content of a row by its row ID.

Get Table Columns

List columns of a table in a worksheet

Get Table Rows

List rows of a table in a worksheet

Get Workbooks

Retrieve a list of workbooks

Get Worksheet Rows

Retrieve rows from a worksheet

Get Worksheet by ID

Retrieve metadata of a worksheet by its ID.

Get Worksheets

Retrieve worksheets from a workbook

Lookup Table Column

Lookup a value in a table column in a worksheet

Rename Worksheet

Change the name of an existing worksheet.

Update Worksheet Rows

Update a row in a worksheet