I carry out integrations with the help of third-party software. Even patching is carried out with the help of third-party software while also importing CSV files over to HubSpot. With Pipedream, I would just move data or transform it, and it is like a low-code platform to deal with any data problems faced by our company's clients. Pipedream is similar to Zapier. Unlike Zapier, the usage of Python in Pipedream is a little bit more complex. You can also use Python in Zapier, but there were certain functionalities you couldn't get, so my company moved over to Pipedream.
I don't remember whether the product was deployed on the cloud or on an on-premises model. For my use case, I decided to just put the code and use the code, and then use it with whatever source of data, like Excel or any other sources, while looking into streaming data and using Python to trigger the workflow or something like that and move all the data over to HubSpot.