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.
Airtable Account: Ensure you have an active Airtable account with the appropriate permissions to access the data you intend to integrate.
Personal Access Token: Airtable's API requires a Personal Access Token for authentication.
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.
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
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.
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 -
Add following Access
ALL WORKSPACES, Select →
All current and future bases in all current and future workspaces
Create Token. You will be shown Newly created Token. You can use this in Api Key section in DronaHQ.
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
|Retrieve a list of rows from a specified table based on certain conditions or filters.
|Find a Row
|Fetch a single row from a table based on specific criteria or field values.
|Add a new row to the specified table, filling in the required field values.
|Modify the values of a row in the table using specific field updates or changes.
|Remove a row from the table based on unique identifiers or field values.
|Locate 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
- Navigate to the Action flow section.
Server-side actions > Ready Third-partyconnectors, choose the
- Select a specific action from the available options and click
- 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.
- 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.
- To create a new row, select
Select from Airtableand proceed.
- Enter the Base ID copied from Airtable and specify the Table name.
- List of table columns will be displayed. Input static or dynamic values using Keywords or values, depending on your needs.
- After entering the details, continue and provide a unique Action name.
- 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:
- Choose the appropriate connector for your requirement.
- Select the connected Airtable account and proceed by clicking Continue.
- Specify the Column to search: Enter the name or use a keyword of the column to be searched.
- Provide the Value to search: Enter the value to be searched in the specified column. This can also be a dynamic value.
- Determine the Search Direction: Select whether to search from top to bottom or bottom to top in the table.
- Filter by Formula (optional): Advanced users can use Airtable formulas to further filter data. Refer to Airtable's formula documentation for more details.
- 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.
- Specify the Table name: Enter the table name within the specified Base.
- Set the Sort attribute (optional): You can provide formulas to sort records based on specific attributes and order.
- Apply Transformations (optional): Modify connector response keys using Column transformations if needed.
- 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.