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
- On the Duaer canvas, open the node panel, search for Google Sheets Trigger, and add it as the first node.
- 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.
- Pick the events that should start a run, for example Row Added or Row Updated.
- Set Document and Sheet.
- If needed, select Add Option for the optional settings listed below.
- 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
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.