# HubSpot

# Introduction

The HubSpot module allows you to automatically collect your CRM's data.

# An example of operation

  1. We configure the module in the platform by granting access to the HubSpot
  2. We set the module on the schedule - the data will be collected and stored in witcloud dataset
  3. After the table is processed, you can use other reporting modules or combine it with analytics

# Data schema

Eight new tables will appear in your WitCloud dataset:

image alt text

All tables share the same data schema.

Expand for the data schema
Field name Type Mode
id STRING NULLABLE
createdAt TIMESTAMP NULLABLE
updatedAt TIMESTAMP NULLABLE
archived BOOLEAN NULLABLE
properties RECORD REPEATED
properties. key STRING NULLABLE
properties. value RECORD NULLABLE
properties.value. stringValue STRING NULLABLE
properties.value. intValue STRING NULLABLE
properties.value. floatValue STRING NULLABLE
properties.value. timestampValue TIMESTAMP NULLABLE
associations RECORD REPEATED
associations. from STRING NULLABLE
associations. to RECORD NULLABLE
associations.to. key STRING NULLABLE
associations.to. value STRING NULLABLE

# Configuration

# Before you start

Make sure you have 'Super admin' access to the HubSpot account

A description of how to do it can be found at this link link (opens new window)

# Start creating the module

From the menu on the left, select the "Collect" tab, then click the "Add new data Collect" button.

image alt text

Select "HubSpot" from the list of available modules

image alt text

# Initial settings

In the first step, we only have one field to fill.

Collect name - the name of our module. It will be visible under this name elsewhere on the platform.

image alt text

# Authorization with HubSpot

In the next step, we need to grant WitCloud access to HubSpot. It is necessary for WitCloud to be able to download data. This can be done using the oauth HubSpot method

To do this, press the "Sign in with HubSpot" button

image alt text

Authorize via the login form

image alt text

And choose the HubSpot account

image alt text

After proper authorization, select your account from the list and click 'Finish' button

image alt text

# Setting the module in the schedule

Your HubSpot module is already created in WitCloud 📊. The last step is to establish a schedule and include our module in it. You can read about how to do it here link (opens new window)

Last updated: 4/15/2021, 12:30:11 PM