Skip to main content

Airtable trigger

Airtable is a spreadsheet-database hybrid, with the features of a database but applied to a spreadsheet. The fields in an Airtable table are similar to cells in a spreadsheet, but have types such as 'checkbox', 'phone number', and 'drop-down list', and can reference file attachments like images.

!!! note "Credentials" You can find authentication information for this node here.

Example Usage​

This workflow allows you to receive a Mattermost message when new data gets added to Airtable. You can also find the workflow on Robbot Automation. This example usage workflow would use the following nodes.

  • [Mattermost](/integrations/builtin/app-nodes/Robbot Automation-nodes-base.mattermost/)

1. Airtable Trigger node​

The Airtable Trigger node will trigger the workflow when new data gets added to Airtable.

  1. First of all, you'll have to enter credentials for the Airtable Trigger node. You can find out how to do that here.
  2. Click on Add Poll Time and select 'Every Minute' from the Mode dropdown list. This will check Airtable every minute for new data entries.
  3. Enter the Base ID in the Base ID field. For obtaining the Base ID, head over to their API page and select the correct base. You'll find the Base ID there.
  4. Enter the table name in the Table field.
  5. Enter a trigger field name in the Trigger Field field. If you don't have a 'Created Time' or 'Last modified time' field in your table, please create one.
  6. Click on Save to run the node.

2. Mattermost node (post: message)​

This node will send a message about the new data in the channel 'Information Updated' in Mattermost. If you have a different channel, use that instead.

  1. First of all, you'll have to enter credentials for the Mattermost node. You can find out how to do that here.

  2. Select a channel from the Channel ID dropdown list.

  3. Click on the gears icon next to the Message field and click on Add Expression.

  4. Enter the following message in the Expression field:

New Data was added to Airtable.
ID:{{$node["Airtable Trigger"].json["fields"]["id"]}}
Name: {{$node["Airtable Trigger"].json["fields"]["name"]}}
  1. Click on Save to run the node.

!!! note "Activate workflow for production" You'll need to save the workflow and then click on the Activate toggle on the top right of the screen to activate the workflow. Your workflow will then be triggered as specified by the settings in the Airtable Trigger node.