CRM

ChrisAlexander
Member

Issues Updating Spreadsheet using Workflow

SOLVE

I'm working on creating a Deal Ledger for my company in Google Sheets that automatically updates as projects move through my sales pipeline. When I use the workflow to add a row, it appends the row to the very bottom of the spreadsheet instead of populating the first available row. It also exports the UserID as the numerical string value instead of the User's name. Dates are in Unix which I have to apply a formula to convert, which wouldn't be a problem except it adds a row outside of those that have the formula already applied to them. Anyone have fixes for these problems they're willing to share?

0 Upvotes
1 Accepted solution
DianaGomez
Solution
Community Manager
Community Manager

Issues Updating Spreadsheet using Workflow

SOLVE

Hi @ChrisAlexander

 

Thank you for reaching out to the Community!

 

When it comes to the dates property, we are aware of this issue, as mentioned in our knowledge base article here. By default, HubSpot sends internal property values to Google Sheets. For dates, HubSpot sends Unix timestamps in milliseconds. To convert these dates in Google Sheets, you can use the following formula in a separate column: =A1/1000/60/60/24 + DATE(1970,1,1). Be sure to replace A1 with the column containing the Unix timestamp.

As for the other properties, the internal values are being sent instead of the labels. Our workaround involves creating a Vlookup table that maps the internal values to the corresponding labels we see within HubSpot.

 

I hope this helps,

Diana


¿Sabías que la Comunidad está disponible en Español?
¡Participa hoy en conversaciones en el idioma de tu preferencia,cambiando el idioma en tus configuraciones!

Did you know that the Community is available in other languages?
Join regional conversations by changing your language settings !


View solution in original post

0 Upvotes
1 Reply 1
DianaGomez
Solution
Community Manager
Community Manager

Issues Updating Spreadsheet using Workflow

SOLVE

Hi @ChrisAlexander

 

Thank you for reaching out to the Community!

 

When it comes to the dates property, we are aware of this issue, as mentioned in our knowledge base article here. By default, HubSpot sends internal property values to Google Sheets. For dates, HubSpot sends Unix timestamps in milliseconds. To convert these dates in Google Sheets, you can use the following formula in a separate column: =A1/1000/60/60/24 + DATE(1970,1,1). Be sure to replace A1 with the column containing the Unix timestamp.

As for the other properties, the internal values are being sent instead of the labels. Our workaround involves creating a Vlookup table that maps the internal values to the corresponding labels we see within HubSpot.

 

I hope this helps,

Diana


¿Sabías que la Comunidad está disponible en Español?
¡Participa hoy en conversaciones en el idioma de tu preferencia,cambiando el idioma en tus configuraciones!

Did you know that the Community is available in other languages?
Join regional conversations by changing your language settings !


0 Upvotes