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 contacts from.
- (Optional) Use the Preview & Select columns feature to choose the columns you need, edit their names, and configure a sort order.
- Click Preview & Select columns.
A new window opens. - Make the changes you want.
- Click Save changes.
- Click Preview & Select columns.
- Click Run to start your request.
info If you are running a request for the first time, the Permission needed pop-up window opens.
- Click Sign in with Google.
- Select the Google account you want to use with Awesome Table.
- Click Allow to grant Awesome Table the required permissions.
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!