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
How AI Is Changing SaaS Product Design
7 min. read

How AI Is Changing SaaS Product Design

In this article, you’ll learn how to design SaaS products in the age of AI. We’ll discuss the UX patterns and practical tips to help you create better products.

Best Sales Automation Apps for Faster Growth
10 min. read

Best Sales Automation Apps for Faster Growth

In this article, you will learn about the best sales automation apps to save time, close more deals, and boost team productivity. Compare features, pricing, and integrations.

Smarter Automations with Workflow Management Software
2 min. read

Smarter Automations with Workflow Management Software

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

QuickBooks CRM Integration | Boost Sales & Automate Accounting
5 min. read

QuickBooks CRM Integration | Boost Sales & Automate Accounting

In this article, you will learn how QuickBooks CRM integration can streamline your sales, invoicing, and customer data. Save time and grow your business with a seamless CRM-QuickBooks connection.

Best Productivity Apps 2025 – Streamline Your Daily Tasks
13 min. read

Best Productivity Apps 2025 – Streamline Your Daily Tasks

In this article, you will learn about the top productivity apps—task managers, timers, note tools, and more—to streamline your daily workflow and boost efficiency in 2025.

How Email Marketing Automation Helps Boost Engagement
20 min. read

How Email Marketing Automation Helps Boost Engagement

In this article, you will learn how email marketing automation can increase engagement, save time, and deliver personalized content to your audience more effectively.

How Weeztix Scaled Native Integrations for 300+ Event Organizers with Albato Embedded
6 min. read

How Weeztix Scaled Native Integrations for 300+ Event Organizers with Albato Embedded

By embedding Albato, Weeztix made it way easier to integrate and automate workflows for hundreds of their event organizers.

How to Conneсt Google Meet to Albato
3 min. read

How to Conneсt Google Meet to Albato

Connect Google Meet with Albato to integrate it with over 800+ apps, including AI tools like ChatGPT and Claude.

How to Connect Microsoft Office 365 to Albato
3 min. read

How to Connect Microsoft Office 365 to Albato

Follow the steps to set Microsoft Office 365 up.

How to Connect Chategy to Albato
4 min. read

How to Connect Chategy to Albato

Connect Chategy with Albato to integrate it with over 800+ apps, including AI tools like Claude and Grok.

How to Connect Workiom to Albato
4 min. read

How to Connect Workiom to Albato

Connect Workiom with Albato to integrate it with over 800+ apps, including AI tools like Grok and Claude.

Best Albato Use Cases for Marketing and Sales Automation
8 min. read

Best Albato Use Cases for Marketing and Sales Automation

In this article, you will learn about the best Albato use cases for marketing and sales automation. Learn how to streamline workflows, boost productivity, and drive growth.