Options for integrating with Airtable
  • 24 Apr 2024
  • 3 Minutes to read
  • Dark
    Light
  • PDF

Options for integrating with Airtable

  • Dark
    Light
  • PDF

Article Summary

This guide outlines Airtable features that allow you to connect and exchange data with external services or programmatically manipulate data within Airtable. For more information about exporting data from Airtable, learn how to export data in a view as a CSV in this article.

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

Availability

Resources

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

Availability

Resources

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

Availability

Resources

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

Availability

Resources

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

 

Availability

Resources

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

 

Availability

Resources

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

 

Availability

Resources

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

 

Availability

Resources

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

 

Availability

Resources

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

Web API

 

Availability

Resources

The Airtable API can be used to integrate your data in Airtable with any external system. The API closely follows REST semantics, uses JSON to encode objects, and relies on standard HTTP codes to signal operation outcomes.

Available on all Airtable plans

Web API documentation 

Enterprise Scale API

 

Availability

Resources

Certain Web API endpoints are only available to our Enterprise Scale customers. You will see an "Enterprise" tag next to these sections of the API documentation.

Available for Enterprise Only

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?