How to Send Airtable Status Change Alerts to Slack with n8n

Base > Automations > Create automation

Enable Airtable webhooks

Open your Airtable base and navigate to the Automations tab. You need webhook functionality to trigger n8n when records change. Airtable's webhook feature sends HTTP requests to n8n whenever your specified field changes. This replaces the old polling method that checked for changes every 5-15 minutes.

1. 1Click the Automations tab in your Airtable base
2. 2Click 'Create automation' button
3. 3Select 'When record matches conditions' trigger
4. 4Choose your table and set condition to Status field changes

Workflows > + > Add node

Create n8n workflow

Log into your n8n instance and create a new workflow. Start with a Webhook node to receive Airtable's status change notifications. The webhook URL you generate here goes back to Airtable in the next step. n8n will parse the incoming JSON payload and extract the changed record data.

1. 1Click the + button to add a node
2. 2Search and select 'Webhook' node
3. 3Set HTTP Method to POST
4. 4Copy the webhook URL from the node panel

Automations > Add action > Send webhook

Configure Airtable webhook action

Return to your Airtable automation and add a webhook action that calls n8n. Paste the webhook URL from step 2 into the URL field. Configure the JSON payload to include record ID, status field value, assigned user, and any other fields you need for the Slack message. Test the webhook connection to verify n8n receives the data.

1. 1Click 'Add action' in your Airtable automation
2. 2Select 'Send a webhook' action
3. 3Paste your n8n webhook URL
4. 4Set Method to POST and add record data to JSON payload

Credentials > + > Slack OAuth2 API

Add Slack credential

Create a Slack app credential in n8n to send direct messages. You need a bot token with chat:write and users:read scopes. The users:read scope lets you look up team members by email if your Airtable stores email addresses instead of Slack user IDs. Generate the bot token in your Slack app settings, not your workspace settings.

1. 1Go to Credentials in the left sidebar
2. 2Click + and search for 'Slack OAuth2 API'
3. 3Enter your Slack bot token
4. 4Test the connection

Add node > Code > JavaScript

Parse webhook data

Add a Code node after your webhook to clean up the incoming Airtable data. Airtable sends nested JSON with field IDs that need transformation. Extract the record ID, new status value, and assigned user information. Convert field IDs to readable field names and handle any data type conversions needed for the Slack message.

1. 1Add a Code node after the webhook
2. 2Select 'Run Once for All Items' mode
3. 3Write JavaScript to parse the Airtable payload
4. 4Return clean data structure for Slack

Add node > Slack > User > Get User by Email

Look up Slack user

Add a Slack node to find the user ID for your assigned team member. If Airtable stores email addresses, use the 'Get User by Email' operation. If it stores names, use 'List Users' and filter by display name. You need the Slack user ID (starts with U) to send direct messages, not the email or display name.

1. 1Add a Slack node after the Code node
2. 2Select 'User' resource and 'Get User by Email' operation
3. 3Map the email field from your parsed data
4. 4Use your Slack credential from step 4

Add node > Slack > Message > Post Message

Send Slack DM

Add another Slack node to send the direct message. Use the 'Post Message' operation and set the channel to the user ID from the previous step. Format your message with the record details, old vs new status, and a link back to the Airtable record. Include relevant context like project name or deadline if available in your data.

1. 1Add another Slack node
2. 2Select 'Message' resource and 'Post Message' operation
3. 3Set Channel to the user ID from previous node
4. 4Format your message text with status change details

Airtable > Your base > Change status field

Test status change

Return to Airtable and change a record's status field to trigger the workflow. Watch the n8n execution log to verify each step completes successfully. Check that the assigned user receives the Slack DM with correct information. Test with different status transitions and users to verify the mapping works consistently.

1. 1Open a record in your Airtable base
2. 2Change the status field value
3. 3Check n8n executions page for new runs
4. 4Verify Slack DM was delivered

Airtable > Automations > Toggle automation on

Activate Airtable automation

Turn on your Airtable automation to start sending webhooks for all status changes. The automation runs continuously once activated and will trigger n8n whenever matching records change. Monitor the first few executions to catch any edge cases or data format issues before rolling out to your full team.

1. 1Return to your Airtable automation
2. 2Click the toggle switch to activate it
3. 3Confirm activation in the popup dialog
4. 4Check automation run history

Add this JavaScript code to the Code node to handle missing users gracefully and format status change messages with context. Paste this after the webhook node to parse Airtable data and add fallback logic.

// Parse Airtable webhook payload and format for Slack
const items = $input.all();
const results = [];

// Parse Airtable webhook payload and format for Slack
const items = $input.all();
const results = [];

for (const item of items) {
  const payload = item.json;
  
  // Extract record data from Airtable webhook
  const recordId = payload.record?.id;
  const fields = payload.record?.fields || {};
  
  // Map field IDs to readable names (update these IDs for your base)
  const status = fields['fldSTATUS123']; // Replace with your status field ID
  const assignedEmail = fields['fldUSER456']; // Replace with your user field ID
  const recordName = fields['fldNAME789']; // Replace with your name field ID
  const project = fields['fldPROJ012']; // Replace with your project field ID
  
  // Build Airtable record URL
  const baseId = payload.base?.id;
  const tableId = payload.table?.id;
  const recordUrl = `https://airtable.com/${baseId}/${tableId}/${recordId}`;
  
  // Format status change message with emoji
  const statusEmoji = {
    'Draft': '📝',
    'Review': '👀', 
    'Approved': '✅',
    'Complete': '🎉',
    'Blocked': '🚫'
  };
  
  const emoji = statusEmoji[status] || '📋';
  const messageText = `${emoji} ${recordName} status changed to ${status}.`;
  const fullMessage = project ? 
    `${messageText} Project: ${project}. View: ${recordUrl}` :
    `${messageText} View: ${recordUrl}`;
  
  // Skip if missing required fields
  if (!assignedEmail || !status || !recordName) {
    console.log('Skipping record due to missing required fields');
    continue;
  }
  
  results.push({
    json: {
      assigned_email: assignedEmail,
      status: status,
      record_name: recordName,
      project: project || '',
      record_url: recordUrl,
      message_text: fullMessage,
      record_id: recordId
    }
  });
}

return results;