Mathematical operation tool

Mathematical operation tool
Tools
·
3/16/2022
·
3 min. read

If you need to calculate some data from any app, use Albato Mathematical Operation tool.

It will be useful when:

  1. You need to convert currency. For example, when the cost comes in dollars, but you want to send it to CRM in euros.
  2. You receive two or more fields with a numerical value, then you need to add, subtract, multiply or divide them and transfer into one field. For example, add the weight of the product and the weight of the box to transfer the gross weight.
  3. Add VAT to the amount or perform any other calculations.

Let's take a look at how to use the tool. For example, whenever one of your current customers makes a purchase, two fields are updated in the respective Deal in HubSpot: order value and discount value. However, you only want to send to Google Sheets the total amount including the discount for your sales records.

How to set up

In Automation Builder, add HubSpot in the first step of the workflow. Select the Deal updated trigger and connect your app account.

Captura de tela 2025-02-12 200522.png

Add Google Sheets in the second step. Select the Create/update a row action and connect your app account. Specify the spreadsheet and the tab where your sales records are stored.

Captura de tela 2025-02-12 200603.png

Map the fields to fill in the spreadsheet according to HubSpot data. Leave the Total amount field blank.

Captura de tela 2025-02-12 204957.png

Click on the + icon between the steps and select the Tool option. Then, find the Mathematical Operation tool and click the Select button.

Captura de tela 2025-02-12 200811.png

In the Operation field, describe the required mathematical operation. You can also select the rounding type for fractional results and the number of decimal places.

In our example, we enter the following values from HubSpot:

Order value - Discount value

Captura de tela 2025-02-12 203421.png

Click the gear icon in the Google Sheets step to do the final setup. Then, select the Total value field and define the Result parameter in the drop-down list linked to the Mathematical operation tool.

Captura de tela 2025-02-12 205151.png

Ready! Now you will receive the result of mathematical operation. If Order value is 5000 and Discount value is 100, then the math operation result 4900 will be sent to Google Sheets.

This is just one of the examples how to use this new tool. You can apply it in other automations according to your personal needs.


Tools

Related articles

Show more
Product-Led Growth: 4 Strategies and Implementation Guide
Embedded
13 min. read

Product-Led Growth: 4 Strategies and Implementation Guide

In this article, you will learn what product-led growth (PLG) is and how it drives user acquisition, retention, and scalability on real-life examples.

Product updates we're excited about
3 min. read

Product updates we're excited about

Explore what’s new in Albato: features, apps, and improvements!

DeepSeek Overview: Features, Benefits, Use Cases, and Alternatives
7 min. read

DeepSeek Overview: Features, Benefits, Use Cases, and Alternatives

DeepSeek overview covering key features, benefits, and use cases. Compare top alternatives to find the best AI-powered solution for automation and efficiency.

What Is an iPaaS? All About Integration Platform as a Service
Embedded
5 min. read

What Is an iPaaS? All About Integration Platform as a Service

An iPaaS is an integration platform as a service that helps businesses connect applications, data, and systems seamlessly for streamlined workflows.

Connect Digital Samba with Albato | Elevate Your Webinar Experiences
3 min. read

Connect Digital Samba with Albato | Elevate Your Webinar Experiences

Digital Samba is a powerful platform for hosting and managing webinars, designed with user-friendly features and scalability in mind. See how Albato can help you enhance the app’s usability!

Connect Intento with Your Favorite Apps | Optimize Your Translations with Albato
3 min. read

Connect Intento with Your Favorite Apps | Optimize Your Translations with Albato

Intento is an AI-powered platform for managing multilingual content and optimizing translation workflows. See how Albato can help you enhance the app’s usability!

How to connect ClickUp to Albato for seamless Integrations | ClickUp Integrations Guide
4 min. read

How to connect ClickUp to Albato for seamless Integrations | ClickUp Integrations Guide

Learn how to set up ClickUp integrations with Albato in our step-by-step guide. Unlock powerful ClickUp integrations & automate workflows to boost productivity.

Integrate Ortto with 800+ Apps | Enhance Your Marketing Automation with Albato
3 min. read

Integrate Ortto with 800+ Apps | Enhance Your Marketing Automation with Albato

Ortto redefines the landscape of marketing automation with its intuitive service that simplifies email marketing, customer journey mapping, and targeted messaging. See how Albato can help you enhance the app’s usability!

Connect Zendesk with Popular Apps | Streamline Your Support Workflow with Albato
4 min. read

Connect Zendesk with Popular Apps | Streamline Your Support Workflow with Albato

Zendesk offers a comprehensive customer service solution, designed for ease of use and scalability. See how Albato can help you enhance the app’s usability!

How to use Claude Artifacts: 7 Ways with examples | Guide 2025
Claude AI
10 min. read

How to use Claude Artifacts: 7 Ways with examples | Guide 2025

Learn how to use Claude Artifacts with our detailed guide. Explore 7 best ways with real Artifact examples: web pages, prototypes, presentations and visualizations.

Connect Gumlet with Your Favorite Apps | Optimize Your Media Management with Albato
3 min. read

Connect Gumlet with Your Favorite Apps | Optimize Your Media Management with Albato

Gumlet is best way to stream ad-free videos on internet. It has powerful CMS to organise videos and hollywood grade DRM. See how Albato can help you enhance the app’s usability!

Connect Octopush with Albato | Elevate Your SMS Marketing Strategy
3 min. read

Connect Octopush with Albato | Elevate Your SMS Marketing Strategy

With Octopush, businesses are well equipped to propel their brand, promote their offers and services at scale. See how Albato can help you enhance the app’s usability!