Learn how to import your contacts from HubSpot CRM into Google Sheets to send a mail merge with Gmail from your spreadsheet.
Awesome Table Connectors allows you to import HubSpot data, including your contacts.
Prerequisites
info You can log in to the HubSpot connector using your HubSpot account or with an API key.
- In the Awesome Table add-on Home screen, click Create new request.
The list of available connectors is displayed.
- Open the HubSpot connector.
- On the Connect to HubSpot screen, click Sign in with HubSpot.
- Select your HubSpot account and click Choose Account.
- Click Connect app.
You are now logged in with the HubSpot connector.
- Open the Select data drop-down and select Contacts from list.
- Select the list you want to import from.
- Click Edit columns.
- On the Edit columns popup sidebar, click the properties you want to include in your import, then click Save changes. We recommend including all properties.
info The properties in your import may vary depending on your HubSpot contacts list’s properties.
- Click Run to start your request.
Awesome Table Connectors informs you if you successfully imported to Google Sheets.
done That’s it! You have imported your contacts from HubSpot into your Google spreadsheet. You are now ready to use YAMM to email your contact list!