Integrations
Use Google Sheets in Duaer
In Duaer, the Google Sheets node works with Google Sheets from a workflow. It offers 10 operations on Document and Sheet Within Document.
Add Google Sheets to a Duaer workflow
For a walkthrough with examples, refer to Read rows with Google Sheets in Duaer.
- On the Duaer canvas, open the node panel, search for Google Sheets, and connect it after the previous node.
- Under Authentication, choose Service Account or OAuth2 (recommended), then pick or create the matching credential (Google Service Account API or Google Sheets OAuth2 API) in Credential to connect with. Refer to Google Sheets credentials.
- Pick a Resource and an Operation. For example, to create a new row in a sheet, pick Sheet Within Document and Append Row.
- Fill the fields that operation shows, such as Document, Sheet, and Columns.
- Select Execute step and check the output.
Google Sheets operations in Duaer
The Google Sheets node in Duaer offers these operations, grouped by resource:
- Document › Create: Create a spreadsheet.
- Document › Delete: Delete a spreadsheet.
- Sheet Within Document › Append or Update Row: Append a new row or update an existing one (upsert).
- Sheet Within Document › Append Row: Create a new row in a sheet.
- Sheet Within Document › Clear: Delete all the contents or a part of a sheet.
- Sheet Within Document › Create: Create a new sheet.
- Sheet Within Document › Delete: Permanently delete a sheet.
- Sheet Within Document › Delete Rows or Columns: Delete columns or rows from a sheet.
- Sheet Within Document › Get Row(s): Retrieve one or more rows from a sheet.
- Sheet Within Document › Update Row: Update an existing row in a sheet.
Use Google Sheets as a tool for an AI Agent in Duaer
In the Tool input of an AI Agent, search for Google Sheets 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 Google Sheets endpoint the node does not cover
Add an HTTP Request node, set Authentication to Predefined Credential Type, pick Google Service Account 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.
Common issues
For errors and fixes, refer to Common issues with Google Sheets in Duaer.
Questions
Which Google Sheets operations does Duaer support?
Duaer's Google Sheets node offers 10 operations on Document and Sheet Within Document. For example, Document has Create and Delete.
Which credential does Google Sheets use in Duaer?
Duaer's Google Sheets uses Google Service Account API or Google Sheets OAuth2 API, 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.