Integrating with Airtable
  • 14 Sep 2022
  • 3 Minutes to read
  • Dark
    Light

Integrating with Airtable

  • Dark
    Light

This guide outlines Airtable features that allow you to connect and exchange data with external services or programmatically manipulate data within Airtable.

No-code integration options

No-code integrations are services pre-built by Airtable that allow for quick configuration and some customizability with no coding experience required.

Native integrations
 AvailabilityResources
Native integrations are built by Airtable to give you integration functionality right from the core Airtable product. Messaging integrations allow you to send data from within Airtable. Attachment integrations allow you to attach files directly from several services.
  • ✅ Enterprise
  • ✅ Pro
  • ✅ Plus
  • ✅ Free 

Messaging: Slack, Email

Attachments: DropboxBox
GmailGoogle Drive

Other: Typeform

Partner extensions
 AvailabilityResources
Partner extensions are built in conjunction with an Airtable partner. They are maintained and supported by our team, and currently include extensions from Formstack, Loom, Miro, Pexels, and Typeform.
  • ✅ Enterprise
  • ✅ Pro
  • ❌ Plus
  • ❌ Free

Airtable extensions

Partner extensions Release Blog

Third-party integration services
 AvailabilityResources
Third-party integration services have built-in connectors between Airtable and thousands of services. All of these services require an account and configuration on their platform, but have the advantage of being easy to set up.
  • ✅ Enterprise
  • ✅ Pro
  • ✅ Plus
  • ✅ Free

Airtable Integration Examples

Integration Services: ZapierTray.ioWorkato
Automate.ioIntegromat

CSV import / export
 AvailabilityResources
Though not an automatic integration, CSV import/export can be the ideal way to transfer data when the transfer schedule is relaxed (i.e. weekly, monthly). New bases or tables can be created using a CSV import. The CSV import extension will allow users to import additional data into an existing table.
  • ✅ Enterprise
  • ✅ Pro
  • ✅ Free: create base
  • ❌ Free: CSV import extension

 

Creating a new base via CSV/spreadsheet import

CSV Import extension

Low-code integration options

Low-code integrations are services or platforms that allow users to build out highly customizable integrations with some development resources recommended.

Scripting extension
 AvailabilityResources
The scripting extension allows users to write and run JavaScript code that interacts with your Base. Built-in JavaScript libraries (like fetch) allow users to make external API calls to certain services. Can be triggered by a button field or from the extensions panel. Note: this code runs client-side and may require a CORS work-around.
  • ✅ Enterprise
  • ✅ Pro
  • ❌ Plus
  • ❌ Free

Scripting extension overview

Using Javascript Fetch

Button field blog

Automation scripts
 AvailabilityResources
Our automations allow for automatic actions based on certain Airtable event triggers. One of the actions available is the ability to automatically run a javascript code snippet, similar to the Scripting extension. Built-in JavaScript libraries (like fetch) allow users to make external API calls to certain services.  Note: this code runs server-side and would not require a CORS work-around.
  • ✅ Enterprise
  • ✅ Pro
  • ❌ Pro trial
  • ❌ Plus
  • ❌ Creator
  • ❌ Student
  • ❌ Free

Automations Overview

Using Javascript Fetch

Incoming webhooks automation trigger
 AvailabilityResources
With the incoming webhook trigger for automations, you can connect Airtable with many of the tools and products that you and your team use (whether a third-party service or an internal tool).
  • ✅ Enterprise
  • ✅ Pro
  • ✅ Pro trial
  • ✅ Plus
  • ✅ Creator
  • ✅ Student
  • ✅ Free

Incoming webhooks automation trigger

Custom extension
 AvailabilityResources
Our Blocks SDK allows users to build a custom extension with React.js. It gives teams the advantage of creating a custom interface that allows users to interact with the integration. Note:  this code runs client-side and may require a CORS work-around.
  • ✅ Enterprise
  • ✅ Pro
  • ❌ Plus
  • ❌ Free

Custom Blocks SDK Guide

Custom extension Examples

Custom extension API

API + external systems
 AvailabilityResources
By interacting with our REST API, users can develop applications that run triggered or scheduled jobs hosted on external infrastructure (local machine, AWS lambda, etc.)
  • ✅ Enterprise
  • ✅ Pro
  • ✅ Plus
  • ✅ Free

 

Airtable API documentation

Enterprise tools

Metadata API
 AvailabilityResources
Using the Metadata API, you can interact with some of the structural elements of Airtable. This includes retrieving data about your base schema or programmatically creating bases and tables.

Available for Enterprise Only

Metadata API documentation (must have an enterprise account to view)

Enterprise API
 AvailabilityResources
The Enterprise API gives administrators the ability to interact with the settings for enterprise accounts. This includes getting information about or making changes to users, workspaces, bases, and more. One common use of the Enterprise API is the management of user or base permissions.

Available for Enterprise Only

Enterprise API documentation (must have an enterprise account to view)

Integration guides

The following guides include step-by-step instructions of how to integrate external services with Airtable. These guides are meant to show an example integration and do not capture the full functionality that can be built*. For further information, please refer to each service’s official documentation.

NOTE

This list is not a comprehensive list of Airtable integrations. For more information, see Airtable Integrations

AWS Lambda

Use case Move data from Airtable to DynamoDB using code hosted on AWS Lambda.

Airtable tools used API
Scripting extension

Resources Airtable Integration Guide

AWS Lambda Documentation

Amazon DynamoDB Documentation

Jira server

Use case Bi-directional data sync between Airtable and Jira Server.

Airtable tools used ETS: External source sync

Resources External source sync: JIRA Server

Guide for connecting a Jira Server to Airtable

MS PowerBI / PowerQuery

Use case Pull data from Airtable into PowerBI using a PowerQuery script.

Airtable tools used API

Resources Airtable Integration Guide

PowerBI Documentation

Scheduling Jobs with PowerBI

Salesforce

Use case One-way data transfer from Salesforce to Airtable using a locally hosted script.

Airtable tools used API

Resources External source sync: Salesforce


Was this article helpful?