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 HubSpot - no code necessary. See how you can get setup in minutes.
100%
Help
Google BigQuery
Google BigQuery
1. Choose trigger event
HubSpot
HubSpot
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 "Update Contact Subscription Preferences" in HubSpot.
You’re connected!
Zapier seamlessly connects Google BigQuery and HubSpot, 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.
Halt my task if contact is already a member of the list
Action
This is an event a Zap performs.
Write
Create a new record or update an existing record in your app.
Create Company
Creates a Company in HubSpot.
Action
This is an event a Zap performs.
Write
Create a new record or update an existing record in your app.
Create Associations
Creates associations between objects.
Action
This is an event a Zap performs.
Write
Create a new record or update an existing record in your app.
Note
Halt task if any associations error occurred
Engagement Type
Required
Assigned To
Action
This is an event a Zap performs.
Write
Create a new record or update an existing record in your app.
Note
Social Media Channel
Required
Message Content
Required
When
Save as draft
Action
This is an event a Zap performs.
Write
Create a new record or update an existing record in your app.
Note
Note
Name
Required
Company
Contact
Action
This is an event a Zap performs.
Write
Create a new record or update an existing record in your app.
Delete CRM Object
Deletes a CRM object from HubSpot
Action
This is an event a Zap performs.
Write
Create a new record or update an existing record in your app.
Company ID
Required
Note
Additional properties to retrieve
Action
This is an event a Zap performs.
Write
Create a new record or update an existing record in your app.
Type of Custom Object
Required
Action
This is an event a Zap performs.
Write
Create a new record or update an existing record in your app.
Note
Action
This is an event a Zap performs.
Write
Create a new record or update an existing record in your app.
Product ID
Required
Note
Additional properties to retrieve
Action
This is an event a Zap performs.
Write
Create a new record or update an existing record in your app.
Create Line_item
Creates a Line_item in HubSpot.
Action
This is an event a Zap performs.
Write
Create a new record or update an existing record in your app.
Note
Contact Email Address
Required
Event ID
Required
Contact Value
Action
This is an event a Zap performs.
Write
Create a new record or update an existing record in your app.
Get CRM Object
Gets a CRM object from HubSpot by ID
Action
This is an event a Zap performs.
Write
Create a new record or update an existing record in your app.
Note
List Name
Required
Contact
Required
Halt my task if contact wasn't a member of the list
Required
Action
This is an event a Zap performs.
Write
Create a new record or update an existing record in your app.
Create Ticket
Creates a Ticket in HubSpot.
Action
This is an event a Zap performs.
Write
Create a new record or update an existing record in your app.
Update Contact
Update a Contact in HubSpot.
Action
This is an event a Zap performs.
Write
Create a new record or update an existing record in your app.
Update Line_item
Update a Line_item in HubSpot.
Action
This is an event a Zap performs.
Write
Create a new record or update an existing record in your app.
Update Product
Update a Product in HubSpot.
Action
This is an event a Zap performs.
Write
Create a new record or update an existing record in your app.
Type of Custom Object
Required
Action
This is an event a Zap performs.
Write
Create a new record or update an existing record in your app.
Folder
Required
Filename
Required
Access level
Required
File
Required
Action
This is an event a Zap performs.
Write
Create a new record or update an existing record in your app.
Api_docs_info
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.
Note
Name
Required
Action
This is an event a Zap performs.
Search
Find existing data in your app
Note
Additional properties to retrieve
Action
This is an event a Zap performs.
Search
Find existing data in your app
Note
Name
Required
Action
This is an event a Zap performs.
Search
Find existing data in your app
Find Associations
Find associations between objects.
Action
This is an event a Zap performs.
Search
Find existing data in your app
Object Type
Required
Pipeline Id
Required
Stage Id
Required
Action
This is an event a Zap performs.
Search
Find existing data in your app
Owner Id
Required
Search among deactivated owners
Action
This is an event a Zap performs.
Search
Find existing data in your app
Note
Additional properties to retrieve
Action
This is an event a Zap performs.
Search
Find existing data in your app
Note
Name
Required
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
Note
Additional properties to retrieve
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
Note
Name
Required
Note
Company
Contact
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
Note
Additional properties to retrieve
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
Note
Additional properties to retrieve
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 HubSpot with AI agents and code
Beyond Zap workflows. Call Google BigQuery and HubSpot 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 HubSpot actions as tools in any MCP client. Authenticate once, then call them in natural language.
Example actions on this page
Create Row
Update Contact Subscription Preferences
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
Practical ways you can use Google BigQuery and HubSpot
Track business data trends.
When HubSpot registers a new deal, Zapier updates a corresponding dataset or row in Google BigQuery. This automation enables business owners to monitor real-time sales trends and operational insights without manually synchronizing data between two platforms. It keeps business analytics accurate for better strategy decisions.
When new contact information is added or updated in HubSpot, Zapier uploads the data to Google BigQuery for advanced analysis. Data scientists can use this integration to examine customer trends and segmentation efficiently without manual data transfers. This helps maintain real-time insights for crucial business decisions.
When new rows are added to a designated table in Google BigQuery (such as one containing marketing lead details), Zapier automatically creates or updates a contact in HubSpot. Marketers can use this data to ensure their CRM is always inclusive of the latest lead data, reducing follow-up delays and ensuring timely outreach.
Learn how to automate Google BigQuery on the Zapier blog
Learn how to automate HubSpot on the Zapier blog
Make work flow with AI
Level up your Google BigQuery to HubSpot 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 + HubSpot 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 HubSpot
How do I set up a Google BigQuery to HubSpot integration?
Setting up an integration between Google BigQuery and HubSpot involves using Zapier to connect both platforms. You need to create a Zap that uses Google BigQuery as a trigger and HubSpot as an action. For instance, you can configure a trigger event when a new row is added in BigQuery which then updates or creates a contact record in HubSpot.
What triggers can I use when integrating Google BigQuery with HubSpot?
When integrating with Google BigQuery, you can use triggers such as the 'New Row' or 'Updated Row' in your dataset. These triggers enable us to start workflows that push data from BigQuery into HubSpot automatically.
What actions are available in HubSpot when triggered by Google BigQuery data changes?
Upon detecting changes from Google BigQuery, you can perform actions like creating new contacts, updating existing contact records, or adding notes to existing deals within HubSpot. This ensures that your CRM data stays current with your analytical insights.
Do I need any special permissions to connect Google BigQuery with HubSpot?
Yes, to set up this integration you'll need appropriate permissions on both ends. For Google BigQuery, access rights to view and query the needed datasets are necessary. On the HubSpot side, ensure you have permissions to edit contacts or deals according to your intended actions.
Can I schedule regular data syncs between Google BigQuery and HubSpot?
Yes, our platform supports scheduling regular Zaps that can execute periodically. You can automate the sync frequency based on your needs—whether it’s hourly, daily or weekly updates—to ensure continuous alignment between your analytics and CRM data.
How does data mapping work between Google BigQuery and HubSpot fields?
When setting up the integration, you'll need to map fields from your Google BigQuery dataset to corresponding fields in HubSpot. This mapping is customizable allowing you to match specific columns in your analytics data with CRM attributes such as contact names or email addresses.
Is there a way to handle errors during data transfer from Google BigQuery to HubSpot?
Absolutely! We offer built-in error handling features where you can specify fallback actions if certain conditions aren’t met. You can configure alerts for failed transfers or set retries for transient errors ensuring minimal impact during sync operations.
About Google BigQuery
BigQuery is Google's serverless and highly scalable enterprise data warehouse, designed to make all your data analysts productive.
