Pipedrive + PostgreSQL

Update deals in Pipedrive when new rows are added to PostgreSQL via custom query

Stay on top of your business deals with this efficient workflow! It starts working as soon as you have a new result from a custom query in your PostgreSQL database. Then, it swiftly updates the relevant deal in your Pipedrive account. It's a perfect solution to ensure data consistency between both platforms and helps you manage your deals promptly, saving you precious time and effort.

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!
Update Deal
Updates an existing deal.
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

- Filter IdRequired
Trigger
Scheduled
Try It
- FilterRequired
- Deal Status
Trigger
Scheduled
Try It

New Note
Triggers when a new note is created.
Trigger
Scheduled
Try It
- FilterRequired
Trigger
Scheduled
Try It
- FilterRequired
Trigger
Scheduled
Try It
Updated Deal
Triggers when an existing deal is updated.
Trigger
Instant
Try It
- Person Fields
Trigger
Instant
Try It
- DealRequired
- ProductRequired
- PriceRequired
- QuantityRequired
- Discount
- Discount Type
- Comments
- Is enabled?
- Tax Method
- Tax Percentage
Action
Write
- TitleRequired
- Creation Date
- Status
- Stage
- Stage Warning
- Pipeline
- Owner
- Organization
- Person
- Probability
- Expected Close Date
- Value
- Currency
Action
Write
- FollowerRequired
- What to add follower to?Required
Action
Write
- ContentRequired
- Deal
- Pin note on specified deal?
- Person
- Pin note on specified person?
- Organization
- Pin note on specified organization?
- Lead
- Pin note on specified lead?
Action
Write
- NameRequired
- Owner
- Organization
- Email
- Phone
Action
Write
- ActivityRequired
- Subject
- Organization
- Assign To
- Person
- Deal
- Lead
- Is Done?
- Type
- Use combined date and time field?
- Duration
- Free/Busy
- Note
- Public Description
Action
Write
- LeadRequired
- Title
- Owner
- Organization
- Person
- Label
- Expected Close Date
- Lead Value
- Lead Value Currency
Action
Write
- PersonRequired
- Name
- Owner
- Organization
- Email
- Phone
Action
Write
- SubjectRequired
- Search Type
- Assigned To
- Type
- Filter
- Status
Action
Search
- Field to Search By
- Term to search forRequired
- Search for an Exact Match?
Action
Search
- Search for an Exact Match?
Action
Search
- Search termRequired
Action
Search
- Field to Search ByRequired
Action
Search
- Search for an Exact Match?
- TitleRequired
- Creation Date
- Status
- Stage
- Stage Warning
- Pipeline
- Owner
- Organization
- Person
- Probability
- Expected Close Date
- Value
- Currency
Action
Search or write
- Search for an Exact Match?
- TitleRequired
- Person
- Organization
- Owner
- Note
- Pin Note to Lead?
- Label
- Expected Close Date
- Lead Value
- Lead Value Currency
Action
Search or write
- Search for an Exact Match?
- NameRequired
- Owner
- Organization
- Email
- Phone
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
New Activity
Triggers when a new activity is created.
Trigger
Scheduled
Try It
New Deal
Triggers when a new deal is created.
Trigger
Instant
Try It
New Lead
Triggers when a Lead is created.
Trigger
Scheduled
Try It
New Organization
Triggers when a new organization is created.
Trigger
Scheduled
Try It
New Person
Triggers when a new person is created.
Trigger
Scheduled
Try It
- Stage in Pipeline
Trigger
Instant
Try It
Updated Organization
Triggers when an existing organization is updated.
Trigger
Scheduled
Try It
- PersonRequired
- LabelRequired
Action
Write
- SubjectRequired
- Organization
- Assign To
- Person
- Deal
- Lead
- Is done?
- Type
- Use combined date and time field?
- Duration
- Free/Busy
- Note
- Public Description
Action
Write
- FileRequired
- File NameRequired
- Deal
- Person
- Organization
- Product
- Activity ID
- Note ID
Action
Write
- TitleRequired
- Person
- Organization
- Owner
- Note
- Pin Note to Lead?
- Label
- Expected Close Date
- Lead Value
- Lead Value Currency
Action
Write
- NameRequired
- Owner
- Address
Action
Write
- NameRequired
- Code
- Unit
- Tax percentage
- Is active?
- Owner
- Currency
- Price
- Cost
- Overhead Cost
Action
Write
- DealRequired
- Title
- Status
- Stage
- Owner
- Organization
- Person
- Value
- Currency
Action
Write
- OrganizationRequired
- Owner
- Name
- Address
Action
Write
- Api Docs Info
- HTTP MethodRequired
- URLRequired
- Query String Parameters
- Headers
- Additional Request Headers
- Body
Action
Write
- Search for an Exact Match?
Action
Search
- Search for an Exact Match?
Action
Search
- Search for an Exact Match?
Action
Search
Find Product(s)
Finds a product or products by name, ID, or product code (with line item support).
Action
Search
- SubjectRequired
- Search Type
- Assign To
- Type
- Filter
- Is done?
- Organization
- Person
- Deal
- Lead
- Use combined date and time field?
- Duration
- Free/Busy
- Note
- Public Description
Action
Search or write
- Field to Search By
- Term to search forRequired
- Search for an Exact Match?
- TitleRequired
- Creation Date
- Status
- Stage
- Stage Warning
- Pipeline
- Owner
- Organization
- Person
- Probability
- Expected Close Date
- Value
- Currency
Action
Search or write
- Search for an Exact Match?
- NameRequired
- Owner
- Address
Action
Search or write
- Search termRequired
- NameRequired
- Code
- Unit
- Tax percentage
- Is active?
- Owner
- Currency
- Price
- Cost
- Overhead Cost
Action
Search or write

About Pipedrive

Pipedrive is sales pipeline and CRM software for deal makers. Get super-organized. Close deals in less time. iOS and Android apps let you take your pipeline with you anywhere.

Learn more Help

Related categories

CRM (Customer Relationship Management)

Similar apps

Zoho CRM

CRM (Customer Relationship Management), Zoho

Zendesk Sell

CRM (Customer Relationship Management)

Agile CRM

CRM (Customer Relationship Management)

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 Help

Related categories

Databases

Similar apps

MySQL

Databases

SQL Server

Databases

Amazon Relational Database Services (RDS)

Amazon, Databases

PRODUCTS

CAPABILITIES

By team

Pipedrive + PostgreSQL

Update deals in Pipedrive when new rows are added to PostgreSQL via custom query

New Column

New Row (Custom Query)

QueryRequired

New or Updated Row

Table/ViewRequired

Primary KeyRequired

Order ByRequired

Trigger Column

Update Row

TableRequired

ID ColumnRequired

Find Row via Custom Query

QueryRequired

Activity Matching Filter

Filter IdRequired

Deal Matching Filter

FilterRequired

Deal Status

New Note

Organization Matching Filter

FilterRequired

Person Matching Filter

FilterRequired

Updated Deal

Updated Person

Person Fields

Add Product to Deal

DealRequired

ProductRequired

PriceRequired

QuantityRequired

Discount

Discount Type

Comments

Is enabled?

Tax Method

Tax Percentage

Create Deal

TitleRequired

Creation Date

Status

Stage

Stage Warning

Pipeline

Owner

Organization

Person

Probability

Expected Close Date

Value

Currency

Add Follower

FollowerRequired

What to add follower to?Required

Create Note

ContentRequired

Deal

Pin note on specified deal?

Person

Pin note on specified person?

Organization

Pin note on specified organization?

Lead

Pin note on specified lead?

Create Person

NameRequired

Owner

Organization

Email

Phone

Update Activity

ActivityRequired

Subject

Organization

Assign To