CONNECT APP
Build with Airtable
Productivity
- OAuth
MCP
Give your agent Airtable tools
Every Airtable action is exposed as an MCP tool on Pipedream's remote server. Point a client at it with your end user's ID and Connect resolves that user's Airtable account for each tool call — you store no tokens.
// accessToken: mint a short-lived token with the Connect SDK — see the MCP guide
const transport = new StreamableHTTPClientTransport(
new URL("https://remote.mcp.pipedream.net/v3"),
{
requestInit: {
headers: {
Authorization: `Bearer ${accessToken}`,
"x-pd-project-id": "{project_id}",
"x-pd-environment": "production",
"x-pd-external-user-id": "{external_user_id}", // any stable ID for this user in your system
"x-pd-app-slug": "airtable_oauth",
},
},
},
)
const mcp = new Client({ name: "my-agent", version: "1.0.0" })
await mcp.connect(transport)
const { tools } = await mcp.listTools()
// e.g. run Create Comment:
const result = await mcp.callTool({
name: "airtable_oauth-create-comment",
arguments: {
baseId: "Base",
tableId: "Table",
},
})# access_token: mint a short-lived token with the Connect SDK — see the MCP guide
headers = {
"Authorization": f"Bearer {access_token}",
"x-pd-project-id": "{project_id}",
"x-pd-environment": "production",
"x-pd-external-user-id": "{external_user_id}", # any stable ID for this user in your system
"x-pd-app-slug": "airtable_oauth",
}
async with streamablehttp_client("https://remote.mcp.pipedream.net/v3", headers=headers) as (read, write, _):
async with ClientSession(read, write) as session:
await session.initialize()
tools = await session.list_tools()
# e.g. run Create Comment:
result = await session.call_tool("airtable_oauth-create-comment", {
"baseId": "Base",
"tableId": "Table",
})API PROXY
Call the Airtable API directly
For an endpoint with no pre-built tool, the Connect proxy forwards your request to the Airtable API with the connected user's credentials attached. You store no tokens and write no refresh logic.
const resp = await pd.proxy.get({
externalUserId: "{external_user_id}", // any stable ID for this user in your system
accountId: "apn_xxxxxxx",
url: "https://api.airtable.com/v0/meta/whoami",
})
// Any allowed Airtable endpoint works here. Pipedream attaches the
// connected account's credentials to the outgoing request.# The path segment is the target URL, URL-safe base64 encoded:
# https://api.airtable.com/v0/meta/whoami
curl "https://api.pipedream.com/v1/connect/{project_id}/proxy/aHR0cHM6Ly9hcGkuYWlydGFibGUuY29tL3YwL21ldGEvd2hvYW1p?external_user_id={external_user_id}&account_id=apn_xxxxxxx" \
-H "Authorization: Bearer {access_token}" \
-H "x-pd-environment: production"SDK
Run Airtable actions from your backend
Connect a user's Airtable account once, then run Create Comment on their behalf from your own code — TypeScript, Python, or plain HTTP.
import { PipedreamClient } from "@pipedream/sdk"
const pd = new PipedreamClient({
projectId: process.env.PIPEDREAM_PROJECT_ID!,
clientId: process.env.PIPEDREAM_CLIENT_ID!,
clientSecret: process.env.PIPEDREAM_CLIENT_SECRET!,
projectEnvironment: "production",
})
const result = await pd.actions.run({
id: "airtable_oauth-create-comment",
externalUserId: "{external_user_id}", // any stable ID for this user in your system
configuredProps: {
airtable_oauth: { authProvisionId: "apn_xxxxxxx" },
baseId: "Base",
tableId: "Table",
},
})from pipedream import Pipedream
pd = Pipedream(
client_id="{oauth_client_id}",
client_secret="{oauth_client_secret}",
project_id="{project_id}",
project_environment="production",
)
result = pd.actions.run(
id="airtable_oauth-create-comment",
external_user_id="{external_user_id}", # any stable ID for this user in your system
configured_props={
"airtable_oauth": {"authProvisionId": "apn_xxxxxxx"},
"baseId": "Base",
"tableId": "Table",
},
)curl -X POST https://api.pipedream.com/v1/connect/{project_id}/actions/run \
-H "Content-Type: application/json" \
-H "X-PD-Environment: production" \
-H "Authorization: Bearer {access_token}" \
-d '{
"external_user_id": "{external_user_id}",
"id": "airtable_oauth-create-comment",
"configured_props": {
"airtable_oauth": { "authProvisionId": "apn_xxxxxxx" },
"baseId": "Base",
"tableId": "Table"
}
}'TOOLS
Airtable actions
On-demand operations your product or agent can configure and run on behalf of a connected user.
-
Create Comment
actionCreate a comment on a selected record. See the documentationWritev0.0.15 -
Create Field
actionCreate a new field in a table. See the documentationWritev0.1.7 -
Create Multiple Records
actionCreate one or more records in a table in a single operation with an array. See the documentationWritev0.0.15 -
Create or Update Record
actionCreate a new record, or update an existing one if a Record ID is provided (an upsert). LeaveRecord IDblank to create a record fromrecord; supply it to update that record's fields instead. Use List Tables to look up field names first, and List Records to find an existing record's ID. See the create-record documentation and the update-record documentationWritev1.0.0 -
Create Single Record
actionCreate a new record in a table. Provide field values inrecord, e.g.{ "Name": "Acme", "Stage": "Won" }. Use List Tables first to look up the table's field names and types. See the documentationWritev1.0.0 -
Create Table
actionCreate a new table. See the documentationWritev0.0.15 -
Delete Record
actionDelete a selected record from a table. See the documentationWritev0.0.15 -
Get Record
actionGet data of a selected record from a table. See the documentationRead-onlyv0.0.16 -
Get Record Or Create
actionFetch a record by its Record ID. If the ID is blank, or doesn't match an existing record, create a new record instead usingrecord. Use List Tables to look up field names first, and List Records to find an existing record's ID. See the get-record documentation and the create-record documentationWritev1.0.0 -
List Bases
actionGet the list of bases that can be accessed. See the documentationRead-onlyv0.0.5 -
List Comments
actionGet a list of comments on a selected record, e.g. to look up a comment's ID before updating it. See the documentationRead-onlyv0.0.1 -
List Records
actionRetrieve records from a table, optionally sorting and filtering results. Use List Tables to look up a table's field IDs. See the documentationRead-onlyv0.0.15 -
List Records in View
actionRetrieve records from a view, optionally sorting and filtering results. Use List Tables to look up a table's view IDs. See the documentationRead-onlyv0.0.15 -
List Tables
actionGet a list of tables in the selected base, including each table's fields and views. Use List Bases to look up a base ID. See the documentationRead-onlyv0.0.6 -
Search Records
actionFind records in a table using an Airtable formula, or aSearch Field+Search Valuepair.Search Formulatakes precedence when provided; otherwiseSearch FieldandSearch Valuemust both be set. Use List Tables first to look up the table's field names. See the documentationRead-onlyv1.0.0 -
Update Comment
actionUpdate an existing comment on a selected record. See the documentationWritev0.0.15 -
Update Field
actionUpdate an existing field in a table. See the documentationWritev0.0.15 -
Update Record
actionUpdate a record's fields by Record ID — a partial update; only the fields included inrecordare changed, all others are left as-is. Use List Tables to look up field names first, and List Records to find the record's ID. See the documentationWritev1.0.0 -
Update Table
actionUpdate an existing table. See the documentationWritev0.0.15
EVENTS
Airtable triggers
Event sources your backend can deploy for users and receive through a webhook.
-
New Field Created (Instant)
triggerEmit new event when a field is created in the selected table. See the documentationInstantv1.0.6 -
New or Modified Field (Instant)
triggerEmit new event when a field is created or updated in the selected tableInstantv1.0.6 -
New or Modified Records (Instant)
triggerEmit new event for each new or modified record in a table or viewInstantv1.0.6 -
New or Modified Records in View
triggerEmit new event for each new or modified record in a viewv0.0.16 -
New Record Created, Updated or Deleted (Instant)
triggerEmit new event when a record is added, updated, or deleted in a table or selected view.Instantv0.1.6 -
New Record(s) Created (Instant)
triggerEmit new event for each new record in a tableInstantv1.0.6 -
New Records in View
triggerEmit new event for each new record in a viewv0.0.15 -
New, Modified or Deleted Records
triggerEmit new event each time a record is added, updated, or deleted in an Airtable table. Supports tables up to 10,000 recordsv0.0.15
MULTI-APP
Use Airtable with other popular apps
Most products don't stop at one integration. Pair Airtable with the other apps your users rely on, and ship use cases that span both.
- App slug
- airtable_oauth
- Authentication
- OAuth
- Categories
- Productivity
- Actions
- 19
- Triggers
- 8
- API proxy
- Available
OAuth scopes
These are the scopes Pipedream's managed Airtable OAuth client requests when one of your users connects an account. Supply your own OAuth client to request a different set.
- data.records:read
- data.records:write
- data.recordComments:read
- data.recordComments:write
- schema.bases:read
- schema.bases:write
- webhook:manage
- user.email:read