How to use Airtable in Albato

How to use Airtable in Albato
CRM
·
12/9/2021
·
3 min. read

Albato can create automations with a popular cloud collaboration service Airtable. This tutorial will tell you about the service features. It may help to use Airtable in the automations scenarios more often.

The following actions are available with Airtable in Albato:

From

  • Record created
  • Record updated

Where

  • Find a record
  • New Record

The first step is to connect Airtable to Albato. After creating Airtable connection, you can make automations with this service.

Create an automation

The sending app

When we send data from Airtable, two actions are available:

  • Record created — in creating a new record, Albato will send data from Airtable to another app.
  • Record updated – in updating the existing spreadsheet, the data will be sent to Albato and further.

Specify databases and documents for the automation in the fields «Base» and «Table». 

If the action is «Record created», the next step will be to set up data migration. 

Select the operation mode

Albato can send data to Airtable in a real time or for a certain period (data migration).

2022-08-16_13-24-25.png

When the «Record updated» is selected, set up additional options. To download each deal only once, put a check in the field:

Where send the data

When we send data to Airtable, two actions are available:

  • Find record — this action is more complicated than it sounds. First, the system searches for the required ID, and then updates it. In fact, this action combines two actions at once.
  • New record — Airtable creates a cell to save data from a send service.

Specify a database and a table for data receiving. 

One of the most important steps in an automation setting is to fill in the fields for data sending. The fields are filled in by clicking and selecting values from the drop-down list. 

There are required and optional fields. The required fields are marked with orange signs, fill in such fields to proceed to the next steps. Furthermore, we advise you to fill in the fields in details for the correct service operation and comfortable usage.

Each new step in an automation setting opens fields from the previously created steps. Most values ​​correspond to the field’s name, just select the data you need to send or receive.   

The usual sequence for filling in the «New Record» / «Find Record» action fields of the Airtable remains the same, regardless of data source service. 

Example to fill in the fields: 

Set up duplicates

To work with duplicates correctly and avoid confusion in the system, Albato provides several options for setting this step:

Selecting values related to updating current records, the system will open a window to specify the action when duplicate is found. 

Put a check in the value you need:

Then delete «Current Value» and fill in the one you need:

The automation is ready!

Additional Settings: Filters

If you want to receive only certain type data, for example, transactions of a certain status, use Albato filters.

pub-img-7863-9.png

You can also add an extra conditions:

The filter consists of three fields.

  • Initial value. Here we select any value from the service for changing if the specified condition is met. For example, rows from Google Sheets or orders of certain prices.
    
  • Condition. The condition indicates the initial values to take. For example, values ​​(products)  equal to the «Paid» status will be used with «equal» condition . 
    
  • **Definition. The definition can be different, depending on the service.** 
    

Save the filter after settings. Filters can also be combined to create more complex data integrations.

Additional actions and tools setting

You can create automations of two and more apps. Albato provides great opportunities for automations, you can always add a new app or tool to the scenario by clicking on the «+» icon in the step:

The tools can help to set up more flexible automations. It can combine fields, format data, etc. Detailed tools tutorial is here.

Now you know how to use Airtable in your automations.


CRM
Airtable

Related articles

Show more
What Are the Best iPaaS Tools for Seamless Connectivity
3 min. read

What Are the Best iPaaS Tools for Seamless Connectivity

In this article, you'll find the breakdown of the best iPaaS tools for seamless connectivity that will help you make an informed choice about what's best for your business.

How to Connect FormCan to Albato
3 min. read

How to Connect FormCan to Albato

By connecting FormCam to Albato, you can streamline data flows from form submissions to your favorite business apps.

Chatfuel Cuts Churn by 25% and Integration Time by 80% with Albato Embedded
Press Releases
3 min. read

Chatfuel Cuts Churn by 25% and Integration Time by 80% with Albato Embedded

Chatfuel, a leading US-based B2B messaging platform with AI agents, has partnered with Albato Embedded to deliver seamless native integrations, significantly improving user experience and operational efficiency.

Model Context Protocol: Understanding the Future of Automations
7 min. read

Model Context Protocol: Understanding the Future of Automations

In this article, you will learn how Model Context Protocol helps connect AI tools, data sources, and workflows across SaaS apps—no code required.

How to Connect to Care. With Albato
3 min. read

How to Connect to Care. With Albato

By utilizing both Care. and Albato, you can automate routine tasks like job post updates, applicant tracking, and communication management—saving time and reducing manual effort.

How to Connect Keen to Albato
3 min. read

How to Connect Keen to Albato

Here’s a simple guide to help you connect Keen with Albato and automate your lead management workflows.

VoiceDrop and Albato Join Forces to Enhance Ringless Voicemail Integrations
Press Releases
3 min. read

VoiceDrop and Albato Join Forces to Enhance Ringless Voicemail Integrations

VoiceDrop, the #1 fastest-growing AI-powered ringless voicemail platform, has partnered with Albato Embedded to offer native, customer-facing integrations directly within their platform.

How to Connect Drip to Albato
3 min. read

How to Connect Drip to Albato

Create integrations with Drip in Albato to automate email marketing, personalize customer journeys, and keep your contact data in sync.

How to Connect OneDrive to Albato
3 min. read

How to Connect OneDrive to Albato

By connecting OneDrive to Albato, you can automate file organization, synchronize data across applications, and optimize your workflows.

How to Connnect to Forms.app via Webhook
3 min. read

How to Connnect to Forms.app via Webhook

Create integrations with Forms.app in Albato to automate form submissions, streamline response management, and connect your form data with the tools you already use.

Enterprise AI Strategy: Practical Ways to Integrate AI into Your Workflows
10 min. read

Enterprise AI Strategy: Practical Ways to Integrate AI into Your Workflows

Discover best practices for building a successful enterprise AI strategy and see how Albato can help you in this process.

Want to Learn Automation Tricks?
2 min. read

Want to Learn Automation Tricks?

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