Leads import in hubspot from google sheets

Developer Support APIs & Integrations
,
1

Hey,

I am new here and would appreciate your help understanding basic terms.
I have Google Sheets Excel that updates daily with leads (name, email, phone, etc.). I want to create an application (I think private) to import the data from Google Sheets into HubSpot daily.

I have a few questions:
1. Is every lead in my Google sheet called contact?

2. What API calls should I perform?

3. I am on a free plan, is it possible to do that with this plan?

Thanks

2

Hi @YFarge :waving_hand:

Welcome to the community :slightly_smiling_face:

Yes, this sounds like a good candidate for the Private App authentication method. You might find this HubSpot developer document useful when configuring your Private App.

To answer your questions:

  1. Yes, assuming each lead in your spreadsheet has a unique email address. The HubSpot CRM data model treats each “individual person” as a unique Contact record. The default unique identifier for Contacts is email address. Note that 1 Contact record can have 0 to many email addresses. To learn more about HubSpot’s CRM, you might find this article useful.
  2. You’ll likely be relying on the Search CRM API and the Contacts API. You might like to consider the following logic flow:

    1. Start the processing of each “lead” in your spreadsheet by searching for an existing HubSpot Contact (unique identifier email address):

      • POST

           *https://api.hubapi.com/crm/v3/objects/CONTACT/search*

      • Headers:

        • Content-Type: application/json
        • Authorization: Bearer {{your_private_app_access_token}}

      • Body (JSON):

        • {
          “filterGroups”: [
          {
          “filters”: [
          {
          “propertyName”: “email”,
          “operator”: “EQ”,
          “value”: “example@example.com”
          }
          ]
          }
          ]
          }

      • If your search returns an existing Contact record, you’ll want to update

           **(Branch 1)**

    it. If your search returns no existing Contact, you'll want to [u]**create**[/u]

   **(Branch 2)**

    a new Contact record.

    2. Update Existing Contact

      (Branch 1)

      • PATCH

           *[https://api.hubapi.com/crm/v3/objects/CONTACT/:RECORD\_ID](https://api.hubapi.com/crm/v3/objects/CONTACT/search)*
        • Where :RECORD_ID is replaced by the Contact ID returned from the previous CRM Search request.

      • Headers: same as previous request

      • Body (JSON):

        • {
          “properties”: {
          “example_property_1”: “example value 1”,
          “example_property_2”: “example value 2”
          }
          }

    3. Create New Contact

      (Branch 2)

      • POST

           *[https://api.hubapi.com/crm/v3/objects/CONTACT](https://api.hubapi.com/crm/v3/objects/CONTACT/search)*

      • Headers: same as previous request

      • Body (JSON):

        • {
          “properties”: {
          “email”: “example@example.com”,
          “firstname”: “Example”,
          “lastname”: “Contact”,
          “example_property_1”: “example value 1”
          }
          }

Hopefully that sets you down the right path. Depending on how much data you’re working with, you may also want to consider batching your create/update requests. See HubSpot API docs (linked above) for more information on how to achieve this.

I hope this proves useful. Please let me know if you have any follow-up questions.

3

Thanks! Great information.

1. Can I post bulk of contacts? I don’t see it in the doc.

2. Is there any limits? (max requests per minute/day)

Thanks

4

@YFarge Happy to help :slightly_smiling_face:

  1. Yes, it’s possible to create/update a batch of Contacts

(up to 100 per request)

. Within the HubSpot CRM Contacts API documentation, click the “Endpoints” tab, then scroll down until you see “Create a batch of contacts” and “Update a batch of contacts”. Here’s an example of each:

  • Create a batch of contacts
    • POST https://api.hubapi.com/crm/v3/objects/CONTACT/batch/**create**
    • Headers:
      • Content-Type: application/json
      • Authorization: Bearer {{your_private_app_access_token}}
    • Body (JSON):

      • {

                    "inputs": \[

              {

                "properties": {

                  "email": "example-1@example.com",

                  "firstname": "Example",

                  "lastname": "Contact 1"

                }

              },

              {

                "properties": {

                  "email": "example-2@example.com",

                  "firstname": "Example",

                  "lastname": "Contact 2"

                }

              }

            ]

          }
  • Update a batch of contacts
  • Where “123” and “456” are example Contact record IDs
  1. You can find detailed information about HubSpot API usage guidelines (including limits) here.

I hope this proves useful. Please let me know if you have any follow-up questions.

5

Yes, in HubSpot terms, leads like the ones in your sheet would map to Contacts. You can use the Contacts API to create/update them, but on the free plan, you’ll hit some rate limits. If you don’t want to manage the API calls yourself, Skyvia can handle the daily sync from Google Sheets to HubSpot without much setup.