Google BigQuery + Pipedrive
Run a query in Google BigQuery for new organizations in Pipedrive
Begin streamlining your sales process when a new organization is added in Pipedrive. This integrative workflow will promptly execute a query in Google BigQuery without requiring any manual intervention. It's an efficient strategy to maintain continuously updated data analytics, helping your sales team work smarter and faster.
Begin streamlining your sales process when a new organization is added in Pipedrive. This integrative workflow will promptly execute a query in Google BigQuery without requiring any manual intervention. It's an efficient strategy to maintain continuously updated data analytics, helping your sales team work smarter and faster.
- When this happens...
New OrganizationTriggers when a new organization is created.
TriggerInstantThis event starts a Zap instantly. - automatically do this!
Run a QueryRuns a SQL query against a table in BigQuery.
ActionWriteCreate a new record or update an existing record in your app.
- Free forever for core features
- 14 day trial for premium features & apps
Copy
FilterRequired
Deal status
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free plan
New Lead
Triggers when a lead is created.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planNew Note
Triggers when a new note is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Organization
Triggers when a new organization is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Deleted Person
Triggers when an existing person is deleted.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Filter ID
Status
Board ID
Phase ID
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planFilter By
Field to Watch for Changes On
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Person IDRequired
Label IDRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Product IDRequired
Product Variation IDRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.TitleRequired
Status
Stage
Stage Warning
Pipeline
Deal Owner
Associated Organization ID
Associated Person ID
Probability
Expected Close Date
Deal Value
Currency
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Follower User IDRequired
Choose where to add the followerRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.ContentRequired
Deal ID
Pin note to deal
Person ID
Pin note to person
Organization ID
Project ID
Pin note to organization
Lead ID
Pin note to lead
Pin note to project
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Person Name
Email Addresses
Phone Numbers
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.TitleRequired
Project Template
Project BoardRequired
Project PhaseRequired
Description
Status
Owner
Start Date
End Date
Deals
Organization ID
Person ID
Labels
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.DealRequired
Remove All Existing Labels?
Labels to Remove
Labels to Add
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Copy Null
Deal IDRequired
Title
Status
Stage
Pipeline
Deal Owner
Associated Organization ID
Associated Person ID
Probability
Expected Close Date
Deal Value
Currency
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Organization to UpdateRequired
Organization Name
Organization Address
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Copy Null
Product IDRequired
Product Name
Product Code
Description
Unit
Tax percentage
Category
Owner User ID
Is Linkable
Currency
Price
Direct cost
Overhead Cost
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.TaskRequired
Title
Project ID
Description
Done
Due Date
Assignee
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Activity Subject
Search Type
Activity Owner
Activity Filter
Completion Status
ActionThis is an event a Zap performs.SearchFind existing data in your appSearch type
Include file data
ActionThis is an event a Zap performs.SearchFind existing data in your appOrganization ID
Organization Items
Include Persons
Include Deals
Include Activities
ActionThis is an event a Zap performs.SearchFind existing data in your appSearch for an Exact Match?
ActionThis is an event a Zap performs.SearchFind existing data in your appSearch ByRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appSearch type
ActionThis is an event a Zap performs.SearchFind existing data in your appProject IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appSearch TermRequired
Exact Match?
Assignee
Project
Status
ActionThis is an event a Zap performs.SearchFind existing data in your appActivity Subject
Search Type
Activity Owner
Activity Filter
Mark as Done
Organization ID
Deal ID
Lead ID
Project ID
Activity Type
Use Combined Date and Time Field?
Duration
Mark as Busy
Note
Public Description
Primary Participant
Additional Participants
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundSearch type
Organization NameRequired
Organization Address
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundSearch type
Product NameRequired
Product Code
Description
Unit
Tax percentage
Category
Owner User ID
Is Linkable
Currency
Price
Direct cost
Overhead Cost
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundSearch TermRequired
Exact Match?
Assignee
Project IDRequired
Done
TitleRequired
Description
Due Date
Parent Task ID
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundProject IDRequired
DatasetRequired
TableRequired
Sort By ColumnRequired
Unique ColumnRequired
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planProject IDRequired
DatasetRequired
TableRequired
Unique ColumnRequired
IS Operator
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planProjectRequired
DatasetRequired
TableRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Project IDRequired
DatasetRequired
TableRequired
RowsRequired
Skip Invalid Rows
Ignore Unknown Values
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Project IDRequired
DatasetRequired
TableRequired
Where ColumnRequired
Where ValueRequired
Update ColumnsRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Project IDRequired
DatasetRequired
TableRequired
Sort By Column
Sort Direction
Where ClauseRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appProjectRequired
DatasetRequired
TableRequired
Sort By Column
Sort Direction
Where ClauseRequired
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is found
New Activity
Triggers when a new activity is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Deal
Triggers when a new deal is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.New Person
Triggers when a new person is created.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.DealRequired
Discount DescriptionRequired
Discount AmountRequired
Discount TypeRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Deal IDRequired
Add Multiple Products?
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Activity Subject
Activity Owner
Organization ID
Deal ID
Lead ID
Project ID
Mark as Done
Activity Type
Use Combined Date and Time Field?
Duration
Mark as Busy
Note
Public Description
Primary Participant
Additional Participants
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.FileRequired
File Name
Deal ID
Person ID
Organization ID
Product ID
Activity ID
Note ID
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.TitleRequired
Person ID
Organization ID
Owner User ID
Note
Pin note to lead
Label ID(s)
Expected Close Date
Lead Value
Lead Value Currency Code
Source Channel ID
Source Channel ID
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Organization NameRequired
Organization Address
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Product NameRequired
Product Code
Description
Unit
Tax percentage
Category
Owner User ID
Is Linkable
Currency
Price
Direct cost
Overhead Cost
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.TitleRequired
Project IDRequired
Description
Done
Due Date
Assignee
Parent Task ID
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Activity to UpdateRequired
Activity Subject
Activity Owner
Organization ID
Deal ID
Lead ID
Project ID
Mark as Done
Activity Type
Use Combined Date and Time Field?
Duration
Mark as Busy
Note
Public Description
Primary Participant
Additional Participants
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Lead IDRequired
Title
Owner User ID
Organization ID
Person ID
Label ID(s)
Expected Close Date
Lead Value
Lead Value Currency Code
Source Channel ID
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Copy Null
Person to UpdateRequired
Person Name
Email Addresses
Phone Numbers
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.ProjectRequired
Title
Project Board
Project Phase
Description
Status
Owner
Start Date
End Date
Deals
Organization ID
Person ID
Labels
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Stop on errorRequired
HTTP MethodRequired
URLRequired
Query string parameters
Additional request headers
Body
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.PersonRequired
Include file data
ActionThis is an event a Zap performs.SearchFind existing data in your appDeal IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appStage IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appNote IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appSearch type
ActionThis is an event a Zap performs.SearchFind existing data in your appSearch type
ActionThis is an event a Zap performs.SearchFind existing data in your appField to Search ByRequired
Search TermRequired
Exact Match
ActionThis is an event a Zap performs.SearchFind existing data in your appField to search byRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appSearch type
Include file data
TitleRequired
Status
Stage
Stage Warning
Pipeline
Deal Owner
Associated Organization ID
Associated Person ID
Probability
Expected Close Date
Deal Value
Currency
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundSearch type
Person Name
Email Addresses
Phone Numbers
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundField to Search ByRequired
Search TermRequired
Exact Match
TitleRequired
Project Template
Project BoardRequired
Project PhaseRequired
Description
Status
Owner
Start Date
End Date
Deals
Organization ID
Person ID
Labels
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundProjectRequired
Dataset
Table
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planProject IDRequired
Job IDRequired
LocationRequired
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planProjectRequired
DatasetRequired
TableRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Project IDRequired
DatasetRequired
TableRequired
Where ColumnRequired
Where ValueRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Project IDRequired
SQL QueryRequired
Location
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Stop on errorRequired
HTTP MethodRequired
URLRequired
Query string parameters
Additional request headers
Body
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Project IDRequired
Job IDRequired
LocationRequired
ActionThis is an event a Zap performs.SearchFind existing data in your app
About Google BigQuery
About Pipedrive
Related categories
Related Zap Templates
- Create Google BigQuery rows from new deals on Pipedrive
- Create rows in Google BigQuery when deal stages are updated in Pipedrive
- Add new Pipedrive leads to Google BigQuery as rows
- Add rows to Google BigQuery for new Pipedrive activities
- Create new rows in Google BigQuery when deals get updated in Pipedrive