Options for integrating with Airtable
- 12 Sep 2023
- 3 Minutes to read
- Print
- DarkLight
Options for integrating with Airtable
- Updated on 12 Sep 2023
- 3 Minutes to read
- Print
- DarkLight
Article Summary
Share feedback
Thanks for sharing your feedback!
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
| 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. |
| 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. |
|
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. |
| 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. |
|
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. |
|
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. |
|
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). |
|
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. |
|
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 tools
Metadata API
| Availability | Resources | |
| 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 |
Enterprise API
| Availability | Resources | |
| 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 |
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 LambdaUse 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 serverUse 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 / PowerQueryUse 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 | SalesforceUse 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?