Skip to main content

Airtable

Airtable is a spreadsheet-database hybrid, with the features of a database but the power of a spreadsheet. DronaHQ provides integration with Airtable that allows you to manage the Airtable tables and keep track of anything and everything.

Prerequisite​

  1. Airtable Account: Ensure you have an active Airtable account with the appropriate permissions to access the data you intend to integrate.

  2. Personal Access Token: Airtable's API requires a Personal Access Token for authentication.

  3. Base ID: Identify the specific Base within your Airtable account that you want to connect with. You can find the Base ID by navigating to the Airtable API page and selecting the desired Base. Copy the Base ID from the Introduction section.

  4. Table Name: Determine the exact name of the table within your chosen Base from which you want to retrieve data.

Configuring API Connector in DronaHQ​

Add a Account name. Then add the API key/Personal Access Token, Base ID and Table name for the connector account. Once all details are added, click Save. Your connector configuration is now done.

caution

API Keys are deprecated. Use Personal Access Tokens instead.

Personal Access Token​

To Create one, Go to Create Access tokens page, and click on + Create New token. Enter Friendly Name and Add Following Scope -

  • data.records:read
  • data.records:write
  • schema.bases:read

Add following Access​

Under ALL WORKSPACES, Select → All current and future bases in all current and future workspaces

Providing access
Providing access

Click on Create Token. You will be shown Newly created Token. You can use this in Api Key section in DronaHQ.

Base ID​

To find your Airtable Base ID, open the Airtable API page and click the Base that you want to use. You will find the ID of your base in the Introduction section.

Supported API endpoints​

Action NameDescription
Find RowsRetrieve a list of rows from a specified table based on certain conditions or filters.
Find a RowFetch a single row from a table based on specific criteria or field values.
Create RowAdd a new row to the specified table, filling in the required field values.
Update RowModify the values of a row in the table using specific field updates or changes.
Delete RowRemove a row from the table based on unique identifiers or field values.
FindRowByIdLocate a row in the table using a unique identifier, such as a record ID or primary key.

Here is the structured information about using the Airtable connector:

Using Airtable Connector​

Adding Airtable Connector to an Action Flow​

  1. Navigate to the Action flow section.
  2. Under Server-side actions > Ready Third-party connectors, choose the Airtable connector.
  3. Select a specific action from the available options and click Continue.
  4. Authenticate the account and proceed by clicking Continue.

Creating a New Row in Airtable​

The integration with Airtable allows you to seamlessly add new records to your designated table. Let's take an example of adding a new record to the Marketing table within the Marketing Team base.

  1. Keep in mind that Airtable doesn't offer a meta API to list columns, so fetching 1 row from Airtable provides column information. Ensure you've added at least 1 row with all columns filled to reflect in the Add Row connector.
  2. To create a new row, select Create row under Select from Airtable and proceed.
  3. Enter the Base ID copied from Airtable and specify the Table name.
Enter config details
Enter config details
  1. List of table columns will be displayed. Input static or dynamic values using Keywords or values, depending on your needs.
  2. After entering the details, continue and provide a unique Action name.
NOTE
  • For complex column types like Attachments, ensure the data is prepared in the expected format. Custom functions or JS code can be used to handle such cases.
  • Formula columns and nested key values should be managed appropriately.
  • Custom functions can be implemented to support column formats that aren't natively supported.

Finding Rows in Airtable​

In scenarios where you need to locate specific records for actions like updates or deletions, the Find row/rows feature comes in handy. This process involves searching for rows based on certain criteria and obtaining their record IDs, which can then be utilized for targeted actions.

To find rows in Airtable using the connector, follow these steps:

  1. Choose the appropriate connector for your requirement.
  2. Select the connected Airtable account and proceed by clicking Continue.
  3. Specify the Column to search: Enter the name or use a keyword of the column to be searched.
  4. Provide the Value to search: Enter the value to be searched in the specified column. This can also be a dynamic value.
  5. Determine the Search Direction: Select whether to search from top to bottom or bottom to top in the table.
  6. Filter by Formula (optional): Advanced users can use Airtable formulas to further filter data. Refer to Airtable's formula documentation for more details.
  7. Enter the Base ID: This ID is available in your Airtable base's API Documentation under Help. Copy and paste it into the respective field.
  8. Specify the Table name: Enter the table name within the specified Base.
  9. Set the Sort attribute (optional): You can provide formulas to sort records based on specific attributes and order.
  10. Apply Transformations (optional): Modify connector response keys using Column transformations if needed.
Enter config details
Enter config details
  1. Add the unique Action name and ensure you set a Variable to return values. Depending on the action used (find row or find rows), the record IDs will be available as output.records.id. This response can be used in subsequent connectors.
info

Keep in mind that the Airtable API returns only keys of rows with present values, which might differ from Studio's expectation of consistent keys. To overcome this, ensure cells are filled or create a custom JavaScript function for consistent output.

Last updated on