Connect Commerce Layer to Microsoft Excel

Both apps 93Commerce Layer 41Microsoft Excel 52

• Trigger
  New Attachment

  Triggers when a new Attachment is created.

• Trigger
  New Customer

  Triggers when a new Customer is created.

• Trigger
  New Customer Address Event

  Triggers when a customer address is created.

• Trigger
  New Customer Password Reset Event

  Triggers when a customer password reset is requested.

• Trigger
  New Customer Subscription Event

  Triggers when a given customer_subscription event (one of create or destroy) is fired.

• Trigger
  New Price

  Triggers when a new Price is created.

• Trigger
  New Price Import

  Fires when a new price import is created in Commerce Layer.

• Trigger
  New Price List

  Triggers when a new Price List is created.

• Trigger
  New Shipping Category

  Triggers when a Shipping Category is created.

• Trigger
  New SKU

  Triggers when a new SKU is created.

• Trigger
  New SKU Import

  Triggers when a new SKU import is created.

• Trigger
  New Stock Item Import

  Triggers when a new Stock Item import is created.

• Trigger
  New Stock Transfer Event

  Triggers when a given stock transfer event (one of create, upocoming, picking, in_transit, complete, cancel is fired).

• Action
  Add Customer Address

  Adds an existing address to a customer's address book.

• Action
  Add Customer Password Reset

  Requests a password reset for a customer, returning the reset token to send them.

• Action
  Add Customer Subscription

  Subscribes a customer email to a list, identified by a reference such as a newsletter id.

• Action
  Add Stock Transfer

  Moves a quantity of a SKU from one stock location to another.

• Action
  Balance Change Gift Card

  Change balance of a gift card.

• Action
  Create Address

  Creates a postal address that can be attached to customers, orders and stock locations.

• Action
  Create Attachment

  Creates a new Attachment.

• Action
  Create Customer

  Creates a new Customer.

• Action
  Create Gift Card

  Creates a new Gift Card.

• Action
  Create Price Import

  Creates a new Price Import.

• Action
  Create Price List

  Creates a new Price List.

• Action
  Create SKU

  Creates a new SKU.

• Action
  Find Attachment

  Finds a Attachment by name.

• Action
  Find Customer

  Finds a customer by id or reference.

• Action
  Find Gift Card

  Finds a gift card by id or reference.

• Action
  Find Price

  Finds a price by price list.

• Action
  Find Price Import

  Finds a Price Import by status.

• Action
  Find Price List

  Finds a Price List by name.

• Action
  Find Shipping Category

  Finds an Shipping Category by name.

• Action
  Find SKU

  Finds an SKU by code.

• Action
  Find SKU Import

  Finds an SKU Import by status.

• Action
  Find Stock Item Import

  Finds a Stock Item Import by status.

• Action
  Get Address

  Retrieves one address by id.

• Action
  Get Customer Address

  Retrieves one customer address link by id.

• Action
  Get Customer Password Reset

  Retrieves a customer password reset by id, returning customer_email, reset_password_token and reset_password_at.

• Action
  Get Customer Subscription

  Retrieves one customer subscription by id.

• Action
  Get Stock Transfer

  Retrieves one stock transfer by id.

• Action
  Update Customer Reference

  Update customer data setting external identifier.

• Action
  Add Chart

  Add a chart to a worksheet using microsoft graph api.

• Action
  Add Sharepoint Worksheet

  Add a new worksheet to a sharepoint excel workbook using microsoft graph sites api.

• Action
  Add Table

  Create a table over a range in an Excel workbook.

• Action
  Add Table Column

  Add a column to a table using microsoft graph api.

• Action
  Add Table Row

  Add a row to a table using microsoft graph api.

• Action
  Add Workbook Permission

  Tool to grant access to a workbook via invite. use when you need to share a specific workbook file with designated recipients and roles.

• Action
  Add Worksheet

  Add a new worksheet to an excel workbook using microsoft graph api.

• Action
  Apply Table Filter

  Apply a filter to a table column using microsoft graph api.

• Action
  Apply Table Sort

  Apply a sort to a table using microsoft graph api.

• Action
  Clear Range

  Tool to clear values, formats, or contents in a specified worksheet range. use when you need to reset cells before adding new data.

• Action
  Clear Table Filter

  Clear a filter from a table column using microsoft graph api.

• Action
  Close Session

  Tool to close an existing excel workbook session. use when you need to explicitly end a persistent session to release workbook locks.

• Action
  Convert Table To Range

  Convert a table to a range using microsoft graph api.

• Action
  Create Workbook

  Create an .xlsx workbook in the user's OneDrive, from a file URL or blank.

• Action
  Delete Table Column

  Delete a column from a table using microsoft graph api.

• Action
  Delete Table Row

  Delete a row from a table using microsoft graph api.

• Action
  Delete Worksheet

  Tool to delete a worksheet from the workbook. use when cleaning up unused or temporary sheets after verifying no dependencies exist. example: "delete 'sheet2' after review."

• Action
  Get Chart Axis

  Tool to retrieve a specific axis from a chart. use when you need properties like min, max, interval, and formatting of the chart axis.

• Action
  Get Chart Data Labels

  Tool to retrieve the data labels object of a chart. use when you need to inspect label settings like position, separator, and visibility flags after creating or updating a chart.

• Action
  Get Chart Legend

  Tool to retrieve the legend object of a chart. use after creating or updating a chart when you need to inspect legend visibility and formatting.

• Action
  Get Range

  Get a range from a worksheet using microsoft graph api.

• Action
  Get Session

  Create a session for an excel workbook using microsoft graph api.

• Action
  Get Sharepoint Range

  Get a range from a worksheet in sharepoint using microsoft graph sites api.

• Action
  Get Sharepoint Worksheet

  Get a worksheet by name or id from a sharepoint excel workbook using microsoft graph sites api.

• Action
  Get Table Column

  Tool to retrieve a specific column from a workbook table. use when you need to fetch column properties and data by its id or name.

• Action
  Get Table Range

  Get Table Range

• Action
  Get Workbook

  Tool to retrieve the properties and relationships of a workbook. use when you need to inspect comments, names, tables, or worksheets.

• Action
  Get Worksheet

  Get a worksheet by name or id from an excel workbook using microsoft graph api.

• Action
  Get Worksheet Protection

  Get Worksheet Protection

• Action
  Get Worksheet Used Range

  Tool to retrieve a worksheet's used range (active data region) without specifying a fixed range address. Use when you need to read all data from a sheet but don't know the exact range. The valuesOnly option helps filter out formatting-only cells.

• Action
  Insert Range

  Tool to insert a new cell range into a worksheet, shifting existing cells down or right. use when you need to create space for new content without overwriting.

• Action
  List Charts

  List charts in a worksheet using microsoft graph api.

• Action
  List Chart Series

  Tool to list all data series in a chart. use when you need to enumerate chart series for further analysis.

• Action
  List Comments

  Tool to list comments in an excel workbook. use when you need to retrieve all workbook comments via microsoft graph api.

• Action
  List Files

  List files and folders in a drive root or specified path.

• Action
  List Named Items

  List named items in a workbook using microsoft graph api.

• Action
  List Sharepoint Tables

  List tables in a sharepoint worksheet using microsoft graph sites api.

• Action
  List Sharepoint Worksheets

  List worksheets in an excel workbook stored in sharepoint using microsoft graph sites api.

• Action
  List Table Columns

  List columns in a table using microsoft graph api.

• Action
  List Table Rows

  List rows in a table using microsoft graph api.

• Action
  List Tables

  List tables in a worksheet using microsoft graph api.

• Action
  List Workbook Permissions

  Tool to list permissions set on the workbook file. use when you need to see which users or links have access to a specific excel file by supplying its drive and item ids. example: "list permissions for workbook with drive id 'b!abc123' and item id '0123456789abcdef'."

• Action
  List Worksheets

  List worksheets in an excel workbook using microsoft graph api.

• Action
  Merge Cells

  Merge cells in a worksheet range using microsoft graph api.

• Action
  Protect Worksheet

  Tool to protect a worksheet using optional protection options. use when you need to prevent editing certain parts of a sheet before sharing. example: "protect 'sheet1' to lock formatting and sorting."

• Action
  Sort Range

  Sort a range in a worksheet using microsoft graph api.

• Action
  Update Chart

  Update a chart in a worksheet using microsoft graph api.

• Action
  Update Chart Legend

  Tool to update formatting or position of a chart legend. use when adjusting legend settings after confirming chart and worksheet exist.

• Action
  Update Range

  Update a range in a worksheet using microsoft graph api.

• Action
  Update Sharepoint Range

  Update a range in a sharepoint worksheet using microsoft graph sites api.

• Action
  Update Table

  Update a table in a workbook using microsoft graph api.

• Action
  Update Worksheet

  Update worksheet properties (name, position) in an excel workbook using microsoft graph api.

No trigger or action matches that. Ask your agent to add it: it reads the API documentation and builds what you describe.