HubSpot API connectors within Power Automate

Develop, Build & Integrate APIs & Integrations
,
1

Good afternoon,

Our use case is the following, and we can’t seem to make it happen, at least not for our intended purpose. We can’t use the HTTP method, as sensitive data could be updated in the process.

Basically, we would like to have Excel files (.csv, .xlsx) dropped in a folder, and these files, would be used to import contacts and create a list from these said contacts.

The lists can get quite massive (300K contacts or more), along with some additional properties that we would like to update during the import process.

However, when using the “Start an import” connector in Power Automate, it only asks for Content Type, and don’t seem to be able to specify any additionnal information from the imported file.

Could anyone assist in finding the proper method to have a list imported into HubSpot, knowing that the properties will always be different according to each new import, and are only for contacts. The unique identifier would be the email.

Thanks in advance for any assistance.

Jason

2

Hi. @JLetellier :waving_hand: Thanks for your question. It can be tough to get support for Power Automate questions (not your fault at all)

I’d like to invite some of our community members to the converstaion and folks who’ve asked or resolved Power Automate-relate questions — hey @AKhan786 @NThoman @SWesthagen and @SteveHTM @JBeatty do you have any related experience you can share with @JLetellier?

Thank you very much! — Jaycee

3

@JLetellier - I have no reference point with Power Automate, but I do know that this process could be automated using HubSpot import API calls.

Steve

4

Hi Jason, I know this was a few months back, but I don’t see a solution yet so I wanted to offer one for the community and in case you still need it.

Given you want to avoid HTTP requests, you can go the OAuth route with a custom connector and integrate HubSpot’s ‘Import’ API as @SteveHTM correctly suggested. It’s far too much to post here, so I wrote an article that explains how to implement the solution in detail.

5

My very brief and initial experience is this: we are going to use Zapier. We are a Microsoft partner, so I really wanted to use PowerAutomate. But the Zapier connector, triggers, and events are *so* much easier to use. So my strategy will be use PowerAutomate within the M365 stack, but just use Zapier when I want to automate HubSpot.