ClickUp + PostgreSQL

Update tasks in ClickUp when new rows are added in PostgreSQL with a custom query

Keep your tasks in ClickUp up-to-date with this simple workflow. Whenever a new row is added with a custom query in PostgreSQL, this automation updates the respective task in ClickUp immediately. Stay on top of your tasks without any manual hustle, making your project management seamless and efficient.

When this happens...
New Row (Custom Query)
Triggers when new rows are returned from a custom query that you provide. Advanced Users Only.
TriggerPolling
automatically do this!
Update Task
Updates an existing task.
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

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

- WorkspaceRequired
Trigger
Instant
Try It
- WorkspaceRequired
Trigger
Instant
Try It

- WorkspaceRequired
Trigger
Instant
Try It
- Task
- Include subtask?
- Fetch task data?
Trigger
Instant
Try It
- WorkspaceRequired
Trigger
Instant
Try It
- WorkspaceRequired
Action
Write
- Message TextRequired
- Include a link to this Zap?
Action
Write
- Document name (title)
- Subtitle
- Markdown Content
- Content
- Visibility
Action
Write
- WorkspaceRequired
Action
Write
- WorkspaceRequired
- Folder NameRequired
Action
Write
- WorkspaceRequired
- CommentRequired
- Include a link to this Zap?
Action
Write
- WorkspaceRequired
- FileRequired
Action
Write
- WorkspaceRequired
- Task NameRequired
- Custom task type
Action
Write
- Task IdRequired
Action
Write
- WorkspaceRequired
Action
Write
Find Custom Fields
View the Custom Fields available on tasks in a specific Team / Space / Folder / List.
Action
Search
Find a List of All Tasks
Finds a list of all tasks created in Workspace/Space/Folder/List. Supports Custom Fields.
Action
Search
- Check Plan Bandage
- WorkspaceRequired
- FieldRequired
- ValueRequired
- Include all shared items?
Action
Search

- Table/ViewRequired
- Order By
- Dedupe Key
Trigger
Polling
Try It
New Table
Triggers when you add a new table.
Trigger
Polling
Try It
- TableRequired
Action
Write
- TableRequired
- Lookup ColumnRequired
- Lookup ValueRequired
Action
Search
- QueryRequired
Action
Search
- Reaction(s)
- WorkspaceRequired
Trigger
Instant
Try It
- WorkspaceRequired
Trigger
Instant
Try It
- WorkspaceRequired
Trigger
Instant
Try It
- Reaction(s)
- WorkspaceRequired
Trigger
Instant
Try It
- WorkspaceRequired
Trigger
Instant
Try It
- WorkspaceRequired
- Checklist NameRequired
- Checklist ItemRequired
Action
Write
- WorkspaceRequired
- Thread
- Include a link to this Zap?
Action
Write
- DocumentRequired
- Name
- Content
- Subtitle
Action
Write
- Field nameRequired
- Description
- Required in tasks
- Pinned
- Visible to guests
Action
Write
- WorkspaceRequired
- List NameRequired
Action
Write
- WorkspaceRequired
- StartRequired
- EndRequired
Action
Write
- WorkspaceRequired
- Task NameRequired
- Custom task type
- Task Description
- Markdown Content
- Assignee Emails
- Priority
- Start Date
- Due Date
Action
Write
- WorkspaceRequired
Action
Write
- Name
- Subtitle
- DocumentRequired
- PageRequired
- Content
- Content edit mode
Action
Write
- Stop on errorRequired
- HTTP MethodRequired
- URLRequired
- Query string parameters
- Additional request headers
- Body
Action
Write
Find the Most Recent Task
Find the most recent task created in Workspace/Space/Folder/List.
Action
Search
Find Task by ID
Find an existing task by its ID.
Action
Search
- WorkspaceRequired
- Space
- Folder
- List
- Document nameRequired
- Name match condition
- Include archived documents?
Action
Search

About ClickUp

ClickUp is a productivity platform that allows you to manage your work and personal tasks in a beautifully intuitive environment.

Learn more

Related categories

Project Management

Similar apps

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