Airtable
Airtable is a low-code platform to build next-gen apps. Move beyond rigid tools, operationalize your critical data, and reimagine workflows with AI.
Go to siteAirtable API Integrations
Build and run workflows using the Airtable API. Use 1000s of source-available triggers and actions across 2,400+ apps. Or write custom code to integrate any app or API in seconds.
Trusted by 1,000,000+ developers from startups to Fortune 500 companies
Overview#
Airtable (OAuth) API on Pipedream allows you to manipulate and leverage your Airtable data in a myriad of powerful ways. Sync data between Airtable and other apps, trigger workflows on updates, or process bulk data operations asynchronously. By using Airtable's structured databases with Pipedream's serverless platform, you can craft custom automation solutions, integrate with other services seamlessly, and streamline complex data processes.
import { axios } from "@pipedream/platform"
export default defineComponent({
props: {
airtable_oauth: {
type: "app",
app: "airtable_oauth",
}
},
async run({steps, $}) {
return await axios($, {
url: `https://api.airtable.com/v0/meta/whoami`,
headers: {
Authorization: `Bearer ${this.airtable_oauth.$auth.oauth_access_token}`,
},
})
},
})
Choose an API to Connect with Airtable API#
1-24of2,400+apps by most popular
Example Use Cases#
Sync Airtable Records with Google Sheets: Automatically sync new or updated Airtable records to a Google Sheets spreadsheet, enabling real-time data sharing with teams reliant on Google Workspace. This is ideal for maintaining consistent datasets across platforms without manual updates.
Aggregate and Email Weekly Reports: Collect data from an Airtable base at the end of each week, create a summary report, and send it via email with SendGrid or Gmail. Perfect for providing stakeholders with regular insights without manual report generation.
Trigger SMS Notifications on Record Status Change: Monitor an Airtable base for specific status changes and use Twilio to send an SMS notification whenever a record meets the criteria. This workflow ensures immediate alerts for time-sensitive operations.
Popular Airtable Integrations#
Popular Airtable Triggers#
Emit new event each time a record is added, updated, or deleted in an Airtable table. See the documentation
Emit new event for each new or modified record in a table
Emit new event for each new or modified record in a view
Popular Airtable Actions#
Create one or more records in a table by passing an array of objects containing field names and values as key/value pairs. See the documentation
Updates a record if recordId is provided or adds a record to a table.
Authentication#
Name Slug: airtable_oauthAirtable uses OAuth authentication. When you connect your Airtable account, Pipedream will open a popup window where you can sign into Airtable and grant Pipedream permission to connect to your account. Pipedream securely stores and automatically refreshes the OAuth tokens so you can easily authenticate any Airtable API.
Pipedream requests the following authorization scopes when you connect your account:
data.records:readdata.records:writedata.recordComments:readdata.recordComments:writeschema.bases:readschema.bases:writewebhook:manageuser.email:read- authorization
GEThttps://airtable.com/oauth2/v1/authorize?client_id={{oauth.client_id}}&redirect_uri={{oauth.redirect_uri}}&state={{oauth.state}}&response_type=code&scope={{oauth.space_separated_scopes}} - accessToken
POSThttps://airtable.com/oauth2/v1/tokencontent-type:application/x-www-form-urlencodedaccept:application/jsonredirect_uri={{oauth.redirect_uri}}&grant_type=authorization_code&code={{oauth.code}} - refreshToken
POSThttps://airtable.com/oauth2/v1/tokencontent-type:application/x-www-form-urlencodedaccept:application/jsongrant_type=refresh_token&refresh_token={{oauth.refresh_token}}
Trusted by 1,000,000+ developers from startups to Fortune 500 companies