How to Send Airtable Record Alerts to Slack with Pipedream

Workflows > New > Select a trigger

Create new Pipedream workflow

Go to pipedream.com and click New Workflow in the top right. You'll see a blank workflow canvas. Click on the trigger step labeled 'Select a trigger' at the top. Search for 'Airtable' in the app list and select it.

1. 1Click 'New Workflow' button
2. 2Click the 'Select a trigger' box
3. 3Search 'Airtable' in the apps list
4. 4Select 'Airtable' from results

Trigger > Airtable > New record in table

Configure Airtable webhook trigger

Select 'New record in table' from the Airtable trigger options. Connect your Airtable account by clicking 'Connect Account' and following the OAuth flow. Once connected, select your base from the dropdown, then choose the specific table you want to monitor.

1. 1Choose 'New record in table' trigger
2. 2Click 'Connect Account' button
3. 3Authorize Pipedream in the Airtable popup
4. 4Select your base from the dropdown
5. 5Choose the table to monitor

Trigger > Test

Test the Airtable trigger

Click 'Generate test event' to create a sample webhook payload. If you have existing records, Pipedream will use one as test data. If your table is empty, manually add a test record to your Airtable base first. The test data shows you exactly what fields are available for your Slack message.

1. 1Click 'Generate test event' button
2. 2Wait for Pipedream to fetch a sample record
3. 3Review the test data structure
4. 4Note which fields you want in Slack

Steps > + > Slack > Send message to a channel

Add Slack action step

Click the + button below your trigger to add a new step. Search for 'Slack' and select it from the app list. Choose 'Send message to a channel' as your action type. This gives you the most formatting control for your notifications.

1. 1Click the + button below the trigger
2. 2Search for 'Slack' in the apps list
3. 3Select 'Slack' from results
4. 4Choose 'Send message to a channel'

Slack Step > Connect Account

Connect your Slack workspace

Click 'Connect Account' to link your Slack workspace. You'll be redirected to Slack to authorize Pipedream. Make sure you're signed into the correct workspace before authorizing. Pipedream needs permissions to post messages and read channel information.

1. 1Click 'Connect Account' for Slack
2. 2Select your Slack workspace
3. 3Click 'Allow' to grant permissions
4. 4Return to Pipedream automatically

Slack Step > Channel & Message

Configure channel and message

Select the Slack channel from the dropdown where notifications should appear. In the message field, you'll build your notification using Airtable data. Reference fields from your trigger using the format steps.trigger.event.fields.FieldName. Start with something simple like the record name and creation time.

1. 1Select your target channel from dropdown
2. 2Click in the 'Message' text field
3. 3Reference Airtable fields using steps.trigger.event syntax
4. 4Add descriptive text around the field values

Slack Step > Message formatting

Format message with field values

Build a readable notification message using your Airtable fields. For a content calendar, you might use: 'New blog post added: {{steps.trigger.event.fields.Title}} - Due: {{steps.trigger.event.fields.Due Date}} - Assigned to: {{steps.trigger.event.fields.Writer}}'. Use Slack formatting like *bold* and _italics_ to make important information stand out.

1. 1Add a clear subject line for your notification
2. 2Insert relevant Airtable field values
3. 3Use Slack markdown for emphasis
4. 4Include any static text for context

Slack Step > Test

Test the complete workflow

Click 'Test' on your Slack step to send a test message using your sample Airtable data. Check your Slack channel to see how the message appears. If formatting looks wrong or fields are empty, go back and adjust your message template. The test uses the same record data from step 3.

1. 1Click 'Test' button on Slack step
2. 2Wait for the test to complete
3. 3Check your Slack channel for the message
4. 4Review formatting and field values

Workflow > Deploy

Deploy the workflow

Click 'Deploy' in the top right to activate your workflow. Pipedream will start listening for new Airtable records immediately. The webhook endpoint gets registered with Airtable automatically. You'll see the status change to 'Active' with a green indicator.

1. 1Click 'Deploy' button in top right
2. 2Confirm deployment in the popup
3. 3Wait for status to show 'Active'
4. 4Note the webhook URL if needed

Workflow > Executions

Verify with live test

Add a new record to your Airtable table to confirm everything works. The Slack notification should appear within 15-30 seconds. If nothing happens, check the workflow execution logs in Pipedream for errors. Look for authentication issues or missing field values that might break the message formatting.

1. 1Add a real record to your Airtable table
2. 2Wait 30 seconds for notification
3. 3Check Slack for the new message
4. 4Review execution logs if needed

Add this Node.js code step between Airtable and Slack to format dates nicely and add emojis based on priority. Paste it in a new code step after your Airtable trigger.

export default defineComponent({
  async run({ steps, $ }) {
    const record = steps.trigger.event.fields;

export default defineComponent({
  async run({ steps, $ }) {
    const record = steps.trigger.event.fields;
    
    // Format due date nicely
    let formattedDate = 'No due date';
    if (record['Due Date']) {
      const date = new Date(record['Due Date']);
      formattedDate = date.toLocaleDateString('en-US', { 
        month: 'short', 
        day: 'numeric' 
      });
    }
    
    // Add priority emoji
    const priorityEmojis = {
      'High': '🔴',
      'Medium': '🟡', 
      'Low': '🟢'
    };
    const priorityEmoji = priorityEmojis[record.Priority] || '⚪';
    
    // Build enhanced message
    const enhancedMessage = `${priorityEmoji} *${record.Title || 'New Record'}*\n` +
      `📅 Due: ${formattedDate}\n` +
      `👤 Assigned: ${record.Writer || 'Unassigned'}\n` +
      `📊 Status: ${record.Status || 'New'}`;
    
    return {
      message: enhancedMessage,
      priority: record.Priority,
      formatted_date: formattedDate
    };
  }
});