What do you want to automate with Airtable?
Prompt, edit and deploy AI agents that connect to Airtable and 2,500+ other apps in seconds.
1-24of2,700+apps by most popular
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}`,
},
})
},
})
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 when a field is created in the selected table. See the documentation
Emit new event when a field is created or updated in the selected table
Emit new event for each new or modified record in a table or view
Emit new event for each new or modified record in a view
Emit new event when a record is added, updated, or deleted in a table or selected view.
Popular Airtable Actions#
Create one or more records in a table in a single operation with an array. See the documentation
Create a new record or update an existing one. See the documentation
Troubleshooting#
Unable to find a new base
After creating a new base, reconnect your account and select it to enable Pipedream access.
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