Duaer

Integrations

Use Microsoft Excel (SharePoint) in Duaer

In Duaer, the Microsoft Excel (SharePoint) node works with Microsoft Excel (SharePoint) from a workflow. It offers 18 operations on Sheet, Table, and Workbook.

Add Microsoft Excel (SharePoint) to a Duaer workflow

  1. On the Duaer canvas, open the node panel, search for Microsoft Excel (SharePoint), and connect it after the previous node.
  2. Under Authentication, choose Microsoft OAuth2 (Graph) or Microsoft Entra Service Principal (App-Only), then pick or create the matching credential (Microsoft OAuth2 API or Microsoft Entra Service Principal) in Credential to connect with.
  3. Pick a Resource and an Operation. For example, to append rows to the end of a sheet, pick Sheet and Append.
  4. Fill the fields that operation shows, such as Workbook, Sheet, Site, and Document Library.
  5. Select Execute step and check the output.

Microsoft Excel (SharePoint) operations in Duaer

The Microsoft Excel (SharePoint) node in Duaer offers these operations, grouped by resource:

  • Sheet: Append, Append or Update, Clear, Delete, Get Many, Get Rows, Update
  • Table: Append, Convert to Range, Create, Delete, Get Columns, Get Many, Get Rows, Lookup
  • Workbook: Add Sheet, Delete, Get Many

Use Microsoft Excel (SharePoint) as a tool for an AI Agent in Duaer

In the Tool input of an AI Agent, search for Microsoft Excel (SharePoint) and add it. The agent decides when to call it. For a field the model should fill, select the sparkle next to it or write $fromAI('name', 'what to put here'); fixed values stay as you set them.

Call a Microsoft Excel (SharePoint) endpoint the node does not cover

Add an HTTP Request node, set Authentication to Predefined Credential Type, pick Microsoft OAuth2 API as the credential type, and select the same credential. Duaer signs the request with it, so you only fill in the method and URL. Refer to custom operations.

Questions

Which Microsoft Excel (SharePoint) operations does Duaer support?

Duaer's Microsoft Excel (SharePoint) node offers 18 operations on Sheet, Table, and Workbook. For example, Sheet has Append, Append or Update, Clear, Delete, Get Many, and 2 more.

Which credential does Microsoft Excel (SharePoint) use in Duaer?

Duaer's Microsoft Excel (SharePoint) uses Microsoft OAuth2 API or Microsoft Entra Service Principal, depending on the method you choose under Authentication.

In this section