Post a message in Slack when a record is changed in Airtable

What each client fills in

Slack: Channel

For example #leads or C0123456789

Airtable: Base ID

For example appXXXXXXXXXXXXXX

Airtable: Table

For example Leads

Airtable: Last modified time field

A field of type “Last modified time” in this table.

The accounts it needs

Each is the client’s own, stored encrypted and never copied between clients. Until one is added the client’s checklist shows it, and nothing runs.

• Airtable

  airtable.com/create/tokens → Create token → scopes data.records:write and data.records:read (lookups and the triggers) → add the client’s base → copy the token.

• 

  In the client’s Slack: api.slack.com/apps → Create New App → OAuth & Permissions → add the chat:write scope (and channels:history, plus groups:history for a private channel, for the message trigger) → Install to Workspace → copy the Bot User OAuth Token. Invite the app to the channel.

After you install it

It lands switched off. The client’s checklist holds exactly this:

1. Connect the client’s Airtable, for “A record is changed”
2. Connect the client’s Slack, for “Post a message”
3. Fill in Airtable: Base ID (For example appXXXXXXXXXXXXXX)
4. Fill in Airtable: Table (For example Leads)
5. Fill in Airtable: Last modified time field (A field of type “Last modified time” in this table)
6. Fill in Slack: Channel (For example #leads or C0123456789)