Turn new entries in an Airtable view into ready to work tasks and alert the right person in Slack. Great for teams that run recurring client or project work and want tasks created from a template without manual steps.

When a record enters a specific Airtable view, the flow pulls the full Automate record, looks up the task template, the assignee, and the client. A code step calculates dates like start and due based on the record fields. It then creates a new Task in Airtable through an HTTP request, updates the source Automate record to mark it done and store timestamps, and finally posts a Slack message to the assignee. IDs for the Airtable base and tables are stored in one Set node, so you can adapt it to your base without hardcoding.

You will need an Airtable base with the required tables and fields visible in the trigger view, plus Airtable and Slack credentials in n8n. Expect faster handoffs, fewer mistakes, and clear ownership. This is useful for onboarding checklists, client deliverables, and scheduled production tasks. Setup is straightforward and testing is as simple as adding a record with today’s start date.

• Airtable Entered View trigger starts the flow when a record appears in the target view.
• Central Set node stores base and table IDs to keep configuration simple.
• Fetch related records for template, assignee, and client to build a complete task.
• Code step calculates start and due dates from input fields and current time.
• HTTP request creates the Task record in Airtable with mapped fields and status.
• Patch request updates the source Automate record to mark the first task created and log timestamps.
• Slack message notifies the assigned team member with key task details.
• Field level mappings mirror your Airtable schema for easy customization.

• Reduce manual task setup from 15 minutes to 1 minute
• Automate 90 percent of repetitive task creation steps
• Improve data accuracy by 95 percent with template based fields
• Connect Airtable and Slack so updates reach the right person fast
• Handle up to 5 times more recurring tasks without adding staff

1. Import the template into n8n: Create a new workflow in n8n > Click the three dots menu > Select 'Import from File' > Choose the downloaded JSON file.
2. You'll need accounts with Airtable and Slack. See the Tools Required section above for links to create accounts with these services.
3. In Airtable, prepare a base with tables for Automate, Tasks, Templates, Team, and Clients. Create a view for Automate named for your first task step and make sure the updated_at field is visible in that view.
4. Create an Airtable API token from your Airtable account. In n8n, double click any Airtable HTTP Request or Airtable node, choose 'Credential to connect with', click 'Create new credential' for Airtable Token or Airtable API Key, then follow the on screen steps. Give the token access to the target base.
5. Open the Airtable Trigger node in n8n. Enter your Base ID, Table ID, and View ID that matches the Automate view where records enter the flow.
6. Open the node named Airtable Base ID's and enter base_id, table_automate_id, table_task_id, table_template_id, table_team_id, and table_clients_id from your Airtable base.
7. Verify the Get Automated Task, Get Task Template, Get Assignee, and Get Client nodes each point to the correct table IDs and the field names match your base.
8. Open the Create Task HTTP Request node. Ensure the Content Type header is application/json and the Airtable credential is selected. Confirm the JSON body maps to fields like Status and Task Name in your Tasks table.
9. Review the Calculate Dates code step. Adjust date math or timezone if your process needs different offsets for start and due dates.
10. Set up Slack credentials: double click the Notify Assignee node, choose 'Create new credential', follow the Slack OAuth steps, and approve chat permissions. Map the message target to the assignee user or a default channel.
11. Turn on the workflow. In Airtable, add a test Automate record with a Start Date of today. Confirm a new Task is created, the Automate record updates fields like First Task Created, and a Slack message is sent.
12. Troubleshoot: if nothing triggers, check the view filters and that updated_at is visible. If the task is not created, verify table IDs, field names, and token scopes. If Slack fails, confirm the app is installed in the workspace and the user or channel ID is correct.