Skip to main content

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!

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!


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! 🤗