Connect HubSpot To Google Sheets

Log in to Amigo with your Google Account or a valid email address–yes, no prior signing up is required.

Set up a new HubSpot and Google Sheets integration by clicking “Create new connections”.

Select HubSpot from the available sources.

Give the connection a name and click “Connect” to connect HubSpot to Google Sheets.

You’ll be redirected to the HubSpot login page. Sign in and select the HubSpot account to connect to Google Sheets.

If you’re not presented with the above option, go back to the sources page and click HubSpot after you’ve logged in to HubSpot. Your HubSpot account should now be ready for integration with Google Sheets.

Upon selecting the account, your HubSpot will be connected to Google Sheets. The HubSpot-Google Sheets integration you’ve created will appear on the connections dashboard.

And so this completes the HubSpot Google Sheets integration. We can now begin to export HubSpot data to Google Sheets.

The HubSpot-Google Sheets integration you’ve created will appear in the Amigo dashboard under Connections.

Click the HubSpot connection to Google Sheets you’ve created to export HubSpot contacts to Google Sheets, for example. You can export several other types of data such as deals, products, companies and tickets.

Select the “Imports” option to pull data from HubSpot to Google Sheets.

Upon selecting the import option, you’ll be taken to the report creation page from where you can choose and customise the data to export to Google Sheets from HubSpot.

Choose the object type to export–Contacts, Companies, Deals, Products, or Tickets.

Select the properties of the chosen object to export. And (optionally) switch the “Refresh Schedule” toggle and set the time to automate subsequent HubSpot data exports to Google Sheets.

Once this has been done, preview the HubSpot data to export to Google Sheets by clicking the “Preview” button. And click “Import to Google Sheets” to export the data from HubSpot to Google Sheets.

If this is the first time exporting HubSpot data to Google Sheets, you’ll be prompted to establish a connection between Amigo and Google Drive. Create the connection and export the HubSpot data to Google Sheets. (You can also connect to multiple Google accounts should you wish.)

On clicking the “Export” button the HubSpot data will be exported to Google Sheets.

After successfully integrating HubSpot with Google Sheets and exporting HubSpot data to Google Sheets, Amigo will automatically update the data daily–or at a frequency specified. This way whenever any changes is made in HubSpot, they’ll be reflected in Google Sheets without any manual input.

And you can set an alert to let Amigo send the report to you and your team via email and/or Slack. Just add the email addresses and Slack Channels to which you want to alerts to be sent, and you and your team will receive the updated data at the same time. This feature is yet to be available for the web version however; it’s only available with the Amigo addon–for now. You can get it from Google Workspace Marketplace.

You can connect to various other sources such as Facebook Ads, Google Ads, SurveyMonkey, Salesforce, Shopify and several others with Amigo and import data to Google Sheets without ease. And Amigo will pull the data automatically so that you can sit back and relax knowing that you’ll always have the latest report.

Visit our blog to learn how to connect them to Google Sheets.