AppsPricingBlogTry it
Pipedrive logo
Snowflake logo

Connect Pipedrive to Snowflake

Build an AI agent that works across Pipedrive and Snowflake, on a schedule or when you click Run.

24 source actions
7 target actions
Reverse direction supported

Why Connect Pipedrive & Snowflake?

Read what you need from Pipedrive

Your agent uses Pipedrive's documented actions to pull the records it needs, each time it runs.

Run a Snowflake action

Then it uses one of 7 documented actions, such as Execute SQL Query, Insert Multiple Rows, Insert Single Row.

Test it, then put it on a schedule

Run it once on your own data and check the result. Then set it to run daily, on weekdays or weekly.

Available Triggers & Actions

Pipedrive logo

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

Snowflake logo

Snowflake

Triggers (12)

New Row

Emit new event when a row is added to a table

polling
New Query Results

Run a SQL query on a schedule, triggering a workflow for each row of results

polling
Failed Task in Schema

Emit new events when a task fails in a database schema

polling
New Database

Emit new event when a database is created

polling
New Deleted Role

Emit new event when a role is deleted

polling
New Deleted User

Emit new event when a user is deleted

polling
New Role

Emit new event when a role is created

polling
New Schema

Emit new event when a schema is created

polling
New Table

Emit new event when a table is created

polling
New Update Role

Emit new event when a role is updated

polling
New Update User

Emit new event when a user is updated

polling
New Usage Monitor

Emit new event when a query is executed in the specified params

polling

Actions (7)

Execute SQL Query

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

Insert Multiple Rows

Insert multiple rows into a table

Insert Single Row

Insert a row into a table

List Database Options

Retrieves available options for the Database field.

List User Name Options

Retrieves available options for the User Name field.

List Warehouse Name Options

Retrieves available options for the Warehouse Name field.

Query SQL Database

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

Integration Features

24 documented Pipedrive actions
7 documented Snowflake actions
Plain-English agent instructions
Daily, weekday or weekly schedule, or run on demand
Execution monitoring
A supported Snowflake to Pipedrive direction

Capability Examples

Pipedrive trigger → Snowflake action

Catalog example
PipedrivePipedrive

Deal Updated (Instant)

SnowflakeSnowflake

Execute SQL Query

Snowflake trigger → Pipedrive action

Reverse direction
SnowflakeSnowflake

New Row

PipedrivePipedrive

Add Activity

How It Works

1

Connect Apps

Authenticate your Pipedrive and Snowflake accounts

2

Describe the Job

Say what to read from Pipedrive and what to do in Snowflake

3

Choose an Action

Select the documented Snowflake operation to run

Test and Review

Verify field mapping and provider responses before activation

Frequently Asked Questions

Integration Benefits

Scheduled or On-demand Runs

Runs daily, on weekdays or weekly at a set time, or when you click Run. It does not fire on live Pipedrive events yet.

Automated Actions

Use 7 documented Snowflake actions each time the agent runs.

Provider Authentication

Review the authentication requirements published by each provider before activating the workflow.

Guided Configuration

Describe the job in plain English. The agent picks thePipedrive and Snowflake actions it needs.

Your Own Accounts

You connect your own Pipedrive and Snowflake accounts. App connections need a paid plan.

Execution Review

Test the workflow and review provider responses before relying on it in production.

Snowflake logoPipedrive logo

Reverse Integration Available

Also connect Snowflake to Pipedrive for bidirectional automation

View Integration
Pipedrive logo

All Pipedrive Integrations

Explore all available Pipedrive connections

View All Integrations
Snowflake logo

All Snowflake Integrations

Explore all available Snowflake connections

View All Integrations

Ready to Connect Pipedrive & Snowflake?

Build this agent in Mazaal AI and test it on your ownPipedrive and Snowflake data.

Start building

Rather not build it yourself? We set up one Pipedrive to Snowflake agent on your accounts for A$490: a 30-minute call, a test on your real data, and 14 days of fixes. Plan billed separately. Email Enod