Question

Connect data in Excel sheet with Hubspot crm to updat properties in a custom object

  • 13 February 2023
  • 4 replies
  • 95 views

Hi fellow Zappers,

Here’s a very sticky situation I’ve found myself into. Looking for an easy solution without custom code to solve this issue.

We want our rev-ops (Org metrics) data on hubspot which doesn’t fall under standard objects.

So, we want to create a custom object and the different data field to be added with custom properties.

We want our current excel sheet to sync with hubspot account and the respective properties to get updated with a ZAP (whenever a cell in excel updated, respective property to get updated in hubspot).

So far I’m unable to find this Action available?

Kindly help. 

 


This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

4 replies

Userlevel 7
Badge +14

Hi @Vabh 

Good question.

For custom objects, it’s likely the HubSpot API would have to be used: https://developers.hubspot.com/docs/api/overview

App APIs can be used in Zaps with the Webhooks app: https://zapier.com/apps/webhook/help

Hi there,

 

Thanks for your response Troy. 

Have discussed using Webhooks with hubspot support team but it seems MS Excel is not going to work with webhooks.

So if a required trigger is not yet added by Zapier, is there no other way to build that trigger or action?

 

Userlevel 7
Badge +14

@Vabh 

Zapier manages the HubSpot Zap app integration because it’s a popular app, whereas most other Zap app integrations are created/managed by the app developer, rather than Zapier.

 

API requests (triggers/actions) or webhook event notifications (triggers) are the way to configure triggers/actions that aren’t available via the Zap app integration.

 

These can be configured using the Webhooks app or the Code app.

Userlevel 7
Badge +14

@Vabh 

Feedback and feature requests can be submitted via a ticket to Zapier Support to be logged: https://zapier.com/app/get-help