Integrations
Common issues with Google Sheets Trigger in Duaer
Common Google Sheets Trigger issues in Duaer: stuck while testing, and dates shown as numbers.
Stuck waiting for a trigger event
When you test Google Sheets Trigger in the editor, Duaer pushes results back to the page over WebSocket. If a self-hosted Duaer sits behind a reverse proxy that does not forward WebSocket, the page keeps waiting.
Turn on WebSocket forwarding in your proxy (Nginx, Caddy, Traefik, and so on). If you cannot, set DUAER_PUSH_BACKEND to sse. Then close and reopen the digital organization.
Date and time columns show as numbers
By default dates come out as serial numbers: the whole part is days since 1899-12-30 and the fraction is the time of day (0.5 is noon). With Trigger On set to Row Added, add DateTime Render under Options and set it to Formatted String to get the text as formatted in the sheet.
Questions
Why does the Duaer Google Sheets Trigger output dates as numbers?
Duaer outputs dates as serial numbers by default. With Trigger On set to Row Added, set DateTime Render to Formatted String.
In this section
Built-in integrations in Duaer
Built-in triggers, actions, and credentials in Duaer. Triggers start a digital organization. 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.