Workflow Data Format Actions

Data Formatter transforms your HubSpot data to improve quality and consistency. It converts Unix timestamps into readable dates, optimizes phone numbers for calls and SMS, and standardized text cases, ensuring your data is in clean, readable and specific formats for seamless export and integration.

With the Data Formatter from Integration Glue, you can transform your HubSpot data to improve quality and consistency.

It converts Unix timestamps into readable dates, optimizes phone numbers to improve calling and SMS from HubSpot, and standardized text cases, ensuring your data is in clean, readable and specific formats for seamless export and integration.

Includes:

• Any Object (Contacts, Companies, Deals, Tickets, Custom Objects)
• Format dates and date time
• Format numbers
• Format phone numbers to include international calling codes
• Format text

Fully managed within HubSpot Workflows - once installed you do not need to login to any other system to manage your association actions.

When you register for Integration Glue, you will get access to a whole bunch of HubSpot Workflow and Data productivity actions, such as Actions to Clone records (including associated records), get User/Owner information and add to a Property or calculate a date.

Integration Glue pricing is based on utilization, so you can use all of our apps together under a single license and you will only be charged for the total credits you use per month.

Integration Glue does not retain any data when using this app; it simply reads and outputs data to your own HubSpot portal.

Features

Format number

• Set number formatting preferences for specific data fields, choosing either text output or a number-specific field.
• Include thousands separators to improve clarity in exports, reporting, personalization, and integration with external platforms.

Format text

• Automatically formats text in selected properties to your chosen case: UPPER, lower, Title Case, or Sentence case.
• Enhances data consistency and quality.

Format date

• Transform Unix timestamp dates into readable formats in other platforms and in data extracts.
• Choose a date property, specify a format (e.g., dd-Mmm-yy), and select an output property.

Format date-time

• Transform Unix timestamp date-times into readable formats in other platforms and in data extracts.
• Choose a date property, specify a format (e.g., hh:mm a.m./p.m., dd-Mmm-yy), and select an output property.

Format phone number

• Automatically format phone numbers, incorporating source, country code, and fallback options.
• It ensures phone numbers are compatible for SMS and call services, preventing mismatch errors and manual corrections.

Usage & pricing

When you register for Integration Glue, you will get access to a whole bunch of HubSpot data and productivity apps, such as Actions to Clone records (including associated records), get User/Owner information and add to a Property or calculate a date.

Integration Glue pricing is based on utilization, so you can use all of our apps together under a single license and you will only be charged for the total credits you use per month.

Free

Includes 100 credits; Actions use 1 credit each time they run = 100 runs of Custom Actions per month.

Starter

Includes 10,000 credits; Actions use 1 credit each time they run = 10,000 runs of Custom Actions per month.

Professional

Includes 100,000 credits; Actions use 1 credit each time they run = 100,000 runs of Custom Actions per month.

Enterprise

Includes 1,000,000 credits; Actions use 1 credit each time they run = 1,000,000 runs of Custom Actions per month.

Integration Glue does not retain any data or files when using this app; it simply reads and outputs data to your own HubSpot portal.
Have other or more specific requirements? Integration Glue offers custom integration services on all our apps and from-scratch build services. 

Can't find what you're looking for? Let us know we are releasing new apps and enhancements monthly.