⬜ Airtable

The Airtable block allows you to connect your Celestory project to an Airtable database to read, modify, add or delete data. It is particularly useful for managing structured information such as player scores, inventories or contact lists directly from an online spreadsheet.

This block facilitates integration with Airtable by offering CRUD (Create, Read, Update, Delete) operations to dynamically interact with your data.

📥 Entries

• in (Trigger): Triggers the execution of the block. Must be linked to a previous block to activate the action.
• config (Object): Main configuration of the block, including:
• • Base: Name of the Airtable workspace containing your database.
  • Table: Name of the specific spreadsheet (table) to use.
  • Operation: Action to be performed among:
  • • Read: Retrieves data (requires an id or a query).
    • Create: Adds a new line with the values ​​provided.
    • Update: Modifies an existing line (requires an id).
    • Delete: Deletes a line (requires an id).
• id (String): Unique identifier of an Airtable row (required for Update and Delete operations).
• query (String): Filter formula for the Read operation (ex: Name = 'Pierre'). Used if no id is provided.
• [Column Names] (Dynamic): Dynamic fields corresponding to the columns of your Airtable table, appearing automatically for Create and Update operations. Allow you to define the values ​​to insert or modify.

📤 Outings

• out (Trigger): Activates when the operation with Airtable is successfully completed.
• onError (Trigger): Activates in case of error (connection failed, ID not found, etc.).
• id (String): Unique identifier of the created row (available after a Create operation).
• [Field Names] (Dynamic): Dynamic outputs corresponding to the columns of your Airtable table, available after a Read operation. Allows access to the recovered data (text, number, etc.).

💡 Example of use

Scenario: Update a player's score in a game

1. A player finishes a game and gets a new score of 1500 points.
2. You want to save this score in your Airtable database, which already contains a row for this player (identified by his id).
3. Add an Airtable block to your graph and configure it as follows:

• Base: MyGame
• Table: PlayerScores
• Operation: Update
• id: rec123456789 (player row ID in Airtable)
• Score: 1500 (plug in the variable containing the new score here)

4. The block updates the corresponding row in Airtable with the new score.
5. If the update is successful, the flow continues through the out output to display a confirmation message to the player. In the event of an error, the onError output is activated to handle the problem (eg: display an error message).

⚙️ Technical Details

• Dynamic variable management: The inputs and outputs corresponding to the columns of your Airtable table are dynamically generated according to the block configuration. These fields appear automatically after selecting the Base and the Table.
• API key: The Airtable API key must be configured beforehand in the Integrations menu of Celestory. Without this key, the block will not be able to communicate with your database.
• Data format: Data types (text, number, boolean, etc.) are automatically mapped between Celestory and Airtable. Make sure the values ​​provided match the types expected by your table.
• Limits: Read operations without id or query will return all rows in the table, which may impact performance if the table is large. Use filters to target the necessary data.

Updated on: 04/03/2026