Top companies trust Zapier to automate work that solves their unique business problems—no coding required.
How Zapier works
Zapier makes it easy to integrate Google BigQuery with Salesforce - no code necessary. See how you can get setup in minutes.
100%
Help
Google BigQuery
Google BigQuery
1. Choose trigger event
Salesforce
Salesforce
2. Choose action
1. Select the event
Setup
Test
Google BigQuery
Choose a trigger event
Choose a trigger
A trigger is the event that starts your Zap—like a "Query Job Completed (With Row Data)" from Google BigQuery.
Add your action
An action happens after the trigger—such as "Add Contact to Campaign" in Salesforce.
You’re connected!
Zapier seamlessly connects Google BigQuery and Salesforce, automating your workflow.
Supported triggers and actions
Zapier helps you create workflows that connect your apps to automate repetitive tasks. A trigger is an event that starts a workflow, and an action is an event a Zap performs.
Create a new record or update an existing record in your app.
Campaign
Required
Lead
Required
Action
This is an event a Zap performs.
Write
Create a new record or update an existing record in your app.
Lead
Required
Account
Required
Opportunity
Create new opportunity?
Converted Status
Required
Action
This is an event a Zap performs.
Write
Create a new record or update an existing record in your app.
Parent Object
Required
Use Assignment Rules
Action
This is an event a Zap performs.
Write
Create a new record or update an existing record in your app.
Note Title
Required
Note Content
Required
Salesforce Object
Action
This is an event a Zap performs.
Write
Create a new record or update an existing record in your app.
Use Assignment Rules
Action
This is an event a Zap performs.
Write
Create a new record or update an existing record in your app.
Salesforce Object
Required
Use Assignment Rules
Allow Duplicates
Action
This is an event a Zap performs.
Write
Create a new record or update an existing record in your app.
Warning
Salesforce Object
Required
Record ID
Required
Action
This is an event a Zap performs.
Write
Create a new record or update an existing record in your app.
Report
Required
Include details
Number of custom filters
Row groupings
Column groupings
Summary calculations
Detail columns
Sort order
Report format
Advanced report options
Action
This is an event a Zap performs.
Write
Create a new record or update an existing record in your app.
Contact to Update
Required
Action
This is an event a Zap performs.
Write
Create a new record or update an existing record in your app.
Salesforce Object
Required
Record to Update
Required
Use Assignment Rules
Action
This is an event a Zap performs.
Write
Create a new record or update an existing record in your app.
Stop on error
Required
HTTP Method
Required
URL
Required
Query string parameters
Additional request headers
Body
Action
This is an event a Zap performs.
Write
Create a new record or update an existing record in your app.
SOSL Query
Required
Action
This is an event a Zap performs.
Search
Find existing data in your app
Salesforce Object
Required
Search Value
Required
Second Field to Search By
Second Search Value
Search Operator
Action
This is an event a Zap performs.
Search
Find existing data in your app
Salesforce Object
Required
Action
This is an event a Zap performs.
Search
Find existing data in your app
Salesforce Object
Required
Record ID
Required
Action
This is an event a Zap performs.
Search
Find existing data in your app
Salesforce Object
Required
SOQL WHERE Clause
Required
Sort by
Sort Order
Maximum Number of Records
Use Assignment Rules
Allow Duplicates
Action
This is an event a Zap performs.
Search or write
Find existing data in your app, or create a new record if no data is found
For AI agents & developers
Use Google BigQuery and Salesforce with AI agents and code
Beyond Zap workflows. Call Google BigQuery and Salesforce actions directly from your AI client or your codebase, using the same 9,000+ app integrations Zapier already runs.
No code
Connect via Zapier MCP
Expose Google BigQuery and Salesforce actions as tools in any MCP client. Authenticate once, then call them in natural language.
Example actions on this page
Create Row
Add Contact to Campaign
Works with
Claude · ChatGPT · Cursor · any MCP-compatible client
There is no Python package yet. SDK is TypeScript-only (@zapier/zapier-sdk). The MCP server URL is personal to your account; get it at zapier.com/mcp.
Zapier is the automation platform of choice for 87% of Forbes Cloud 100 companies in 2023
93%
Customers who say using Zapier has made them better at their job
25m
Customers have created over 25 million Zaps on the platform
6 mins
The average user takes less than 6 minutes to set up a Zap
Connect Google BigQuery and Salesforce to integrate crucial parts of your business
With Zapier, you can integrate everything from basic data entry to end-to-end processes. Here are some of the business-critical workflows that people automate with Zapier.
Automate your lead management and improve conversions
With Zapier, you can automate every part of your lead funnel and give yourself the best chance at converting leads. Automate everything from lead capture to outreach to reporting—and close more deals as a result.
Create more impactful campaigns with automation
Measuring campaign performance across platforms can get chaotic. Plus, digging up the right metrics costs you precious time and effort. With Zapier, you can create a centralized view of your performance, skillfully manage your lists, and ensure your campaigns drive ROI across the business.
Provide world-class support with a little help from automation
Support reps can't be productive when they have to track down crucial information for every incident or ticket. With Zapier, you can automatically send your reps the context they need to resolve tickets quickly and create a seamless customer experience.
Automate your way to actionable, up-to-date data
The days of manually exporting and importing data are over. With Zapier, you can send data where it needs to go, in the format you need it—so you can centralize your data and unlock more insights.
Resolve incidents faster with automation
Your technical support team wants to focus on tech tickets rather than admin work. With Zapier, you can automate everything from ticket creation to routing to inter-team communication—eliminating friction from incident management and increasing speed to resolution.
Learn how to automate Google BigQuery on the Zapier blog
Learn how to automate Salesforce on the Zapier blog
Make work flow with AI
Level up your Google BigQuery to Salesforce integration with AI. Extract, summarize, and transform your integration data with leading AI models like OpenAI, Anthropic, and more.
Frequently Asked Questions about Google BigQuery + Salesforce integrations
New to automation with Zapier? You're not alone. Here are some answers to common questions about how Zapier works with Google BigQuery and Salesforce
What do I need to integrate Google BigQuery with Salesforce?
To integrate Google BigQuery with Salesforce, you need access to both accounts with permission to create and manage data connections. You also need a third-party integration tool or middleware that supports both platforms for data synchronization and automation of workflows.
How can I automate data transfer from Salesforce to Google BigQuery?
We can automate data transfer from Salesforce to Google BigQuery by setting up triggers in Salesforce that activate specific actions in Google BigQuery. This often involves using an integration platform that can listen for changes or updates in Salesforce and automatically update records in BigQuery, ensuring real-time synchronization.
Can I trigger updates in Salesforce based on changes in Google BigQuery?
Yes, it's possible to trigger updates in Salesforce based on changes detected in Google BigQuery. This typically involves setting up scheduled queries or monitoring specific datasets for changes, which then trigger actions back into Salesforce via an integration service.
What types of data can I sync between Google BigQuery and Salesforce?
You can sync various types of data between these platforms including customer profiles, sales records, marketing campaign data, and any other structured datasets. The key is defining clear mappings and transformations needed during the integration process to ensure seamless data flow.
Do I need coding skills to set up the integration between Google BigQuery and Salesforce?
While having coding skills can be beneficial for troubleshooting or customizing integrations, many platforms offer user-friendly interfaces with pre-built templates that allow you to set up the integration without extensive coding knowledge.
How often is the data updated between Google BigQuery and Salesforce during the integration?
The frequency of updates depends on how you configure your triggers and actions. This could range from real-time updates triggered by specific events to periodic batch processing schedules depending on your needs.
Are there any limitations when integrating Google BigQuery with Salesforce?
Some limitations may include API call limits of both platforms, possible delays due to high volumes of data transfer, and restrictions based on your tier of service or plan. It's crucial to evaluate these factors when planning your integration strategy.
About Google BigQuery
BigQuery is Google's serverless and highly scalable enterprise data warehouse, designed to make all your data analysts productive.
