Airtable

Airtable is a lightweight database

---

Airtable is a lightweight solution that combines the functionalities of a spreadsheet and a database, enabling you to organize and manage data efficiently.

Airtable will require Auth! Get your API key here: https://airtable.com/create/tokens

Make sure to select the correct scopes and the correct Airtable base when creating your API key.

1. .read permissions allow your tool to simply read and query data from your database without changing anything.

2. .write permissions grant access for your Tool to change data in your Airtable.

You will also need your Airtable BaseID, you can find this in the URL when you are inside your Airtable Base. The BaseID is highlighted red. https://airtable.com/appjQIqnqbsVv2toR/tblV8O6b3X82GIZsO/viwbcqMXpsOjHju7f

OpenAPI Schema to GET customer information from Airtable

openapi: 3.1.0
info:
  title: Airtable Customers API
  description: API for retrieving information about a customer from the Customers table in Airtable.
  version: 1.0.0
servers:
  - url: https://api.airtable.com/v0/BASE_ID
    description: Airtable API Base
paths:
  /TABLE_NAME:
    get:
      operationId: getCustomerByName
      summary: Retrieve a customer’s details by name.
      description: Fetches details about a customer based on the provided Name from Airtable’s Customers table.
      security:
        - apiKeyAuth: []
      parameters:
        - name: Name
          in: query
          required: true
          description: The name of the customer to retrieve.
          schema:
            type: string
      responses:
        '200':
          description: Successfully retrieved customer details.
          content:
            application/json:
              schema:
                type: object
                properties:
                  records:
                    type: array
                    description: List of matching customer records
                    items:
                      type: object
                      properties:
                        id:
                          type: string
                          description: The Airtable record ID for the customer
                        fields:
                          type: object
                          properties:
                            Name:
                              type: string
                              description: The name of the customer
                            Email:
                              type: string
                              description: The email address of the customer
                            Age:
                              type: integer
                              description: The age of the customer
                            Experience:
                              type: string
                              description: The experience level of the customer
                        createdTime:
                          type: string
                          format: date-time
                          description: The time when the record was created
        '400':
          description: Bad request or invalid input.
        '401':
          description: Authentication failed.
components:
  securitySchemes:
    apiKeyAuth:
      type: apiKey
      in: header
      name: Authorization
      description: 'Airtable API key (use format: Bearer)'

OpenAPI Schema to POST the name & Email of a Lead to Airtable

openapi: 3.1.0
info:
  title: Airtable Resources API
  description: API for posting data into Airtable.
  version: 1.0.0
servers:
  - url: https://api.airtable.com/v0/BASE_ID
    description: Airtable API Base
paths:
  /TABLE_NAME:
    post:
      operationId: postLead
      summary: Post a new record to your table.
      description: Adds a new record with Name and Email to your Airtable.
      security:
        - apiKeyAuth: []
      requestBody:
        required: true
        content:
          application/json:
            schema:
              type: object
              properties:
                fields:
                  type: object
                  properties:
                    Name:
                      type: string
                      description: The name associated with the resource
                    Email:
                      type: string
                      description: The email address associated with the resource
                  required:
                    - Name
                    - Email
              required:
                - fields
      responses:
        '201':
          description: Resource successfully added to your Airtable.
          content:
            application/json:
              schema:
                type: object
                properties:
                  id:
                    type: string
                    description: The Airtable record ID for the newly created resource
                  fields:
                    type: object
                    properties:
                      Name:
                        type: string
                        description: The name associated with the resource
                      Email:
                        type: string
                        description: The email address associated with the resource
                  createdTime:
                    type: string
                    format: date-time
                    description: The time when the record was created
        '400':
          description: Bad request or invalid input.
        '401':
          description: Authentication failed.
components:
  securitySchemes:
    apiKeyAuth:
      type: apiKey
      in: header
      name: Authorization
      description: 'Airtable API key (use format: Bearer)'

---

Relevance AI also offer a popular Airtable Tool which can be easily configured with Agentive. We provide a tutorial for you here.