Duaer

Integrations

Use Microsoft Excel (OneDrive) in Duaer

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

Add Microsoft Excel (OneDrive) to a Duaer workflow

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

Microsoft Excel (OneDrive) operations in Duaer

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

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

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

In the Tool input of an AI Agent, search for Microsoft Excel (OneDrive) 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 (OneDrive) endpoint the node does not cover

Add an HTTP Request node, set Authentication to Predefined Credential Type, pick Microsoft Excel 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 (OneDrive) operations does Duaer support?

Duaer's Microsoft Excel (OneDrive) node offers 17 operations on Table, Workbook, and Sheet. For example, Table has Append, Convert to Range, Create, Delete, Get Columns, and 2 more.

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

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

In this section