G-Accon for HubSpot – Import Contacts, Companies, Deals

Hello!

We are very excited to announce, that we have added new functionality to our Hubspot application: data upload.

Currently, it works for following tables:

  •  Deals
  • Contacts
  • Companies

More are on the way.

Please see video demonstration:

Or you can go through the steps below:

    1. In the Google spreadsheet, create data to upload. You can download existing data from the Hubspot, import it from another application, or just create it manually. The first line should be the fields names. Better (but not mandatory), if it will be same, as field names in the Hubspot table. Select data you want to upload.
      selected_data
    2. In G-Accon menu, click “Update / Insert Selected Row(s)”
    3. Select table to upload to:
      hubspot_3
    4. After selection, matched Hubspot fields will be mapped automatically. Non-matched will be left blank:
      hubspot_4
    5. To match it, drug and drop the Hubspot field from the list of updatable fields. After this, check “Use” checkbox:
      hubspot_5
    6. Click “Go” button.
    7. You will receive the error message because the selected operation is “Update” and you do not have an ID field in your data.
      hubspot_7
    8. Select “Insert” and click “Go” again.
    9. This time data will be uploaded. You will see upload results in the columns to the right of your dataset. As you can see, one record has been uploaded, and another had received the Hubspot validation error because a wrong value in the “type” column.
      hubspot_9
    10. Change the value in the “type” column to “PROSPECT”, select two first rows and upload again. This time it will be uploaded.
      hubspot_10

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s