Skip to main content
Docs
Feature Requests Onboarding Trust Center Status Page

Community

Connector Improvement: Add HubSpot Projects Object Support to HubSpot Connector

Answered
IT Super-Admin User

Hi Fivetran Support Team,

I'm reaching out to submit a feature request for the HubSpot connector.

We currently use Fivetran to sync our HubSpot data into Google BigQuery, and we've noticed that the Projects object is not supported by the connector. This data is really needed for our reporting and analytics needs.

We would like to request support for the following tables:

1. PROJECT table — via GET /crm/v3/objects/projects
   Including all standard properties:
   - hs_name, hs_description, hs_status, hs_type, hs_priority
   - hs_pipeline, hs_pipeline_stage
   - hs_start_date, hs_target_due_date, hs_close_date
   - hubspot_owner_id
   - hs_amount_paid, hs_amount_remaining, hs_total_cost
   - hs_createdate, hs_lastmodifieddate

   We also request support for custom properties on the Projects object. These could be discovered dynamically via GET /crm/v3/properties/projects, which returns all properties defined on the object (both standard and custom) for a given HubSpot account.

2. PROJECT_TASK table — via GET /crm/v3/objects/projects/{id}/associations/tasks
   - id, project_id, name, status, due_date, assignee_id, created_at, updated_at

3. PROJECT_ASSOCIATION table — associations between Projects and related CRM objects
   - via GET /crm/v3/objects/projects/{id}/associations/deals
   - via GET /crm/v3/objects/projects/{id}/associations/companies
   - via GET /crm/v3/objects/projects/{id}/associations/contacts

Required HubSpot API scopes: crm.objects.projects.read and crm.schemas.projects.read.

Could you please let us know:
- Whether this is already on your roadmap?
- If so, what is the expected timeline?
- If not, can this be added as a feature request for evaluation?

Thank you for your time and support.

Best regards

Please sign in to leave a comment.

Comments

2 comments

Date Votes
  • Official comment
    Vignesh Rengaraj Fivetranner

    Hi IT Admin team ,

    This request has also been raised by few other customers, and we recognize this as a valuable improvement to the HubSpot connector.Support for the HubSpot Projects object, including standard and custom properties as well as associations, is on our roadmap and we are planning to implement this in the near term.

    To help ensure our solution aligns with your needs, could you share more about your specific reporting or analytics use cases for the Projects data? Understanding your goals will help us prioritize the right details and structure for these new tables.

    We'll keep this thread updated with progress and notify you once the functionality is released.

    Thanks,
    Vignesh

  • IT Super-Admin User

    Hi Vignesh

    Our business team is using HubSpot Projects in order to feed Kantata Workspace when a deal is won.

    Having Project data in BigQuery will allow us to build new reports in Looker studio in order to help our business team to have an overview of all the HubSpot Projects and all the related KPIs.

    When you are talking about the near term, do you have an estimated date or timeline ?

     

    Thank you