Skip to main content
Question

Troubleshooting Hubspot deal values syncing to Google Sheets via Zapier

  • March 20, 2026
  • 1 reply
  • 10 views

Hi! I am trying to pull in Hubspot deal property data into Zapier to then be created as new lines in an external GoogleSheet. I am able to sync my Hubspot and GoogleSheets to Zapier, but the returned values from Hubspot are only piping through as numeric values. 

 

I’ve seen other posts with similar issues but have not found a workable solution, any input would be appreciated!

 

The Deal Property Values i am trying to pull in are a mix of Date Range, Numeric Values, and Text (i.e. Hubspot Users and Owners, Company Names, Deal Stage)

 

1 reply

Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • March 21, 2026

Hi ​@kyas.io 

Date values are in UNIX millisecond format.

You can use a Formatter > Date & Time > Format step to change the format.

Formatter help: https://zapier.com/apps/formatter/integrations#help

 

The others indicate internal field IDs and linked records across different HubSpot objects.

You have to use other HubSpot steps to lookup a record by the ID to get the record details.

e.g. Find Company

e.g. Get Owner by ID