How to associate any two records of different HubSpot objects from your Spreadsheet

1

Choose the Source

In the Superjoin side panel, click on Sources, navigate through Your Sources and click on the HubSpot source you want to export the data to.

2

Create new Export

A pop-up will come up at the bottom of the side panel. Click on Export to HubSpot.

3

Fill Source Data

Choose the sheet with the data that you want to export to HubSpot and the row with the header cells of the sheet that you want to export.

4

Select Destination

Select Associate under the Action dropdown. Choose both the Objects that you want to be associated

5

Mapping the Data

Map only the two Google Sheets columns which contain the Record IDs of each of the object’s records to the HubSpot Record ID properties of the two objects to ensure accuracy.

Choose the Record ID property of chosen object and repeat the same for the other object’s record ID mapping as well.

Once you’re done with the mapping, click on Save and then click on Export.

Record IDs are mandatory to perform the ASSOCIATE action. You can use the Click here to get Record IDs feature or retrieve the IDs manually.

Need help with retrieving Record IDs manually from HubSpot?

Head over to this page to get a detailed explanation on it.

6

Select rows or sheet to export

You can choose to export the entire sheet or only specific rows. If you want to export specific rows, further select the rows you want to export.

7

Export Data

Verify the number of rows and click on Associate in HubSpot button, this action exports the selected data from your Google Sheets into your HubSpot account.

This completes the process of using Superjoin to associate two records of different HubSpot objects from Google Sheets.
Below are the steps to automate this process.

8

Automate the process

Now you’ll see a card called Automatic Exports. Click on the Create Schedule button.

9

Create a schedule

Configure the frequency in which you want this export process to repeat.

Hope this guide helped you export your data from Google Sheets to HubSpot using Superjoin.

If you have any questions or need further assistance, please don’t hesitate to reach out to our support team. Thank you!