Duaer

Build

Read rows with Google Sheets in Duaer

In Duaer, Google Sheets defaults to Authentication OAuth2, Resource Sheet, and Operation Get Row(s). You need a googleSheetsOAuth2Api credential.

Get rows from a sheet

  1. Create a googleSheetsOAuth2Api credential (or switch to Service Account in the panel).
  2. Search for Google Sheets, connect it after the previous node, and select that credential.
  3. Leave Resource on Sheet and Operation on Get Row(s).
  4. Choose Document (spreadsheet) and Sheet (tab).
  5. Select Execute step. Rows appear as output items.

Other operations include Append Row, Append or Update Row, Update Row, Clear, Create, and Delete.

For in-product tables, prefer Keep rows in a Duaer data table. For SQL, see Read and write Postgres in Duaer.

Questions

Does Google Sheets in Duaer default to read or write?

Operation defaults to Get Row(s). Switch to Append Row when you need to write.

In this section

Nodes

Create an Airtable record in Duaer

In Duaer, Airtable defaults to Authentication Token and Resource Record; Operation defaults to Get. For create, switch to Create, pick Base and Table, then map Columns. You need an airtableTokenApi credential.

Nodes

Create a Notion page in Duaer

In Duaer, Notion defaults to Authentication API Key, Resource Page, and Operation Create. Content Type defaults to Block Builder. You need a notionApi credential.

Nodes

Upload a file with Google Drive in Duaer

In Duaer, Google Drive defaults to Authentication OAuth2, Resource File, and Operation Upload. Input Data Field Name defaults to data. You need a googleDriveOAuth2Api credential.