topic Re: Leads import in hubspot from google sheets in APIs & Integrations

Leads import in hubspot from google sheets

YFarge — Tue, 12 Sep 2023 05:56:34 GMT

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

Re: Leads import in hubspot from google sheets

zach_threadint — Tue, 05 Mar 2024 06:41:04 GMT

Hi @YFarge 👋

Welcome to the community 🙂

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:

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.
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 create (Branch 2) a new Contact record.
2. Update Existing Contact (Branch 1)
  - PATCH https://api.hubapi.com/crm/v3/objects/CONTACT/:RECORD_ID
    - 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
  - 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.

Re: Leads import in hubspot from google sheets

YFarge — Tue, 12 Sep 2023 08:40:31 GMT

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

Re: Leads import in hubspot from google sheets

zach_threadint — Tue, 05 Mar 2024 06:41:29 GMT

@YFarge Happy to help 🙂

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
  - POST https://api.hubapi.com/crm/v3/objects/CONTACT/batch/update
  - Headers: as above
  - Body (JSON):
    - {
      
      "inputs": [
      
      {
      
      "id": "123",
      
      "properties": {
      
      "firstname": "Example",
      
      "lastname": "Contact 3"
      
      }
      
      },
      
      {
      
      "id": "456",
      
      "properties": {
      
      "firstname": "Example",
      
      "lastname": "Contact 4"
      
      }
      
      }
      
      ]
      
      }
- Where "123" and "456" are example Contact record IDs
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.

Re: Leads import in hubspot from google sheets

LSchmidt63 — Tue, 03 Jun 2025 23:08:45 GMT

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.