Airtable
Files & storageBearer tokenConnection test available
Create records in Airtable (personal access token).
OCNORA ships 16 typed Airtable operations and 1 trigger. Each node has a schema-driven form, input and output tables beside its settings, and is pre-flighted by Workflow Health before your first real run. Endpoints not covered by a typed node are called at https://api.airtable.com/v0 through the HTTP node with the same credential.
Before you connect Airtable
- Authentication
- Bearer token
- Credential
- the Airtable personal access tokenthe Airtable access token
- Connection test
- Available: the stored credential can be checked against the provider when you add it. This is not a record that a test was run or passed.
- Prerequisites
- The token needs the webhook:manage scope as well as data read access to the base — webhook:manage creates the subscription and reads its change log. Publishing also needs MANTLE_APP_PUBLIC_BASE_URL set: it is the address Airtable calls back on.
Prerequisites are taken from the connection notes in this provider’s node contracts; each node’s reference page says which apply to it.
What you can do with Airtable
Operations, grouped by what they do to your data, plus 1 trigger that start a run.
Read and search 5
Delete and cancel 2
A sample Airtable workflow
- 1Record Changedtrigger.airtable_recordStart a run when a record is created, updated or deleted in a table.
- 2Get Base Schemaairtable.get_base_schemaRead a base's schema: every table with its id, primary field, fields and views.
- 3Create Fieldairtable.create_fieldAdd a column to an Airtable table, with its type and type-specific options.
An outline built from this provider’s node contracts, not a recorded run. Each step’s output fields are available to the next in the field picker.
Every node below has a reference page: what it does, the connection it needs, its config fields with types, constraints and examples, and the shapes it emits.
Operations 16
- Create FieldAdd a column to an Airtable table, with its type and type-specific options.airtable.create_field
- Create RecordCreate a record in an Airtable base/table.airtable.create_record
- Create Records (batch)Create many Airtable records in one step, chunked into Airtable's 10-records-per-request batches.airtable.create_records
- Create TableCreate a table in an Airtable base, with its initial set of fields.airtable.create_table
- Delete RecordDelete one Airtable record by its record id.airtable.delete_record
- Delete Records (batch)Delete many Airtable records by id in one step, chunked into Airtable's 10-records-per-request batches.airtable.delete_records
- Get Base SchemaRead a base's schema: every table with its id, primary field, fields and views.airtable.get_base_schema
- Get RecordRead one Airtable record by its record id, with its cell values.airtable.get_record
- List BasesList every Airtable base the connection's token can reach, one page at a time.airtable.list_bases
- List RecordsList records from an Airtable base/table.airtable.list_records
- Search RecordsSearch a table with a filterByFormula, a view, a sort order and Airtable's offset pagination, returning one page and the token for the next.airtable.search_records
- Update FieldRename an Airtable column, change its description, or change its type-specific options.airtable.update_field
- Update RecordUpdate a record's fields in an Airtable base/table (partial update).airtable.update_record
- Update Records (batch)Update many Airtable records by record id in one step, chunked into Airtable's 10-records-per-request batches.airtable.update_records
- Update TableRename an Airtable table or change its description.airtable.update_table
- Upsert RecordsUpdate Airtable records that match on chosen columns and create the ones that do not, using Airtable's performUpsert.airtable.upsert_records
Templates that use Airtable
- Form submission to Airtable with a Slack pingAn intake form writes the submission to Airtable and tells the channel it landed.
- Nightly Airtable view to a Google SheetCopy an Airtable view into a Google Sheet every night so anyone can pivot it without an Airtable seat.
- New Airtable record to a HubSpot contactA record added to an Airtable base becomes a HubSpot contact, so the list people keep by hand reaches the CRM.
- New Stripe customer to an Airtable recordEvery customer Stripe creates is written into an Airtable base so non-engineers can work the list.
Airtable questions
- How does OCNORA authenticate with Airtable?
- With a stored Bearer token credential, shaped the Airtable personal access token or the Airtable access token. A connection test can check it when you add it.
- What can I automate with Airtable?
- 16 typed operations and 1 trigger, each with a reference page listing its config fields and the shapes it emits.
- What if the Airtable operation I need is not listed?
- Call https://api.airtable.com/v0 from the HTTP node with the same credential, or describe the step to the AI builder, which asks our team for a typed node when one is missing.
- Are there templates that use Airtable?
- Yes: 4 templates, listed above.
- How are Airtable calls controlled?
- Every call and every run step is audited, runs count against the execution budget, and Workflow Health pre-flights the workflow when you save it.
See your first Airtable workflow run.
Book a technical demo. We add the connection, pick a template or describe the workflow to Build with AI, and Workflow Health checks it before it runs.