Skip to main content
Best answer

How do I automate HubSpot to Google Sheets for specific data in Zapier?


Hey there! 

I’m trying to automate a simple process between HubSpot and Google Sheets and need your help. 
When a lead fills out a contact form on HubSpot, add automatically a row in a Google Sheet. 

My Google sheet is composed with the following columns:
 

First Name Last Name Date Email Phone Number Original Source


I want the data from my contact form match with the columns of my sheet, so that:
First name = first name ;
last name = last name ;
date = recent conversion date ;
email = email
phone number = mobile phone number
original source = latest source

 

 

I’m at the “Create Spreadsheet Row” step, and the only data that is appearing from my form in Zapier is:

First name, last name, email, message, mobile phone number, ID, vid, HS Object Id. 

Do you know how I could add specific data from the form into Zapier? (Latest Source, Recent Conversion Date).

Thank you so much for your help!

Best answer by Troy TessaloneBest answer by Troy Tessalone

Hi @SebastienMKGT 

Some things to check/try:

  • Select the “Additional Properties to Retrieve”
  • Add a Zap action step: HubSpot - Find Contact
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

Troy Tessalone
Forum|alt.badge.img+14
  • Zapier Expert
  • 30340 replies
  • Answer
  • August 13, 2024

Hi @SebastienMKGT 

Some things to check/try:

  • Select the “Additional Properties to Retrieve”
  • Add a Zap action step: HubSpot - Find Contact

Hey Troy,
Thank you for your help! 
It worked!

 

Have a nice day!


ken.a
Forum|alt.badge.img+6
  • Zapier Staff
  • 6120 replies
  • August 15, 2024

That’s an awesome news @SebastienMKGT! A huge thanks to Troy for pointing you in the right direction!

If you have any other questions, please don’t hesitate to reach out to the Community. We’re always happy to help! 🤗