Using Functions

Functions are intended for advanced users.

When mapping items, you can use functions to create complex formulas. The functions available in Integromat are similar to functions in Excel or those in other programming languages. The functions let you perform various transformations of item values, such as converting a text to uppercase, trimming a text, converting a date into a different format, and many others.

Inserting functions into fields

Functions can be inserted into fields the same way as items. If you click into a field, the mapping panel will pop up. The mapping panel contains several tabs:

To insert a function into a field, click the function name or drag it to the field.

Example: shortening a tweet

When posting a new tweet with the Twitter > Create a tweet module, you should not exceed Twitter's 140-character limit otherwise the module will throw en error. If you map a text item that can contain more than 140 characters into the module's Status field, you can use the substring() function to limit the tweet to 140 characters:

Exploiting Google Sheets functions

If you miss a function, but it is featured by Google Sheets, you may exploit it like this:

  1. In Google Sheets, create a new empty spreadsheet.
  2. In Integromat, open your scenario.
  3. Insert the Google Sheets > Update a cell module.
  4. Configure the module:
    • Choose the newly created spreadsheet in the Spreadsheet field.
    • Insert your formula containing the Google Sheets function(s) into the Value field. Note that you can use the output of preceding modules as usual.
  5. Insert the Google Sheets > Get a cell module to obtain the calculated result.
  6. Configure the module. Fill the same Cell ID as you filled in step 4.

 

 

Popular use cases from our blog

slack-automation-illustration

Slack Automation: 20 Free Templates to Get You Inspired

google-sheets-automation-alt

Google Sheets Automation for Ecommerce: 23 Free Templates

tweet-automation-illustration

How to Get Someone's Tweets Before Anyone Else Does

onboarding-automation-with-integromat-alt

How to Automate Employee Onboarding in Minutes with Integromat

shopify-order-to-manufacturer-illustration-alt

How to Auto Send Shopify Orders to Dropshipping Suppliers [Guide]

strava-exercise-to-google-sheets-illustration

Like a Champ: How to Save Strava Activities to Google Sheets

Didn’t find what you were looking for?

Ticket

Create a ticket

Contact our world-class support team and tell us what’s happening.

Create a ticket
Expert

Find an expert

We feature a network of 450+ certified partners across the globe who are ready to help

Find an expert

Automate any workflow in your business

Sign up for a free account today. No credit card required, no time limits on free plan.