Google Apps Script connect to HubSpot

Developer Support APIs & Integrations
,
1

Hey everyone!

We are building a Workflow using a Google Apps Script which the idea is to connect to HubSpot (either HS Workflow or API). The flow is like this:

1. We download the monthly renewals from HubSpot and import them into Google Sheets
2. In Google Sheets we run some operations for our customers using the Apps Script.
3. Later in the workflow, we want to trigger the import of Deal Creation information from Google Sheets into HubSpot and retrieve the Record ID back into Sheets.
4. This will allow us to create the line items with their respective Record IDs and
5. Finally send those line items into HubSpot to store and update the information for each customer.

I’m pretty confident this is achievable, but I want to speak with some experts to understand whether it’s doable within HubSpot Workflows or if it’s better to build a private app using the API.
Which option is more reliable, easier to build, maintenance, etc?

Thanks in advance!! :handshake:

2

Hi, @FQuintanaVicu :waving_hand: Thanks for sharing your post and including your details. Just to make sure you get accurate suggestions, One question to help our community members, do you have an Operations Hub Pro or Enterprise subscription? If not, you’ll want to stick with creating an app to handle everything.

Thanks for the additional information! — Jaycee

3

Thanks for looping in @Jaycee_Lewis. Yes, we do have and Operations Hub Pro or Enterprise :+1: