Connect PostgreSQL to Pipedrive

Use 5 documented PostgreSQL triggers to run 24 documented Pipedrive actions.

5 source triggers

24 target actions

Reverse direction supported

Start Free Trial Browse PostgreSQL integrations

Why Connect PostgreSQL & Pipedrive?

Start with a PostgreSQL event

Choose from 5 documented triggers, including New Column, New or Updated Row, New Row.

Run a Pipedrive action

Send the event into one of 24 documented actions, such as Add Activity, Add Deal, Add Labels.

Map and review the workflow

Choose the fields and conditions for the workflow, then test the result before activation.

Available Triggers & Actions

PostgreSQL

Triggers (5)

New Column

Emit new event when a new column is added to a table. See the documentation

polling

New or Updated Row

Emit new event when a row is added or modified. See the documentation

polling

New Row

Emit new event when a new row is added to a table. See the documentation

polling

New Row Custom Query

Emit new event when new rows are returned from a custom query that you provide. See the documentation

polling

New Table

Emit new event when a new table is added to the database. See the documentation

polling

Actions (9)

Execute SQL Query

Execute a custom PostgreSQL query. See our docs to learn more about working with SQL in Mazaal AI.

Delete Row(s)

Deletes a row or rows from a table. See the documentation

Find Row

Finds a row in a table via a lookup column. See the documentation

Find Row With Custom Query

Finds a row in a table via a custom query. See the documentation

Insert Row

Adds a new row. See the documentation

List Schema Options

Retrieves available options for the Schema field.

Query SQL Database

Execute a SQL Query. See our docs to learn more about working with SQL in Mazaal AI.

Update Row

Updates an existing row. See the documentation

Upsert Row

Adds a new row or updates an existing row. See the documentation

Pipedrive

Triggers (6)

Deal Updated (Instant)

Emit new event when a deal is updated.

webhook

Lead Updated (Instant)

Emit new event when a lead is updated.

webhook

New Deal (Instant)

Emit new event when a new deal is created.

webhook

New Event (Instant)

Emit new event when a new webhook event is received. See the documentation

webhook

New Person (Instant)

Emit new event when a new person is created.

webhook

Person Updated (Instant)

Emit new event when a person is updated.

webhook

Actions (24)

Add Activity

Adds a new activity. Includes more_activities_scheduled_in_context property in response's additional_data which indicates whether there are more undone activities scheduled with the same deal, person or organization (depending on the supplied data). See the Pipedrive API docs for Activities here. For info on adding an activity in Pipedrive

Add Deal

Adds a new deal. See the Pipedrive API docs for Deals here

Add Labels

Adds labels to a lead, person, deal, or organization in Pipedrive. See the documentation

Add Lead

Create a new lead in Pipedrive. See the documentation

Add Note

Adds a new note. For info on adding an note in Pipedrive

Add Organization

Adds a new organization. See the Pipedrive API docs for Organizations here

Add Person

Adds a new person. See the Pipedrive API docs for People here

Get All Leads

Get all leads from Pipedrive. See the documentation

Get Deal

Get a deal by its ID. See the documentation

Get Lead by ID

Get a lead by its ID. See the documentation

Get person details

Get details of a person by their ID. See the documentation

List Deals

List deals in your Pipedrive account. See the documentation

List Lead Label IDs Options

Retrieves available options for the Lead Label IDs field.

List Organization Label IDs Options

Retrieves available options for the Organization Label IDs field.

List Person Label IDs Options

Retrieves available options for the Person Label IDs field.

List User ID Options

Retrieves available options for the User ID field.

Merge Deals

Merge two deals in Pipedrive. See the documentation

Merge Persons

Merge two persons in Pipedrive. See the documentation

Remove Duplicate Notes

Remove duplicate notes from an object in Pipedrive. See the documentation for getting notes and deleting notes

Remove Labels

Removes one or more specific labels from a lead, person, deal, or organization in Pipedrive, leaving all other labels intact. See the documentation

Search Leads

Search for leads by name or email. See the documentation

Search Notes

Search for notes in Pipedrive. See the documentation

Search persons

Searches all Persons by name, email, phone, notes and/or custom fields. This endpoint is a wrapper of /v1/itemSearch with a narrower OAuth scope. Found Persons can be filtered by Organization ID. See the Pipedrive API docs here

Update Deal

Updates the properties of a deal. See the Pipedrive API docs for Deals here