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
- On the Duaer canvas, open the node panel, search for Microsoft Excel (SharePoint), and connect it after the previous node.
- 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.
- Pick a Resource and an Operation. For example, to append rows to the end of a sheet, pick Sheet and Append.
- Fill the fields that operation shows, such as Workbook, Sheet, Site, and Document Library.
- 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
Built-in integrations in Duaer
Built-in triggers, actions, and credentials in Duaer. Triggers start a workflow. Actions run a step after it has started.
IntegrationsRisks of community nodes in Duaer
Before you install a community node in Duaer, know the code comes from a source the instance admin trusts, and know what permissions it gets.
IntegrationsTroubleshoot community nodes in Duaer
When a Duaer community node will not install or run, check the version, permissions, and node docs, then the instance logs.
IntegrationsMake custom API calls for an app in Duaer
When a Duaer app node does not expose the API you need, use HTTP Request and reuse that app’s saved authentication.
IntegrationsIntegrations in Duaer
Built-in triggers, actions, and credentials in Duaer. Community nodes are extra packages. Custom operations reuse saved authentication with HTTP Request.
CredentialsBuilt-in credentials in Duaer
Per-service credential notes for Duaer built-ins. The create flow is in the credentials overview; node docs link to the matching service page.
Create nodesCreate a custom node for Duaer
Write a node package for Duaer when built-in nodes and custom operations are not enough and you will reuse the step.