Create deals from Google Sheets

[phtheref]

Hi!

I have an urgent need for create & update deals from Google Sheets to Hubspot. I managed to did this with zapier zap but it doesn't create line items. I can live without this (because all deals which are coming from Google sheet are using same line item SKU & product.

But this need an automation workflow where I could create one line item for each newly imported deals. Cannot find a way to create line item with workflow. Any way to do this. 

Or preferably manage this directly when importing data from Google Sheet.

[HFisher7]

@phtheref - This should be possible with Zapier.

Trigger = Update to Google Sheet
Action 1 = Create deal
Action 2 = Create line item

Action 3 = Create associations
 

[phtheref]

I have other urgent need... if anybody could check that one also. https://community.hubspot.com/t5/CRM/One-form-with-multiple-informatio/td-p/754498

[phtheref]

Thx!!

Need to try this...  Reason for this that we'll have 3-5 Int. Partners who are reselling our product. I need to see their pipeline&oppos but don't want to give them accounts to HS. Everybody is selling same product - only differences are start/close date & deal MRR amount. I have a plan to make this happen with Google Sheet. If someone have better idea - I'm happy to hear it.

[HFisher7 · Accepted solution]

@phtheref - If the reason for not wanting the partners as users in HubSpot was around data privacy, you could utilise a permission set to lock down what those users can access in your HubSpot portal: HubSpot user permissions guide

Add all the partners as users to a team called 'Partners' and only give them access to the deal object, where the deal record is a record they are the owner of.

They then will not be able to see any other object records (Contacts, Companies, Tickets or Custom objects) or deal records that they didn't add to the portal. 

[Josh]

Hi @phtheref,

When creating the deal from a workflow you can automatically add line items, but you cannot add line items to an existing deal from a workflow at this time.

Josh 

[phtheref]

Do they need paid license for creating & updating deals?

[HFisher7]

@phtheref - They don't, no.