Columns Ai

The simple platform to build data stories.

Integrate the Columns Ai API with the HubSpot API

Setup the Columns Ai API trigger to run a workflow which integrates with the HubSpot API. Pipedream's integration platform allows you to integrate Columns Ai and HubSpot remarkably fast. Free for developers.

Trusted by 1,000,000+ developers from startups to Fortune 500 companies

Adyen logo
Appcues logo
Bandwidth logo
Checkr logo
ChartMogul logo
Dataminr logo
Gopuff logo
Gorgias logo
LinkedIn logo
Logitech logo
Replicated logo
Rudderstack logo
SAS logo
Scale AI logo
Webflow logo
Warner Bros. logo
Adyen logo
Appcues logo
Bandwidth logo
Checkr logo
ChartMogul logo
Dataminr logo
Gopuff logo
Gorgias logo
LinkedIn logo
Logitech logo
Replicated logo
Rudderstack logo
SAS logo
Scale AI logo
Webflow logo
Warner Bros. logo
Build Graph From Scratch with Columns Ai API on Company Updated from HubSpot API
HubSpot + Columns Ai
 
Try it
Build Graph From Scratch with Columns Ai API on Contact Updated from HubSpot API
HubSpot + Columns Ai
 
Try it
Build Graph From Scratch with Columns Ai API on Deleted Blog Posts from HubSpot API
HubSpot + Columns Ai
 
Try it
Build Graph From Scratch with Columns Ai API on Line Item Updated from HubSpot API
HubSpot + Columns Ai
 
Try it
Build Graph From Scratch with Columns Ai API on New Blog Posts from HubSpot API
HubSpot + Columns Ai
 
Try it
Company Updated from the HubSpot API

Emit new event each time a company is updated.

 
Try it
Contact Updated from the HubSpot API

Emit new event each time a contact is updated.

 
Try it
Deleted Blog Posts from the HubSpot API

Emit new event for each deleted blog post.

 
Try it
Line Item Updated from the HubSpot API

Emit new event each time a line item is updated.

 
Try it
New Blog Posts from the HubSpot API

Emit new event for each new blog post.

 
Try it
Build Graph From Scratch with the Columns Ai API

Builds a graph object from scratch and publishes it. See the documentation

 
Try it
Add Contact to List with the HubSpot API

Adds a contact to a specific static list. See the documentation

 
Try it
Build Graph From Template with the Columns Ai API

Builds a graph object from a template and publishes it. See the documentation.

 
Try it
Batch Create or Update Contact with the HubSpot API

Create or update a batch of contacts by its ID or email. See the documentation

 
Try it
Create Associations with the HubSpot API

Create associations between objects. See the documentation

 
Try it

Connect Columns Ai

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
import { ChartType } from 'columns-graph-model';
import { Columns } from 'columns-sdk';

export default defineComponent({
  props: {
    columns_ai: {
      type: "app",
      app: "columns_ai",
    }
  },
  async run({steps, $}) {    
    const rows = [{
        "value": 312,
        "state": "WA",
        "parent": "US"
      }];// rows is an example data set where you should organize your data in a similar way.

    //Instantiates a Columns SDK object with your API Key.  
    const columns = new Columns(this.columns_ai.$auth.api_key);
    const data = columns.data(['state'], ['value'], rows);
    const graph = columns.graph(data);

    // switch to different chart types: BAR, PIE, DOUGHGUT, LINE, AREA, SCATTER, etc.
    graph.type = ChartType.COLUMN;

    // customise the graph (lots of options in its data model)
    graph.settings.general.palette = ['#ff0000', '#00ff00', '#0000ff'];
    graph.settings.general.background = '#00000002';
    
    return graph;          
  },
})

Overview of HubSpot

The HubSpot API enables developers to integrate into HubSpots CRM, CMS, Conversations, and other features. It allows for automated management of contacts, companies, deals, and marketing campaigns, enabling custom workflows, data synchronization, and task automation. This streamlines operations and boosts customer engagement, with real-time updates for rapid response to market changes.

Connect HubSpot

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
import { axios } from "@pipedream/platform"
export default defineComponent({
  props: {
    hubspot: {
      type: "app",
      app: "hubspot",
    }
  },
  async run({steps, $}) {
    return await axios($, {
      url: `https://api.hubapi.com/integrations/v1/me`,
      headers: {
        Authorization: `Bearer ${this.hubspot.$auth.oauth_access_token}`,
      },
    })
  },
})

Trusted by 1,000,000+ developers from startups to Fortune 500 companies

Adyen logo
Appcues logo
Bandwidth logo
Checkr logo
ChartMogul logo
Dataminr logo
Gopuff logo
Gorgias logo
LinkedIn logo
Logitech logo
Replicated logo
Rudderstack logo
SAS logo
Scale AI logo
Webflow logo
Warner Bros. logo
Adyen logo
Appcues logo
Bandwidth logo
Checkr logo
ChartMogul logo
Dataminr logo
Gopuff logo
Gorgias logo
LinkedIn logo
Logitech logo
Replicated logo
Rudderstack logo
SAS logo
Scale AI logo
Webflow logo
Warner Bros. logo