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

    Options for integrating with Airtable

    • Dark
    • 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?