The HubSpot Google Sheets Integration, Explained

Which HubSpot Google Sheets option should you use?

To send HubSpot data to a sheet as things happen, use the workflow actions on a Professional or Enterprise plan. To bring contacts into HubSpot once, use the add-on or paste into an import. For a sheet that keeps syncing into HubSpot, or a dataset kept current in Sheets, use Data Studio on Data Hub Professional or Enterprise.

HubSpot's report exports are CSV or Excel files, not Google Sheets, and HubSpot's data sync apps cover tools such as Airtable and Smartsheet but not Google Sheets. Before building a reporting sheet, check whether a HubSpot dashboard would do the job.

How do the Google Sheets workflow actions work?

Install Google Sheets Workflows for HubSpot, connect a Google account, then add Create Google Sheet row or the update action to a workflow. Pick the spreadsheet and tab, and map each header to a property or an earlier action's output. Each action writes up to 20 cells per row, and the spreadsheet can't exceed 5,000,000 cells.

• One connecting user: you can only pick sheets that user's Google account can see. If that HubSpot user is deactivated, the action fails until someone reconnects.
• Create vs update: Create always inserts a new row. Update finds a row by a lookup column, changes only the first match, and can create a row if none matches.
• Values: HubSpot sends internal values, and dates as Unix timestamps in milliseconds.
• Headers: the header row must start in A1 with no blank headers, and HubSpot can't write to unlabeled columns.

How do you connect Google Sheets to HubSpot with a webhook?

Deploy a Google Apps Script web app on the sheet, then point a HubSpot workflow's Send a webhook action at its URL. The webhook POSTs the record's properties, or only the ones you choose, and the script's doPost function writes them. HubSpot's webhook action needs Data Hub Professional or Enterprise.

When we checked HubSpot's and Google's documentation in November 2026:

• HubSpot side: the Send a webhook workflow action supports POST to send data and GET to retrieve it. For a POST you can include all of the record's properties or customize the request body with chosen properties and static values. You can authenticate with a request signature or an API key, test with a sample record, and turn on rate limiting so a large enrollment does not flood the sheet.
• Google side: an Apps Script web app runs its doPost(e) function when a program sends it an HTTP POST request; the event object carries the request body for the script to parse and append as a row.
• When to use it: when you need custom formatting, several tabs from one event, or logic before the write. For one row per record, the Google Sheets workflow actions above need no code and run on any Professional or Enterprise plan with workflows.

Treat the script like any integration: log what it receives, reject requests that fail the signature or key check, and keep the lookup-column rules from the next section so retries don't create duplicate rows.

How do you keep a HubSpot-fed Google Sheet accurate?

Treat the sheet HubSpot writes to as raw data. Don't type in it, add formulas or let two workflows write to the same sheet. Use the update action keyed on record ID so re-enrollments and retries don't duplicate rows, and build calculations, date conversions and charts on a separate tab that reads from it.

• Formulas: HubSpot advises against formulas in the sheet it updates, because they slow the action or cause errors, and inserted rows can shift references.
• Timeouts: a request can time out and create a duplicate row, which is another reason to update by ID.
• Breakage: renaming headers, deleting the tab or moving the header row out of A1 stops the action. Check dependent workflows before disconnecting or reconnecting the app.

How do you get Google Sheets data into HubSpot?

For a one-off, download the sheet as CSV or XLSX and import it, or paste rows straight into HubSpot's import tool. The HubSpot for Google Sheets add-on can send a sheet's contacts to HubSpot from inside Sheets. For an ongoing sync, Data Studio connects a sheet and refreshes it every five minutes on Data Hub Professional or Enterprise.

Imports and the add-on create or update contacts by email, so clean the sheet first. If your account has Sensitive Data turned on, the add-on can't access any data. For larger moves from spreadsheets, our data migration mapping sheet helps you plan the fields.

HubSpot Google Sheets checklist