Options for integrating with Airtable
  • 12 Sep 2023
  • 3 Minutes to read
  • Dark
    Light

Options for integrating with Airtable

  • Dark
    Light

Article Summary

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 Scale
  • ✅ Business
  • ✅ Team
  • ✅ Free 

Messaging: Slack, Email

Attachments: Dropbox, Box, Gmail, Google 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 Scale
  • ✅ Business
  • ✅ Team
  • ❌ 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 Scale
  • ✅ Business
  • ✅ Team
  • ✅ Free

Airtable Integration Examples

Integration Services: Zapier, Tray.io, Workato, Automate.io, Make

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 Scale
  • ✅ Business
  • ✅ Team
  • ✅ Free: CSV base/table import
  • ❌ 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 Scale
  • ✅ Business
  • ✅ Team
  • ❌ Free

Scripting extension overview

Using Javascript Fetch

Button field blog

Automation scripts
 AvailabilityResources
Airtable 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 workaround.
  • ✅ Enterprise Scale
  • ✅ Business
  • ✅ Team
  • ❌ Free

Automations Overview

Using Javascript Fetch

Incoming webhooks automation trigger
 AvailabilityResources
With the incoming webhook trigger for Airtable 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 Scale
  • ✅ Business
  • ✅ Team
  • ✅ 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 Scale
  • ✅ Business
  • ✅ Team
  • ❌ Free

Custom Blocks SDK Guide

Custom extension examples

Custom extension API

API + external systems
 AvailabilityResources
By interacting with the Airtable Web API, users can develop applications that run triggered or scheduled jobs hosted on external infrastructure (local machine, AWS lambda, etc.)
  • ✅ Enterprise Scale
  • ✅ Business
  • ✅ Team
  • ✅ 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 

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


Integration guides

The following guides include step-by-step instructions on 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: Sync integration

Resources: Sync integration: 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, Sync integration

Resources: Sync integration: Salesforce


Was this article helpful?