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 Sheets with HubSpot - no code necessary. See how you can get setup in minutes.
100%
Help
Google Sheets
Google Sheets
1. Choose trigger event
HubSpot
HubSpot
2. Choose action
1. Select the event
Setup
Test
Google Sheets
Choose a trigger event
Choose a trigger
A trigger is the event that starts your Zap—like a "New Spreadsheet Row (Team Drive)" from Google Sheets.
Add your action
An action happens after the trigger—such as "Update Contact Subscription Preferences" in HubSpot.
You’re connected!
Zapier seamlessly connects Google Sheets 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.
Create a new record or update an existing record in your app.
Note
Name
Required
Action
This is an event a Zap performs.
Write
Create a new record or update an existing record in your app.
Create Contact
Creates 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.
Create CRM Object
Creates a CRM object in HubSpot
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
Object Type
Required
Processing Type
Required
Folder ID
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.
Create Deal
Creates a Deal in HubSpot.
Action
This is an event a Zap performs.
Write
Create a new record or update an existing record in your app.
Note
Workflow Name
Required
Contact's Email
Required
Action
This is an event a Zap performs.
Write
Create a new record or update an existing record in your app.
Contact 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.
Deal 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.
Line_item 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.
Ticket 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.
Note
Blog URL
Required
Blog Author
Required
Publish This Post?
Required
Blog Post URL
Required
Blog Post Title
Required
Blog Post Content
Required
Meta Description
Required
Featured image URL
Action
This is an event a Zap performs.
Write
Create a new record or update an existing record in your app.
Create Product
Creates 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.
Remove Associations
Removes 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
Form
Required
Note
HubSpot usertoken
IP address
Page name
Page URI
Page ID
SFDC campaign ID
GoToWebinar key/ID
Submission timestamp
Skip validation
Action
This is an event a Zap performs.
Write
Create a new record or update an existing record in your app.
Update Company
Update 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.
Update Deal
Update a Deal in HubSpot.
Action
This is an event a Zap performs.
Write
Create a new record or update an existing record in your app.
Update CRM Object
Updates a CRM object in HubSpot
Action
This is an event a Zap performs.
Write
Create a new record or update an existing record in your app.
Update Ticket
Update 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.
Note
Email
Required
Action
This is an event a Zap performs.
Write
Create a new record or update an existing record in your app.
Note
Note
Contact Email
Required
Action
This is an event a Zap performs.
Write
Create a new record or update an existing record in your app.
Find CRM Object
Finds CRM objects by searching with filters
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
Type of Custom Object
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
Owner email
Required
Search among deactivated owners
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 Sheets and HubSpot with AI agents and code
Beyond Zap workflows. Call Google Sheets 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 Sheets and HubSpot actions as tools in any MCP client. Authenticate once, then call them in natural language.
Example actions on this page
Create Spreadsheet Column
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 Sheets and HubSpot
Track new deals in Google Sheets
Zapier ensures you stay on top of your deals by adding any new deal created in HubSpot to Google Sheets. This allows business owners to monitor deal flow in real-time without toggling between tools, keeping operations smooth and data organized.
When a new form submission is received in HubSpot, Zapier logs the details into a Google Sheets spreadsheet. This streamlines data collection, allowing the marketing team to analyze insights or track lead information in a centralized and easily shareable format, saving time on manual entry.
Whenever a deal in HubSpot is updated, Zapier pushes that information to a designated Google Sheets spreadsheet. This workflow keeps deal information current and accessible for planning and decision-making without manual updates, improving the accuracy and timeliness of reporting.
Learn how to automate Google Sheets on the Zapier blog
Learn how to automate HubSpot on the Zapier blog
Make work flow with AI
Level up your Google Sheets 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 Sheets + HubSpot integrations
New to automation with Zapier? You're not alone. Here are some answers to common questions about how Zapier works with Google Sheets and HubSpot
How can I trigger an action in HubSpot using Google Sheets?
You can set up triggers in Google Sheets to prompt actions in HubSpot by using our platform to create a zap. For instance, when a new row is added to your Google Sheet, you can automate the creation of a new contact in HubSpot.
Can I update an existing contact in HubSpot from Google Sheets?
Yes, you can update existing contacts in HubSpot directly from Google Sheets. By setting a trigger like modifying a row or cell content, we enable the corresponding updating action on your contact’s details within HubSpot.
Is it possible to pull data from HubSpot into Google Sheets automatically?
Absolutely. We allow you to pull data such as contact information or sales stats from HubSpot into Google Sheets with scheduled intervals and triggers for automatic updates.
What kind of data can be sent from Google Sheets to HubSpot?
You can send various types of data including contact details, company names, emails, and other custom fields from Google Sheets into your HubSpot account by configuring suitable triggers.
Can I integrate both new and old entries from my Google Sheet with HubSpot?
Certainly! Our integration service enables you not only to sync new entries but also older data from your spreadsheets into your HubSpot database depending on the triggers applied.
Do I need any special permissions for integrating these two platforms?
Generally, you’ll need administrative privileges on both platforms to set up integrations securely. Ensure that API access is enabled as needed for smooth functioning.
How often is the data synchronized between Google Sheets and HubSpot?
The frequency of synchronization depends on the settings and triggers configured within our system between Google Sheets and HubSpot. You can choose immediate sync or set periodic intervals according to your requirements.
About Google Sheets
Create, edit, and share spreadsheets wherever you are with Google Sheets, and get automated insights from your data.
