PostgreSQL + Zendesk

Create Zendesk tickets from new PostgreSQL query rows

With this workflow, whenever a new row crops up in your PostgreSQL database from a custom query, a ticket gets instantly created in Zendesk. This time-saving process ensures speedy ticket creation, minimizing the lag between data update in PostgreSQL and ticket creation in Zendesk. Enhance productivity and issue management in your customer support process with this effective automation.

When this happens...
New Row (Custom Query)
Triggered when new rows are returned from a custom query that you provide. Advanced Users Only
TriggerScheduled
automatically do this!
Create Ticket
Triggers when a new ticket is added (Zendesk may take an hour to make tickets available via their API with this trigger).
ActionWrite

Start free with email

Start free with Google

Start free with email

Start free with Google

Free forever for core features
14 day trial for premium features & apps

Supported triggers and actions

What does this mean?

- Table/ViewRequired
Trigger
Scheduled
Try It
- QueryRequired
Trigger
Scheduled
Try It
- Table/ViewRequired
- Primary KeyRequired
- Order ByRequired
- Trigger Column
Trigger
Scheduled
Try It
- TableRequired
- ID ColumnRequired
Action
Write
- QueryRequired
Action
Search

New Group
Triggers when a new group is created.
Trigger
Scheduled
Try It
- Organization
Trigger
Scheduled
Try It

New Organization
Triggers when a new organization is created.
Trigger
Scheduled
Try It
- Organization
Trigger
Scheduled
Try It
New View
Triggers when a new view is created.
Trigger
Scheduled
Try It
- NameRequired
- Details
- Notes
- Tags
- Domain Names
- External Id
- Group Id
- Shared Tickets
- Shared Comments
Action
Write
- SubjectRequired
- Assignee
- Collaborators
- Collaborator Emails
- Group
- Requester Name
- Requester Email
- First Comment/Description format
- First Comment/DescriptionRequired
- Should the first Comment be public?
- Tags
- Status
- Type
- Priority
- Submitter
- Ticket form
- Sharing Agreements
- Brand
- External ID
- Email CC
- Attachment
Action
Write
- TicketRequired
- Comment body
- Comment format
- Should the Comment be public?
Action
Write
- OrganizationRequired
- Name
- Details
- Notes
- Tags
- Domain Names
- External Id
- Shared Tickets
- Shared Comments
Action
Write
- UserRequired
- Name
- Email
- Details
- Notes
- Phone
- Tags
- Role
- Organization
- External Id
- Verified
Action
Write
- HTTP MethodRequired
- URLRequired
- Query String Parameters
- Headers
- Additional Request Headers
- Body
Action
Write
- Info
- Type
Action
Search
- Ticket IdRequired
Action
Search
- QueryRequired
Action
Search
- QueryRequired
- NameRequired
- Details
- Notes
- Tags
- Domain Names
- External Id
- Group Id
- Shared Tickets
- Shared Comments
Action
Search or write

- Table/ViewRequired
- Order By
- Dedupe Key
Trigger
Scheduled
Try It
New Table
Triggered when you add a new table.
Trigger
Scheduled
Try It
- TableRequired
Action
Write
- TableRequired
- Lookup ColumnRequired
- Lookup ValueRequired
Action
Search
- QueryRequired
Action
Search
- ViewRequired
Trigger
Scheduled
Try It
- Tags
Trigger
Instant
Try It
- Ticket (Required for non-admins)
Trigger
Scheduled
Try It
New User
Triggers when a new user is created.
Trigger
Scheduled
Try It
- UserRequired
- user_delete_copy
- Permanent Deletion
- user_delete_test_copy
Action
Write
- TicketRequired
- TagsRequired
Action
Write
- TicketRequired
- CommentRequired
- Should the comment be public?
- FileRequired
Action
Write
- TicketRequired
- TagsRequired
Action
Write
- TicketRequired
- Subject
- Assignee
- Group
- New status
- New Comment to add to the Ticket
- New Comment format
- Should the new Comment be public?
- Tags
- Additional Tags
- Remove Tags
- Type
- Priority
- Submitter
- Brand
- External ID
- Requester
- Sharing Agreements
- Ticket form
- Collaborators
- Collaborator Emails
- Email CC
- Attachment
Action
Write
- NameRequired
- Email
- Details
- Notes
- Phone
- Tags
- Role
- Organization
- External Id
- Verified
Action
Write
- QueryRequired
Action
Search
- QueryRequired
Action
Search
- QueryRequired
Action
Search
- Info
- Type
- SubjectRequired
- Assignee
- Collaborators
- Collaborator Emails
- Group
- Requester Name
- Requester Email
- First Comment/Description format
- First Comment/DescriptionRequired
- Should the first Comment be public?
- Tags
- Status
- Priority
- Submitter
- Ticket form
- Sharing Agreements
- Brand
- External ID
- Email CC
- Attachment
Action
Search or write
- QueryRequired
- NameRequired
- Email
- Details
- Notes
- Phone
- Tags
- Role
- Organization
- External Id
- Verified
Action
Search or write

About PostgreSQL

PostgreSQL is a powerful, open-source database engine with a uniquely advanced query optimizer and dozens of built in features, making it an easy choice for production databases.

Learn more