Mathematical operation tool

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

In this article

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

Join our newsletter

Hand-picked content and zero spam!

Related articles

Show more
5 Ways to Automate Claude with Albato
4 min. read

5 Ways to Automate Claude with Albato

In this article, you will learn five practical ways to connect and automate Claude AI with Albato. Learn how to boost workflows, integrate apps, and streamline business tasks.

5 Best No-Code Web Scrapers For Online Businesses
6 min. read

5 Best No-Code Web Scrapers For Online Businesses

Discover 5 top no-code web scrapers for online businesses. Automate competitor tracking, SEO monitoring, and market research without coding.

State of Integrations Report 2025: Key Trends and Strategic Insights
5 min. read

State of Integrations Report 2025: Key Trends and Strategic Insights

In this report, you will learn about the 2025 state of integrations in 2025 with data, trends, and recommendations. Learn how businesses can leverage integrations to boost efficiency and stay competitive.

Zapier vs. Make vs Albato: Full Comparison
6 min. read

Zapier vs. Make vs Albato: Full Comparison

In this article, you will learn how Zapier, Make, and Albato compare to each other to see which SaaS automation platform suits your needs. Explore capabilities, pricing, features, and use cases.

Our Automation Builder Has Just Leveled Up
3 min. read

Our Automation Builder Has Just Leveled Up

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

Best Accounting Apps to Manage Your Business Finances
7 min. read

Best Accounting Apps to Manage Your Business Finances

In this article, you will learn about the top accounting apps like Sage, QuickBooks, Zoho Books, and more to simplify bookkeeping, automate workflows, and grow your business.

How to Connect LinkDeal to Albato
3 min. read

How to Connect LinkDeal to Albato

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

How to Connect Workday to Albato
5 min. read

How to Connect Workday to Albato

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

How to Connect DeepL to Albato
5 min. read

How to Connect DeepL to Albato

Connect DeepL with Albato to integrate it with over 1000+ apps.

How to Connect Mobilo to Albato
5 min. read

How to Connect Mobilo to Albato

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

How to Connect Utalk to Albato
5 min. read

How to Connect Utalk to Albato

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

How to Connect DeepSeek to Albato
4 min. read

How to Connect DeepSeek to Albato

Connect DeepSeek with Albato to integrate it with over 1000+ apps.