Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Best answer

Google Sheets update HubSpot Contact Record then Trigger Workflow

  • November 13, 2020
  • 3 replies
  • 82 views
D

I am creating a zap to push a tracking number from our shipping software into a field in Hubspot, when that record is updated a workflow in hubspot will trigger. We are dropping the customers shipping record into google sheets and plan to have the zap trigger when a new worksheet is created. We have everything setup. The question is how to update the HS record with the tracking number before the HS workflow is triggered. 

When you get to the action step in the zap “Create or Update Contact in Hubspot”, it is asking for the contact email for which a dropdown is there relating to the google sheet. I am not sure what to put in here?

 

 

Best answer by GetUWiredBest answer by GetUWired

What properties do you have on the worksheet? Is the client email something on that worksheet? You could try adding a step before to search the sheet that was just created. You’ll give the intermediary step the worksheet id from the trigger. Since you won’t know what value to search for, you could try the “Get Many Spreadsheet Rows” actions which will return a max of 20 rows from the sheet. 

 

Hope that helps! 

View original
Did this topic help you find an answer to your question?
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

3 replies

GetUWired
Forum|alt.badge.img+12
  • GetUWiredZapier Expert
  • Zapier Expert
  • 1030 replies
  • November 13, 2020

Just to clarify, are you creating a new worksheet each time you get a customers shipping or just a new row? 

 

I think you are wanting to trigger on a new row in google sheets. That way when the row with customer shipping information is added to a sheet it will trigger and give you back the customer info. 

D
  • Drose67Beginner
  • Author
  • Beginner
  • 1 reply
  • November 13, 2020

Thanks for the quick reply - We are adding a new worksheet each time. Regardless, the frustrating part is not knowing what to insert in the “contact email” field for the update contact in Hubspot action. It displays some options associated with the google sheet, but none of those pertain to where the email is. This is the first zap I have created for hubspot, so I might just be unfamiliar with how this part of it is used.

 

options that display now: 

 

GetUWired
Forum|alt.badge.img+12
  • GetUWiredZapier Expert
  • Zapier Expert
  • 1030 replies
  • Answer
  • November 13, 2020

What properties do you have on the worksheet? Is the client email something on that worksheet? You could try adding a step before to search the sheet that was just created. You’ll give the intermediary step the worksheet id from the trigger. Since you won’t know what value to search for, you could try the “Get Many Spreadsheet Rows” actions which will return a max of 20 rows from the sheet. 

 

Hope that helps! 

Terms & Conditions