I have set up a workflow designed to automatically update a Google Sheet when a contact visits or converts on our website. The problem is, when I initially exported the data, the “Time last seen” and “Recent conversion date” were in recognisable format - e.g. 13/06/2024 11:08:00. Whenever the workflow triggers, however, it populates the field with a string of numbers, e.g. 1723557936277.
As far as I can tell, there is no clear time/date information communicated in this number, despite it being the “Time last seen” value exported straight from Hubspot. Can anyone help me understand what these numbers mean and/or how I can get an export working that outputs a time and date instead?
I have set up a workflow designed to automatically update a Google Sheet when a contact visits or converts on our website. The problem is, when I initially exported the data, the “Time last seen” and “Recent conversion date” were in recognisable format - e.g. 13/06/2024 11:08:00. Whenever the workflow triggers, however, it populates the field with a string of numbers, e.g. 1723557936277.
As far as I can tell, there is no clear time/date information communicated in this number, despite it being the “Time last seen” value exported straight from Hubspot. Can anyone help me understand what these numbers mean and/or how I can get an export working that outputs a time and date instead?
When you export the data in Hubspot they are already converting it for you. When you export via the workflow you are seeing the raw unconverted data as it is stored in the database which is a unix timestamp. If you run a column in your spreadsheet with the equation =EPOCHTODATE() it will convert the timestamp to readable date and you can then use the data however you like.