LogoLogo
ProductsPricingGlossary Launch Acho
  • 🎉Welcome
  • Introduction
  • What is Acho?
  • How does Acho work?
    • Proof of Concept (PoC)
  • App Builder
    • Get Started
    • Core Concepts
    • Overview
    • App construction
      • App Configuration
      • Pages
      • Interactions
        • Add an interaction
        • Add conditions to interactions
        • Event payload
        • Ordering interactions with action flow
        • Transformer
        • Actions
          • Navigation
          • Element
          • Data Source
          • App
          • Page
          • API Service
          • Database
          • Media Service
      • Table
      • Metric
      • Query
      • Data Store
      • Elements
        • Table & Chart
          • Searchable Table
          • Table
          • Chart
          • Score Card
        • Form Elements
          • Form
          • Search Bar
          • Checkbox
          • Date Picker
          • Custom Form
          • Input
          • Multiselect
          • Radio Button
          • Radio List
          • Rich Text Editor
          • Select
          • Switch
          • Textarea
          • Upload
        • Web Elements
          • Badge
          • Button
          • Clickable
          • Collapse Menu
          • Divider
          • Icon
          • Image
          • Link
          • Message
          • Modal
          • Notification
          • Pagination
          • Popover
          • Rate
          • Rich Text
          • Tabs
          • Text
        • Layout Elements
          • Container
          • List
        • Advanced elements
          • Code Block
          • Condition
          • Print
        • CSS Styles
          • General techniques
          • Layout
          • Spacing
          • Size
          • Position
          • Typography
          • Background
          • Border
          • Effect
        • Form Check
        • Tooltip
      • Accessors
      • Plugin Store
    • Popular Use Cases
      • Build a chart from Table Nodes
      • Create a table
      • Create a list
      • Create a filter
      • Create a search bar
      • Use Custom Form Container to collect user inputs
      • Drill down on a table
      • Download file from query node
      • Set loading animations
      • Modify a database
      • Navigate to a different page
      • Set up dynamic routing
      • Update app data using accessors
      • Create a Chart with Code Block and D3 Library
      • Rich text and rich text editor
      • Send an Email via Mailjet Plugin
    • Preview
    • Publish
      • Embed published app on website
    • Version Control
    • App User Management
      • Onboarding Page
      • Sign in page
      • Guest Isolation and Private Session
    • Theme
    • FAQ
  • Acho Studio
    • Quick Start
    • Resources
      • Add a resource
      • Supported data sources
        • Airtable
        • Amazon Ads
        • Amplitude
        • Amazon Seller Partner
        • Apify Dataset
        • Appstore
        • Asana
        • API Connector
        • API Template
        • AWS CloudTrail
        • Azure Table Storage
        • Batch Files
        • Bamboo HR
        • BigCommerce
        • BigQuery
        • Bing Ads
        • Braintree
        • Cart.com
        • Chargebee
        • Chargify
        • Chartmogul
        • Clickhouse
        • Close.com
        • CockroachDB
        • Confluence
        • Customer.io
        • Delighted
        • Dixa
        • Drift
        • Facebook Marketing
        • Freshdesk
        • Freshsales
        • Freshservice
        • GitHub
        • GitLab
        • Google Ads
        • Google Analytics
        • Google Sheets
        • Google Search Console
        • Greenhouse
        • Harness
        • Harvest
        • HubSpot
        • IBM Db2
        • Instagram
        • Intercom
        • Iterable
        • Jenkins
        • Jira
        • Kafka
        • Klaviyo
        • Kustomer
        • Lemlist
        • Lever Hiring
        • LinkedIn Ads
        • Linnworks
        • Mailchimp
        • Marketo
        • Microsoft Teams
        • Mixpanel
        • Monday
        • MongoDB
        • MySQL
        • My Hours
        • NetSuite
        • Notion
        • Okta
        • OneDrive
        • OneSignal
        • Oracle DB
        • Outreach
        • PagerDuty
        • Paypal Transaction
        • Paystack
        • Pipedrive
        • PersistIq
        • Pinterest
        • Plaid
        • PostgreSQL
        • PostHog
        • PrestaShop
        • Qualaroo
        • QuickBooks
        • Recharge
        • Recurly
        • Remote File
        • S3
        • Salesforce
        • Salesloft
        • SearchMetrics
        • Sendgrid
        • Sentry
        • Short.io
        • Shopify
        • Single File
        • Slack
        • Smartsheets
        • Snapchat Marketing
        • Snowflake
        • SQL Server
        • Square
        • Stripe
        • SurveyMonkey
        • Tempo
        • TikTok Marketing
        • Trello
        • Twilio
        • Typeform
        • VictorOps
        • WooCommerce
        • YouTube Analytics
        • Zendesk Chat
        • Zendesk Sunshine
        • Zendesk Talk
        • Zendesk Support
        • Zenloop
        • Zoho CRM
        • Zoom
        • Zuora
    • Data Prep (Projects)
      • Create a Data Prep Project
        • Create a table tab
        • Copy a table tab
        • Hide a table tab
      • Apply an action
        • View
          • Hide Columns
          • Filter
          • Sort
          • Cut
          • Rename
          • Move Column
        • Combine Tables
          • Join
          • Union
        • Transformation
          • Pivot Table
          • Unpivot
        • Data Cleaning
          • Cleanse
          • Replace
          • Change Type
          • Deduplicate
          • Split
          • Flatten
        • Tools
          • Formula
          • SQL Editor
            • SQL Editor Queries
            • All functions in Formula/SQL
              • Mathematical Functions
              • String Functions
              • Date Functions
              • Datetime Functions
              • Time Functions
              • Timestamp Functions
              • Conditional Functions
              • Type Conversion
              • Other Functions
        • Reserved Keywords
      • Pipeline
      • Edit your pipelines
      • Generate column summary for inspection
      • Use URL to access and share your project
      • Write a description for your project
      • Delete a resources/project/tab
    • Data Flow
      • Export data
        • Download CSV files
        • Excel Connector
        • Google Sheets Connector
        • Embed a table on your website
          • Data Usage Agreement
        • Apache Superset
        • Chartio
        • Looker
        • Metabase
        • Power BI
        • Qlik
        • Tableau
        • MongoDB
        • MySQL
        • MSSQL
        • Snowflake
        • PostgreSQL
        • BigQuery
    • Set up Data Sync
    • FAQ
  • Organization
    • Get started
    • Create an organization
    • Invite people to your organization
    • Share your resources
    • Share your projects
    • Share your apps
    • Change payment method on file
  • FAQ
    • I can't find data after uploading a big CSV file
Powered by GitBook
On this page
  • 1. How to connect to HubSpot?
  • OAuth 2.0
  • API Key
  • 2. How to get the API key from HubSpot?
  • 3. How to set up Data Sync?
  • 4. Available Data

Was this helpful?

  1. Acho Studio
  2. Resources
  3. Supported data sources

HubSpot

PreviousHarvestNextIBM Db2

Last updated 2 years ago

Was this helpful?

1. How to connect to HubSpot?

OAuth 2.0

You can follow the following steps to build a connection with your HubSpot. If you need any help in setting up your integration, please contact us.

1. Go to the Resources page and click the Add Resource button.

2. In the "Select a data source" step, select HubSpot under Application.

3. Click the button to log in with your HubSpot account.

4. After successfully logging in, you'll be redirected back to Acho. Please fill in the required fields and click .

5. Select the tables you wish to sync on the next page and click Finish Setup.

6. You will see a icon next to your HubSpot resource. It may take a few minutes to several hours, depending on the data size and the number of your tables. Once your APP's data is ready, you will receive a notification email.

API Key

API key will be deprecated after November 30, 2022. See HubSpot's post for more details. If you set up your resource with an API key previously and need help migrating to OAuth 2.0, please contact us.

1. Go to the Resources page and click the Add Resource button.

2. In the "Select a data source" step, select HubSpot under Application.

3. In the "Configure the data source" step, enter the following information:

  • Start Date (UTC): Retrieve data from a specific date and time. The date should be defined in UTC date and time, such as 2017-01-25T00:00:00Z.

  • API Key: Find your API key here.

4. Select the tables you wish to sync on the next page and click Finish Setup.

2. How to get the API key from HubSpot?

API key will be deprecated after November 30, 2022. See HubSpot's post for more details. If you set up your resource with an API key previously and need help migrating to OAuth 2.0, please contact us.

To allow Acho to connect to your HubSpot account, you have to get the API key. Here are the instructions about how to acquire it.

You must have Super Admin permissions to access your account's API key.

1. Go to your HubSpot account and click the settings icon on the top navigation bar.

2. In the left sidebar menu, navigate to Integrations > API key.

  • If a key has never been generated for your account, click Generate API key.

  • If you've already generated an API key, click Show to display your key.

3. With the key displayed, click Copy to copy the key. You can then paste the key to Acho.

3. How to set up Data Sync?

Acho supports creating schedulers to retrieve the latest data from your HubSpot account at a certain time interval. To see more details, you can visit here.

4. Available Data

  • Campaigns

  • Companies (Incremental)

  • Contact Lists (Incremental)

  • Contacts (Incremental)

  • Contacts List Memberships

  • Deal Pipelines

  • Deals (including Contact associations) (Incremental)

  • Email Events (Incremental)

  • Engagements (Incremental)

  • Engagements Calls (Incremental)

  • Engagements Emails (Incremental)

  • Engagements Meetings (Incremental)

  • Engagements Notes (Incremental)

  • Engagements Tasks (Incremental)

  • Feedback Submissions (Incremental)

  • Forms

  • Form Submissions

  • Line Items (Incremental)

  • Marketing Emails

  • Owners

  • Products (Incremental)

  • Property History (Incremental)

  • Quotes (Incremental)

  • Subscription Changes (Incremental)

  • Tickets (Incremental)

  • Ticket Pipelines

  • Workflows

5. You will see a icon next to your HubSpot resource. It may take a few minutes to several hours depending on the data size and the number of your tables. Once your APP's data is ready, you will receive a notification email. ready, you will receive a notification email.