Duaer

Integrations

Start a Duaer workflow with Google Sheets Trigger

In Duaer, Google Sheets Trigger starts a workflow by checking Google Sheets on a schedule you set. It can listen for 3 events, such as Row Added, Row Updated, and Row Added or Updated.

Start a Duaer workflow with Google Sheets Trigger

  1. On the Duaer canvas, open the node panel, search for Google Sheets Trigger, and add it as the first node.
  2. Under Authentication, choose Service Account or OAuth2 (recommended), then pick or create the matching credential (Google Service Account API or Google Sheets Trigger OAuth2 API) in Credential to connect with. Refer to Google Sheets Trigger credentials.
  3. Pick the events that should start a run, for example Row Added or Row Updated.
  4. Set Document and Sheet.
  5. If needed, select Add Option for the optional settings listed below.
  6. Set Poll Times, select Execute step to fetch a sample, then publish the workflow so Duaer checks Google Sheets on that schedule.

Events that start a Duaer workflow with Google Sheets Trigger

Row Added, Row Updated, Row Added or Updated.

Google Sheets Trigger parameters in Duaer

  • Poll Times: Time at which polling should occur.
  • Document
  • Sheet
  • Include in Output: This option will be effective only when automatically executing the digital organization.

Google Sheets Trigger options in Duaer

Under Add Option, Google Sheets Trigger offers Columns to Watch, Data Location on Sheet, Value Render, and DateTime Render.

Common issues

For errors and fixes, refer to Common issues with Google Sheets Trigger in Duaer.

Questions

Which Google Sheets Trigger events can start a Duaer workflow?

Duaer's Google Sheets Trigger can listen for 3 events, including Row Added, Row Updated, and Row Added or Updated. Pick one or more on the node.

Does Google Sheets Trigger run before the Duaer workflow is published?

Only while you test with Execute step. After you publish, Duaer polls Google Sheets on the Poll Times schedule.

Which credential does Google Sheets Trigger use in Duaer?

Duaer's Google Sheets Trigger uses Google Service Account API or Google Sheets Trigger OAuth2 API, depending on the method you choose under Authentication.

In this section