Connectors
HubSpot
Connectors
HubSpot
Description
HubSpot develops cloud-based, inbound marketing software that allows businesses to transform the way that they market online.
Connector Details
| Name | Value |
|---|---|
| Platform | HubSpot |
| Auth Type | OAuth |
| Direction | Bidirectional |
Supported Data
See the table below for the list of data you can read with the HubSpot connector.
| Table Name | Fields |
|---|---|
| subscription_changes | timestamp, portalId, recipient, changes |
| email_events | appId, appName, browser, created, deviceType, duration, emailCampaignId, emailCampaignGroupId, filteredEvent, from, hmid, id, ipAddress, linkId, location, portalId, recipient, response, sentBy, smtpId, subject, type, url, userAgent |
| forms | deletedAt, portalId, guid, name, action, method, cssClass, redirect, submitText, followUpId, notifyRecipients, leadNurturingCampaignId, formFieldGroups, createdAt, updatedAt, performableHtml, migratedFrom, ignoreCurrentValues, deletable, inlineMessage, tmsId, captchaEnabled, campaignGuid, cloneable, editable, formType, metaData |
| workflows | name, id, type, enabled, insertedAt, updatedAt, personaTagIds, contactListIds |
| owners | portalId, ownerId, type, firstName, lastName, email, createdAt, signature, updatedAt, hasContactsAccess, isActive, activeUserId, userIdIncludingInactive, remoteList |
| campaigns | appId, appName, contentId, counters, id, name, numIncluded, numQueued, subType, subject, type |
| contact_lists | parentId, metaData, dynamic, name, filters, portalId, createdAt, listId, updatedAt, internalListId, readOnly, deleteable, listType, archived |
| contacts | vid, canonical-vid, merged-vids, portal-id, is-contact, profile-token, profile-url, associated-company, identity-profiles, list-memberships, form-submissions, merge-audits, properties, property_aircall_last_call_at, property_alternate_number, property_alternate_number_2, property_amp_email**_template_request, property_amp_email_approval_verified, property_amp_email_sequence_sent, property_amp_rendering_date, property_bfcm_referrercloned_, property_calendar_link, property_calendar_link_greater_than_50k, property_calendly_id_inbound, property_calendly_inbound_timezone, property_calendly_timezone, property_call_activity, property_call_outcome, property_called_, property_campaign_sent, property_case_study, property_category, property_cb_autocollection, property_cb_billingaddress, property_cb_billingcity, property_cb_billingcountry, property_cb_billingcountryiso, property_cb_billingemail, property_cb_billingfirstname, property_cb_billinglastname, property_cb_billingphone, property_cb_billingstate, property_cb_billingstateiso, property_cb_billingzip, property_cb_currencycode, property_cb_customermrr, property_cb_dueinvoicescount, property_cb_duesince, property_cb_invoiceamountpaid, property_cb_nettermdays, property_cb_nextbillingamount, property_cb_nextbillingat, property_cb_paymentmethodstatus, property_cb_paymentmethodtype, property_cb_planquantity, property_cb_ponumber, property_cb_preferredcurrencycode, property_cb_product, property_cb_remainingbillingcycles, property_cb_setupfee, property_cb_subscriptionid, property_cb_subscriptionmrr, property_cb_subscriptiostatus, property_cb_taxexemptstatus, property_cb_totaldues, property_chargebee_customer_site, property_chargebeecustomerid, property_closed_lost_reason, property_company_size, property_contact_added, property_context_personalization, property_conversation_status, property_country_name, property_course_completion_date, property_course_enrollment, property_course_enrollment_date, property_daily_mailmodo_smtp_limit, property_date_of_birth, property_date_of_incorporation, property_days_to_close, property_deal_community, property_degree, property_demo_by, property_demo_date_create_date, property_demo_done, property_demo_month1, property_demo_monthyear, property_demo_schedule_date_z, property_demo_source, property_demo_status, property_designation_of_poc, property_designation_of_poccloned_, property_domain_added, property_eg, property_email_status, property_email_tool_outbound, property_email_volume_outbound, property_employees_size, property_enrolled_sequence, property_event, property_event_name, property_event_type, property_field_of_study, property_final_asssignment, property_final_status, property_first_conversion_date, property_first_conversion_event_name, property_first_deal_created_date, property_first_name_sequence, property_funnel_status, property_gender, property_graduation_date, property_hasfpt, property_how_are_you_planning_to_use_mailmodousecase_, property_how_did_you_hear_about_us_, property_how_many_emailers_do_you_send_per_month_, property_how_many_emails_will_you_be_sending_every_month_, property_how_old_is_your_company_, property_hs_additional_emails, property_hs_all_contact_vids, property_hs_analytics_first_touch_converting_campaign, property_hs_analytics_last_touch_converting_campaign, property_hs_avatar_filemanager_key, property_hs_buying_role, property_hs_calculated_form_submissions, property_hs_calculated_merged_vids, property_hs_calculated_mobile_number, property_hs_calculated_phone_number, property_hs_calculated_phone_number_area_code, property_hs_calculated_phone_number_country_code, property_hs_calculated_phone_number_region_code, property_hs_clicked_linkedin_ad, property_hs_content_membership_email_confirmed, property_hs_content_membership_follow_up_enqueued_at, property_hs_content_membership_notes, property_hs_content_membership_registered_at, property_hs_content_membership_registration_domain_sent_to, property_hs_content_membership_registration_email_sent_at, property_hs_content_membership_status, property_hs_conversations_visitor_email, property_hs_count_is_unworked, property_hs_count_is_worked, property_hs_created_by_conversations, property_hs_created_by_user_id, property_hs_createdate, property_hs_date_entered_customer, property_hs_date_entered_evangelist, property_hs_date_entered_lead, property_hs_date_entered_marketingqualifiedlead, property_hs_date_entered_opportunity, property_hs_date_entered_other, property_hs_date_entered_salesqualifiedlead, property_hs_date_entered_subscriber, property_hs_date_exited_customer, property_hs_date_exited_evangelist, property_hs_date_exited_lead, property_hs_date_exited_marketingqualifiedlead, property_hs_date_exited_opportunity, property_hs_date_exited_other, property_hs_date_exited_salesqualifiedlead, property_hs_date_exited_subscriber, property_hs_document_last_revisited, property_hs_email_bad_address, property_hs_email_customer_quarantined_reason, property_hs_email_domain, property_hs_email_hard_bounce_reason, property_hs_email_hard_bounce_reason_enum, property_hs_email_quarantined, property_hs_email_quarantined_reason, property_hs_email_sends_since_last_engagement, property_hs_emailconfirmationstatus, property_hs_facebook_ad_clicked, property_hs_facebook_click_id, property_hs_first_engagement_object_id, property_hs_first_subscription_create_date, property_hs_google_click_id, property_hs_has_active_subscription, property_hs_ip_timezone, property_hs_is_contact, property_hs_is_unworked, property_hs_last_sales_activity_date, property_hs_last_sales_activity_timestamp, property_hs_last_sales_activity_type, property_hs_lastmodifieddate, property_hs_latest_sequence_ended_date, property_hs_latest_sequence_enrolled, property_hs_latest_sequence_enrolled_date, property_hs_latest_sequence_finished_date, property_hs_latest_sequence_unenrolled_date, property_hs_latest_source_timestamp, property_hs_latest_subscription_create_date, property_hs_lead_status, property_hs_legal_basis, property_hs_linkedin_ad_clicked, property_hs_marketable_reason_id, property_hs_marketable_reason_type, property_hs_marketable_status, property_hs_marketable_until_renewal, property_hs_merged_object_ids, property_hs_object_id, property_hs_pinned_engagement_id, property_hs_pipeline, property_hs_read_only, property_hs_sa_first_engagement_date, property_hs_sa_first_engagement_descr, property_hs_sa_first_engagement_object_type, property_hs_sales_email_last_clicked, property_hs_sales_email_last_opened, property_hs_searchable_calculated_international_mobile_number, property_hs_searchable_calculated_international_phone_number, property_hs_searchable_calculated_mobile_number, property_hs_searchable_calculated_phone_number, property_hs_sequences_actively_enrolled_count, property_hs_sequences_enrolled_count, property_hs_sequences_is_enrolled, property_hs_testpurge, property_hs_testrollback, property_hs_time_in_customer, property_hs_time_in_evangelist, property_hs_time_in_lead, property_hs_time_in_marketingqualifiedlead, property_hs_time_in_opportunity, property_hs_time_in_other, property_hs_time_in_salesqualifiedlead, property_hs_time_in_subscriber, property_hs_time_to_first_engagement, property_hs_timezone, property_hs_unique_creation_key, property_hs_updated_by_user_id, property_hs_user_ids_of_all_notification_followers, property_hs_user_ids_of_all_notification_unfollowers, property_hs_user_ids_of_all_owners, property_hubspot_owner_assigneddate, property_if_you_can_t_find_your_accelerator_investor_in_our_partner_directory_please_introduce_your_acccelar, property_inbound_outbound__cloned_, property_invalid_number, property_ip_city, property_ip_country, property_ip_country_code, property_ip_latlon, property_ip_state, property_ip_state_code, property_ip_zipcode, property_job_function, property_keywords, property_last_aircall_call_outcome, property_last_used_aircall_phone_number, property_last_used_aircall_tags, property_lastmodifieddate, property_lead_source, property_lead_source_1, property_lead_stage_trial, property_lifecycle_stages, property_linkedin_request_status, property_linkedin_url, property_manage543221, property_marital_status, property_marketing_emailsdebug, property_metric, property_military_status, property_monthly_email_limit, property_name, property_nifpt_reasons, property_num_associated_deals, property_num_conversion_events, property_num_unique_conversion_events, property_number_of_clients, property_number_of_times_connected, property_old_lead_status, property_p_sstatement, property_paid_user, property_partner_name, property_partner_name_us, property_partner_type, property_personalized_line, property_phone_number_country_code, property_pitchground_email_limit, property_pitchground_plan_type, property_plan, property_plan_type, property_point_of_contact, property_primary_use_case, property_probable_usecaseemail_copy, property_pu1, property_pu1_1, property_pu2, property_pu3, property_pu4, property_recent_conversion_date, property_recent_conversion_event_name, property_recent_deal_amount, property_recent_deal_close_date, property_referral_id, property_relationship_status, property_reply_sequence, property_requested_template, property_requested_template**amp_email, property_rh_meeting_status, property_rt, property_sales_funnel, property_school, property_seder_email_added_date, property_sender_email_added_date, property_seniority, property_signup_date, property_start_date, property_start_outbound_flow, property_subscription_cancelled_date, property_subscription_created_date, property_support_test, property_surya_calendly_link, property_target_industry, property_team_user, property_tech_used, property_template_created, property_temporary_sign_up_date, property_temporary_sign_up_time, property_test, property_ticket_raised, property_time, property_toplyne_tag, property_toplyne_tag_2, property_toplynescore, property_total_funding_raised, property_total_revenue, property_us_outbound_group, property_use_case_amp_email, property_usecase1, property_usecase2, property_user_id, property_utm_source, property_webinar_attended_date, property_what_is_the_email_tool_that_you_re_using_at_present_, property_what_kind_of_emailers_do_you_send_, property_which_email_marketing_tool_are_you_using_currently, property_why_do_you_want_to_use_mailmodo_, property_will_you_be_sending_mailers_to_cold_outreach_or_registered_users, property_work_email, property_zoom_webinar_attendance_average_duration, property_zoom_webinar_attendance_count, property_zoom_webinar_joinlink, property_zoom_webinar_registration_count, property_zoominfo_company_info, property_firstname, property_hs_analytics_first_url, property_hs_email_delivered, property_hs_email_optout_14557112, property_hs_email_optout_16865272, property_hs_email_optout_20351768, property_twitterhandle, property_calendly_question_1, property_currentlyinworkflow, property_hs_analytics_last_url, property_hs_email_open, property_lastname, property_rh_meeting_type, property_calendly_answer_1, property_hs_analytics_num_page_views, property_hs_email_click, property_salutation, property_calendly_question_2, property_email, property_hs_analytics_num_visits, property_hs_email_bounce, property_hs_persona, property_rh_meeting_time, property_rh_no_show, property_calendly_answer_2, property_hs_analytics_num_event_completions, property_hs_email_optout, property_mobilephone, property_phone, property_calendly_question_3, property_fax, property_hs_analytics_first_timestamp, property_hs_email_last_email_name, property_hs_email_last_send_date, property_address, property_calendly_answer_3, property_engagements_last_meeting_booked, property_engagements_last_meeting_booked_campaign, property_engagements_last_meeting_booked_medium, property_engagements_last_meeting_booked_source, property_hs_analytics_first_visit_timestamp, property_hs_email_last_open_date, property_hs_latest_meeting_activity, property_hs_sales_email_last_replied, property_hubspot_owner_id, property_notes_last_contacted, property_notes_last_updated, property_notes_next_activity_date, property_num_contacted_notes, property_num_notes, property_surveymonkeyeventlastupdated, property_webinareventlastupdated, property_calendly_question_4, property_city, property_hs_analytics_last_timestamp, property_hs_email_last_click_date, property_hubspot_team_id, property_calendly_answer_4, property_hs_all_owner_ids, property_hs_analytics_last_visit_timestamp, property_hs_email_first_send_date, property_state, property_calendly_question_5, property_hs_all_team_ids, property_hs_analytics_source, property_hs_email_first_open_date, property_hs_latest_source, property_zip, property_calendly_answer_5, property_country, property_hs_all_accessible_team_ids, property_hs_analytics_source_data_1, property_hs_email_first_click_date, property_hs_latest_source_data_1, property_calendly_question_6, property_hs_analytics_source_data_2, property_hs_email_is_ineligible, property_hs_language, property_hs_latest_source_data_2, property_calendly_answer_6, property_hs_analytics_first_referrer, property_hs_email_first_reply_date, property_jobtitle, property_calendly_question_7, property_hs_analytics_last_referrer, property_hs_email_last_reply_date, property_message, property_calendly_answer_7, property_closedate, property_hs_analytics_average_page_views, property_hs_email_replied, property_calendly_question_8, property_hs_analytics_revenue, property_hs_lifecyclestage_lead_date, property_hs_lifecyclestage_marketingqualifiedlead_date, property_hs_lifecyclestage_opportunity_date, property_lifecyclestage, property_calendly_answer_8, property_hs_lifecyclestage_salesqualifiedlead_date, property_calendly_question_9, property_createdate, property_hs_lifecyclestage_evangelist_date, property_calendly_answer_9, property_hs_lifecyclestage_customer_date, property_hubspotscore, property_calendly_question_10, property_company, property_hs_lifecyclestage_subscriber_date, property_calendly_answer_10, property_hs_lifecyclestage_other_date, property_website, property_numemployees, property_annualrevenue, property_industry, property_associatedcompanyid, property_associatedcompanylastupdated, properties_versions |
| companies_properties | name, label, description, groupName, type, fieldType, hidden, hubspotDefined, createdAt, updatedAt, options |
| companies | portalId, companyId, properties, property_about_us, property_alexa_rank, property_category, property_cb_totaldueinvoicescount, property_cb_totaldues, property_cb_totalinvoiceamountpaid, property_cb_totalnoofsubscription, property_cb_totalsubscriptionmrr, property_closedate_timestamp_earliest_value_a2a17e6e, property_company_fb_url, property_company_twitter_url, property_facebookfans, property_first_contact_createdate_timestamp_earliest_value_78b50eea, property_first_conversion_date, property_first_conversion_date_timestamp_earliest_value_61f58f2c, property_first_conversion_event_name, property_first_conversion_event_name_timestamp_earliest_value_68ddae0a, property_first_deal_created_date, property_founded_year, property_hs_additional_domains, property_hs_all_assigned_business_unit_ids, property_hs_analytics_first_timestamp, property_hs_analytics_first_timestamp_timestamp_earliest_value_11e3a63a, property_hs_analytics_first_touch_converting_campaign, property_hs_analytics_first_touch_converting_campaign_timestamp_earliest_value_4757fe10, property_hs_analytics_first_visit_timestamp, property_hs_analytics_first_visit_timestamp_timestamp_earliest_value_accc17ae, property_hs_analytics_last_timestamp, property_hs_analytics_last_timestamp_timestamp_latest_value_4e16365a, property_hs_analytics_last_touch_converting_campaign, property_hs_analytics_last_touch_converting_campaign_timestamp_latest_value_81a64e30, property_hs_analytics_last_visit_timestamp, property_hs_analytics_last_visit_timestamp_timestamp_latest_value_999a0fce, property_hs_analytics_latest_source, property_hs_analytics_latest_source_data_1, property_hs_analytics_latest_source_data_2, property_hs_analytics_latest_source_timestamp, property_hs_analytics_num_page_views, property_hs_analytics_num_page_views_cardinality_sum_e46e85b0, property_hs_analytics_num_visits, property_hs_analytics_num_visits_cardinality_sum_53d952a6, property_hs_analytics_source, property_hs_analytics_source_data_1, property_hs_analytics_source_data_1_timestamp_earliest_value_9b2f1fa1, property_hs_analytics_source_data_2, property_hs_analytics_source_data_2_timestamp_earliest_value_9b2f9400, property_hs_analytics_source_timestamp_earliest_value_25a3a52c, property_hs_avatar_filemanager_key, property_hs_created_by_user_id, property_hs_createdate, property_hs_date_entered_customer, property_hs_date_entered_evangelist, property_hs_date_entered_lead, property_hs_date_entered_marketingqualifiedlead, property_hs_date_entered_opportunity, property_hs_date_entered_other, property_hs_date_entered_salesqualifiedlead, property_hs_date_entered_subscriber, property_hs_date_exited_customer, property_hs_date_exited_evangelist, property_hs_date_exited_lead, property_hs_date_exited_marketingqualifiedlead, property_hs_date_exited_opportunity, property_hs_date_exited_other, property_hs_date_exited_salesqualifiedlead, property_hs_date_exited_subscriber, property_hs_ideal_customer_profile, property_hs_is_target_account, property_hs_last_booked_meeting_date, property_hs_last_logged_call_date, property_hs_last_open_task_date, property_hs_last_sales_activity_date, property_hs_last_sales_activity_timestamp, property_hs_last_sales_activity_type, property_hs_lastmodifieddate, property_hs_latest_createdate_of_active_subscriptions, property_hs_merged_object_ids, property_hs_num_blockers, property_hs_num_contacts_with_buying_roles, property_hs_num_decision_makers, property_hs_num_open_deals, property_hs_object_id, property_hs_pinned_engagement_id, property_hs_pipeline, property_hs_predictivecontactscore_v2_next_max_max_d4e58c1e, property_hs_read_only, property_hs_target_account, property_hs_target_account_probability, property_hs_target_account_recommendation_snooze_time, property_hs_target_account_recommendation_state, property_hs_time_in_customer, property_hs_time_in_evangelist, property_hs_time_in_lead, property_hs_time_in_marketingqualifiedlead, property_hs_time_in_opportunity, property_hs_time_in_other, property_hs_time_in_salesqualifiedlead, property_hs_time_in_subscriber, property_hs_total_deal_value, property_hs_unique_creation_key, property_hs_updated_by_user_id, property_hs_user_ids_of_all_notification_followers, property_hs_user_ids_of_all_notification_unfollowers, property_hs_user_ids_of_all_owners, property_hubspot_owner_assigneddate, property_industry_1, property_is_public, property_looking_for, property_marketing_team_size, property_num_associated_contacts, property_num_associated_deals, property_num_conversion_events, property_num_conversion_events_cardinality_sum_d095f14b, property_primary_industry, property_recent_conversion_date, property_recent_conversion_date_timestamp_latest_value_72856da1, property_recent_conversion_event_name, property_recent_conversion_event_name_timestamp_latest_value_66c820bf, property_recent_deal_amount, property_recent_deal_close_date, property_revenue, property_segment, property_size_of_business, property_sub_industry, property_timezone, property_total_funding_amount__000_s_, property_total_money_raised, property_total_revenue, property_total_team_size_on_linkedin, property_user_status, property_name, property_twitterhandle, property_phone, property_twitterbio, property_twitterfollowers, property_address, property_address2, property_facebook_company_page, property_city, property_linkedin_company_page, property_linkedinbio, property_state, property_googleplus_page, property_engagements_last_meeting_booked, property_engagements_last_meeting_booked_campaign, property_engagements_last_meeting_booked_medium, property_engagements_last_meeting_booked_source, property_hs_latest_meeting_activity, property_hs_sales_email_last_replied, property_hubspot_owner_id, property_notes_last_contacted, property_notes_last_updated, property_notes_next_activity_date, property_num_contacted_notes, property_num_notes, property_zip, property_country, property_hubspot_team_id, property_hs_all_owner_ids, property_website, property_domain, property_hs_all_team_ids, property_hs_all_accessible_team_ids, property_numberofemployees, property_industry, property_annualrevenue, property_lifecyclestage, property_hs_lead_status, property_hs_parent_company_id, property_type, property_description, property_hs_num_child_companies, property_hubspotscore, property_createdate, property_closedate, property_first_contact_createdate, property_days_to_close, property_web_technologies, properties_versions |
| deals | portalId, dealId, isDeleted, associations, properties, property_amount_in_home_currency, property_amp_approved, property_amp_rendering_date, property_analysis_of_campaign, property_category, property_cb_currencycode, property_cb_dueinvoicescount, property_cb_duesince, property_cb_nextbillingamount, property_cb_nextbillingat, property_cb_planquantity, property_cb_ponumber, property_cb_product, property_cb_remainingbillingcycles, property_cb_setupfee, property_cb_subscriptionid, property_cb_subscriptionmrr, property_cb_subscriptionstatus, property_cb_totaldues, property_chargebee_subscription_site, property_churn_date, property_churn_reason, property_churn_reason_note, property_churn_risk_note, property_churn_risk_reason, property_close_datedemo_date, property_cold_emailing, property_company_revenue, property_country, property_cs_checklist, property_cs_engagement_steady, property_csm_required, property_current_click_rate, property_current_open_rate, property_days_to_close, property_deal_currency_code, property_deal_owner_sales, property_deal_source, property_demo_date, property_demo_done_by, property_demo_source, property_designation_of_poc, property_domain_added, property_email_tools, property_email_volume, property_employees_size, property_eventcontact, property_event**_outbound, property_expected_close_date, property_expected_go_live_date, property_features_to_adopt, property_first_campaign_sent, property_fpt_reason, property_funding, property_hasfpt, property_hs_acv, property_hs_all_assigned_business_unit_ids, property_hs_all_collaborator_owner_ids, property_hs_all_deal_split_owner_ids, property_hs_analytics_latest_source, property_hs_analytics_latest_source_company, property_hs_analytics_latest_source_contact, property_hs_analytics_latest_source_data_1, property_hs_analytics_latest_source_data_1_company, property_hs_analytics_latest_source_data_1_contact, property_hs_analytics_latest_source_data_2, property_hs_analytics_latest_source_data_2_company, property_hs_analytics_latest_source_data_2_contact, property_hs_analytics_latest_source_timestamp, property_hs_analytics_latest_source_timestamp_company, property_hs_analytics_latest_source_timestamp_contact, property_hs_analytics_source, property_hs_analytics_source_data_1, property_hs_analytics_source_data_2, property_hs_arr, property_hs_campaign, property_hs_closed_amount, property_hs_closed_amount_in_home_currency, property_hs_created_by_user_id, property_hs_date_entered_11962418, property_hs_date_entered_12522925, property_hs_date_entered_12522926, property_hs_date_entered_12522930, property_hs_date_entered_12522931, property_hs_date_entered_12522932, property_hs_date_entered_13913418, property_hs_date_entered_13913419, property_hs_date_entered_13913420, property_hs_date_entered_13913423, property_hs_date_entered_13913424, property_hs_date_entered_15048777, property_hs_date_entered_15048778, property_hs_date_entered_15048779, property_hs_date_entered_15048780, property_hs_date_entered_15048781, property_hs_date_entered_15048782, property_hs_date_entered_15048783, property_hs_date_entered_15050830, property_hs_date_entered_15312727, property_hs_date_entered_15324979, property_hs_date_entered_16651699, property_hs_date_entered_16651700, property_hs_date_entered_16671271, property_hs_date_entered_16671272, property_hs_date_entered_16671274, property_hs_date_entered_16671275, property_hs_date_entered_16671276, property_hs_date_entered_16671277, property_hs_date_entered_18017072, property_hs_date_entered_28554760, property_hs_date_entered_28631411, property_hs_date_entered_28631412, property_hs_date_entered_28631413, property_hs_date_entered_28631414, property_hs_date_entered_28631415, property_hs_date_entered_28631416, property_hs_date_entered_28631417, property_hs_date_entered_29605376, property_hs_date_entered_32175736, property_hs_date_entered_32175737, property_hs_date_entered_32175738, property_hs_date_entered_32175739, property_hs_date_entered_32175740, property_hs_date_entered_32175741, property_hs_date_entered_32175742, property_hs_date_entered_5233567, property_hs_date_entered_5253912, property_hs_date_entered_5253913, property_hs_date_entered_5253914, property_hs_date_entered_5253915, property_hs_date_entered_5253916, property_hs_date_entered_appointmentscheduled, property_hs_date_entered_closedlost, property_hs_date_entered_closedwon, property_hs_date_entered_contractsent, property_hs_date_entered_decisionmakerboughtin, property_hs_date_entered_presentationscheduled, property_hs_date_entered_qualifiedtobuy, property_hs_date_exited_11962418, property_hs_date_exited_12522925, property_hs_date_exited_12522926, property_hs_date_exited_12522930, property_hs_date_exited_12522931, property_hs_date_exited_12522932, property_hs_date_exited_13913418, property_hs_date_exited_13913419, property_hs_date_exited_13913420, property_hs_date_exited_13913423, property_hs_date_exited_13913424, property_hs_date_exited_15048777, property_hs_date_exited_15048778, property_hs_date_exited_15048779, property_hs_date_exited_15048780, property_hs_date_exited_15048781, property_hs_date_exited_15048782, property_hs_date_exited_15048783, property_hs_date_exited_15050830, property_hs_date_exited_15312727, property_hs_date_exited_15324979, property_hs_date_exited_16651699, property_hs_date_exited_16651700, property_hs_date_exited_16671271, property_hs_date_exited_16671272, property_hs_date_exited_16671274, property_hs_date_exited_16671275, property_hs_date_exited_16671276, property_hs_date_exited_16671277, property_hs_date_exited_18017072, property_hs_date_exited_28554760, property_hs_date_exited_28631411, property_hs_date_exited_28631412, property_hs_date_exited_28631413, property_hs_date_exited_28631414, property_hs_date_exited_28631415, property_hs_date_exited_28631416, property_hs_date_exited_28631417, property_hs_date_exited_29605376, property_hs_date_exited_32175736, property_hs_date_exited_32175737, property_hs_date_exited_32175738, property_hs_date_exited_32175739, property_hs_date_exited_32175740, property_hs_date_exited_32175741, property_hs_date_exited_32175742, property_hs_date_exited_5233567, property_hs_date_exited_5253912, property_hs_date_exited_5253913, property_hs_date_exited_5253914, property_hs_date_exited_5253915, property_hs_date_exited_5253916, property_hs_date_exited_appointmentscheduled, property_hs_date_exited_closedlost, property_hs_date_exited_closedwon, property_hs_date_exited_contractsent, property_hs_date_exited_decisionmakerboughtin, property_hs_date_exited_presentationscheduled, property_hs_date_exited_qualifiedtobuy, property_hs_deal_amount_calculation_preference, property_hs_deal_stage_probability, property_hs_deal_stage_probability_shadow, property_hs_exchange_rate, property_hs_forecast_amount, property_hs_forecast_probability, property_hs_is_closed, property_hs_is_closed_won, property_hs_lastmodifieddate, property_hs_likelihood_to_close, property_hs_line_item_global_term_hs_discount_percentage, property_hs_line_item_global_term_hs_discount_percentage_enabled, property_hs_line_item_global_term_hs_recurring_billing_period, property_hs_line_item_global_term_hs_recurring_billing_period_enabled, property_hs_line_item_global_term_hs_recurring_billing_start_date, property_hs_line_item_global_term_hs_recurring_billing_start_date_enabled, property_hs_line_item_global_term_recurringbillingfrequency, property_hs_line_item_global_term_recurringbillingfrequency_enabled, property_hs_manual_forecast_category, property_hs_merged_object_ids, property_hs_mrr, property_hs_next_step, property_hs_num_target_accounts, property_hs_object_id, property_hs_pinned_engagement_id, property_hs_predicted_amount, property_hs_predicted_amount_in_home_currency, property_hs_priority, property_hs_projected_amount, property_hs_projected_amount_in_home_currency, property_hs_read_only, property_hs_tcv, property_hs_time_in_11962418, property_hs_time_in_12522925, property_hs_time_in_12522926, property_hs_time_in_12522930, property_hs_time_in_12522931, property_hs_time_in_12522932, property_hs_time_in_13913418, property_hs_time_in_13913419, property_hs_time_in_13913420, property_hs_time_in_13913423, property_hs_time_in_13913424, property_hs_time_in_15048777, property_hs_time_in_15048778, property_hs_time_in_15048779, property_hs_time_in_15048780, property_hs_time_in_15048781, property_hs_time_in_15048782, property_hs_time_in_15048783, property_hs_time_in_15050830, property_hs_time_in_15312727, property_hs_time_in_15324979, property_hs_time_in_16651699, property_hs_time_in_16651700, property_hs_time_in_16671271, property_hs_time_in_16671272, property_hs_time_in_16671274, property_hs_time_in_16671275, property_hs_time_in_16671276, property_hs_time_in_16671277, property_hs_time_in_18017072, property_hs_time_in_28554760, property_hs_time_in_28631411, property_hs_time_in_28631412, property_hs_time_in_28631413, property_hs_time_in_28631414, property_hs_time_in_28631415, property_hs_time_in_28631416, property_hs_time_in_28631417, property_hs_time_in_29605376, property_hs_time_in_32175736, property_hs_time_in_32175737, property_hs_time_in_32175738, property_hs_time_in_32175739, property_hs_time_in_32175740, property_hs_time_in_32175741, property_hs_time_in_32175742, property_hs_time_in_5233567, property_hs_time_in_5253912, property_hs_time_in_5253913, property_hs_time_in_5253914, property_hs_time_in_5253915, property_hs_time_in_5253916, property_hs_time_in_appointmentscheduled, property_hs_time_in_closedlost, property_hs_time_in_closedwon, property_hs_time_in_contractsent, property_hs_time_in_decisionmakerboughtin, property_hs_time_in_presentationscheduled, property_hs_time_in_qualifiedtobuy, property_hs_unique_creation_key, property_hs_updated_by_user_id, property_hs_user_ids_of_all_notification_followers, property_hs_user_ids_of_all_notification_unfollowers, property_hs_user_ids_of_all_owners, property_hubspot_owner_assigneddate, property_hubspotcontact, property_inbound_outbound, property_industry, property_integration_required, property_live_campaign_launched, property_minimum_2_campaigns, property_n50amp_emails, property_n50monthly_utilization, property_onboarding_call, property_onboarding_date, property_org_structure_defined, property_partnership_type, property_phone_number, property_plan, property_pocyes_no_, property_poc_owner_from_cs_team, property_poc_use_case, property_point_of_contact, property_point_of_contact_businessemail_, property_point_of_contact_businessmobile_, property_point_of_contact_marketingemail_, property_point_of_contact_marketing**mobile_, property_postmaster_added, property_potential_to_grow, property_potential_to_grow__why_, property_primary_expectation_from_mailmodo, property_primary_lost_reason, property_primary_use_case, property_qualification, property_secondary_use_case, property_self_serve, property_sender_email_added_date, property_size_of_mailing_list, property_success_date, property_success_metric_met__open_click_submission, property_suggestion_passed_on, property_team_size, property_type_of_mails, property_upsell_opportunity_note, property_upsell_opportunity_reason, property_user_id, property_value_added_services_offered, property_warm_up_done, property_warm_up_needed, property_website, property_dealname, property_amount, property_dealstage, property_pipeline, property_closedate, property_createdate, property_engagements_last_meeting_booked, property_engagements_last_meeting_booked_campaign, property_engagements_last_meeting_booked_medium, property_engagements_last_meeting_booked_source, property_hs_latest_meeting_activity, property_hs_sales_email_last_replied, property_hubspot_owner_id, property_notes_last_contacted, property_notes_last_updated, property_notes_next_activity_date, property_num_contacted_notes, property_num_notes, property_hs_createdate, property_hubspot_team_id, property_dealtype, property_hs_all_owner_ids, property_description, property_hs_all_team_ids, property_hs_all_accessible_team_ids, property_num_associated_contacts, property_closed_lost_reason, property_closed_won_reason, properties_versions |
| deal_pipelines | pipelineId, stages, label, active, displayOrder, staticDefault |
| engagements | engagement_id, lastUpdated, engagement, associations, attachments, metadata |
| contacts_by_company | contact-id, company-id |
Credentials Setup
Follow the steps below to get the credentials you need to use the HubSpot connector.
📘 The HubSpot developer account is different from a normal HubSpot account. Make sure to register for a Developer Account or you will not see the Manage App options.
The first thing that you need to do to create a HubSpot OAuth app is to create a free HubSpot developer account.
Once logged into the HubSpot developer portal, your home page should look similar to this. Navigate to the Apps tab or click Manage apps.
On your Apps page, you should navigate to the Create App button on the top right hand side of your screen. Go ahead and click on the button.
On this page, make sure to name your Public app, upload your app logo, and add a description. Once you have done that, click Save.
The next step is to head to the Auth tab.
Next, you need to scroll down and set the Redirect URL to <https://hotglue.xyz/callback>
As you continue to scroll, you will now see the scopes section. This allows you to choose what your product will be able to pull out of HubSpot.
I have set up a sample configuration that allows Read access to every endpoint in the CRM. If you have questions about what your scopes should be, feel free to ask us!
🚧 Select the CRM Schemas endpoints
Please make sure you check off all of the scopes that begin with crm.schemas. You can see them above in the red outline.
The last thing you must check off for your app to work is the oauth scope. If you do not check off this scope, your users won’t be able to connect! Once you are done configuring your scopes, click the Save button.
Now you should scroll up back to the top of your page and copy the Client ID and Client Secret into hotglue!
Make sure to paste the Scopes list (space separated) from your HubSpot app into hotglue, or you may get a conection error. You can access this from the Auth tab of your HubSpot app settings as pictured below.
That’s it!