I have created a workflow that exports specific opportunities to a Google Sheets workbook. Upon populating the 'Deal Stage', I am left with a number (8 digit - 57051273) instead of a valid property such as Discovery or Closed. There are consistencies between the numbers and the names, so I can create a rule in sheets to make the conversion, but I'd prefer to fix the issue at its core.
The Google Sheets workflow action uses internal labels to export data rather than their display name. There's no fantastic way to solve for this, but my suggestion would be to create an if/then branch in your workflow in the step prior to sending to the Google Sheet, and you can then hard-set the value for Deal Stage rather than pulling it in from the deal's property.
Hey, you can do this with Superjoin (https://www.superjoin.ai/integrations/hubspot). It’s made specifically for reporting on Gsheets. In your case, it will make your deal stages update problem easy. Rather than creating workflows that take up a lot of your time and prone to error, you can give Superjoin a try. Superjoin let's you connect your Hubspot to Google Sheets and let's you import data from Hubspot, with auto-refresh capabilities. 1. We’ve done all possible associations between objects 2. Preview data before importing to Sheets 3. Create calculated fields for ease of use 4. Workflows to tie Appscript with Imports
The Google Sheets workflow action uses internal labels to export data rather than their display name. There's no fantastic way to solve for this, but my suggestion would be to create an if/then branch in your workflow in the step prior to sending to the Google Sheet, and you can then hard-set the value for Deal Stage rather than pulling it in from the deal's property.
