Duaer

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.

  1. On the Duaer canvas, open the node panel, search for Google Sheets, and connect it after the previous node.
  2. 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.
  3. Pick a Resource and an Operation. For example, to create a new row in a sheet, pick Sheet Within Document and Append Row.
  4. Fill the fields that operation shows, such as Document, Sheet, and Columns.
  5. 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