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 to Automate Contact Migration from Quickbase to Google Contacts Using Albato
7 min. read

How to Automate Contact Migration from Quickbase to Google Contacts Using Albato

With this setup, not only can you transfer your contact database from Quickbase to Google Contacts in bulk, but you can also keep those records updated in real time.

We’re Celebrating a Big Win!
2 min. read

We’re Celebrating a Big Win!

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

How to Automate Blog Creation from Google Sheets Using OpenAI
8 min. read

How to Automate Blog Creation from Google Sheets Using OpenAI

With this Solution, every new row in a designated Google Sheet triggers a series of actions to create SEO-friendly blog content, generate images, and notify your team—without writing a single line of code.

Best Workflow Management Software for Teams 2025
11 min. read

Best Workflow Management Software for Teams 2025

In this article, you will learn the top workflow management tools to boost team efficiency. Compare features, pricing, and find the perfect fit for your team.

Tired of Missed Follow-Ups? Here’s Why CRM SMS Integration Matters
5 min. read

Tired of Missed Follow-Ups? Here’s Why CRM SMS Integration Matters

This article breaks down why missed follow-ups happen so often, how CRM SMS integration solves the root of the problem, and what steps you can take to put your follow-up process on autopilot without losing the human touch.

What Tools To Connect to OpenAI with Albato
3 min. read

What Tools To Connect to OpenAI with Albato

In this article, you will learn what tools you can connect to ChatGPT(Open AI) with Albato to set up automated workflows for different use cases.

Artificial Intelligence Automation for Lead scoring, Sales, Marketing & Content
8 min. read

Artificial Intelligence Automation for Lead scoring, Sales, Marketing & Content

In this article, you will learn how to use AI and AI agents to automate your business processes. Discover top tools, benefits, and implementation strategies in this 2025 guide

How to Connect Fomo to Albato
4 min. read

How to Connect Fomo to Albato

Connect Fomo with Albato and sync your data with 800+ apps, including AI tools like ChatGPT and Gemini. This integration will help you to automate marketing campaigns, personalize user experiences, and boost engagement.

How to Connect Reply.io to Albato
4 min. read

How to Connect Reply.io to Albato

Connect Reply.io with Albato to integrate it with over 800+ apps, including AI tools like Grok and Claude. Follow the steps below to set it up.

How to Connect EventMobi to Albato
4 min. read

How to Connect EventMobi to Albato

Connect EventMobi with Albato and sync your data with 800+ apps. This integration will help you to automate event planning, guest management, and customer communication workflows.

Top LinkedIn Automation Tools for 2025
20 min. read

Top LinkedIn Automation Tools for 2025

Discover the best LinkedIn automation tools to boost your outreach and lead generation efforts in 2025.

How to Connect MixMax to Albato
4 min. read

How to Connect MixMax to Albato

By connecting Mixmax with Albato, you can sync data across 800+ apps, including AI tools like Grok and Claude.