When a record is added in Airtable, send a notification in Outlook and create a task

■Overview

Airtable’s flexible database features make it useful for task management, but manually notifying stakeholders or registering tasks in another tool every time a new task is added can be time-consuming. These manual processes can also lead to mistakes, such as missed follow-ups. With this workflow, whenever a record is added to Airtable, Outlook automatically sends a notification email and creates a task at the same time, helping you resolve these challenges smoothly.

‍

■Who This Template Is For

• Teams that use Airtable and Outlook together and want to eliminate the hassle of entering tasks in multiple places
• Teams that want to automate quick information sharing with stakeholders whenever a record is added to Airtable
• Teams that want to prevent missed task registrations and improve task management accuracy

‍

■Benefits of This Template

• Adding a record to Airtable automatically sends an email notification through Outlook and creates a task, reducing the time spent on manual work.
• Prevent human errors that commonly occur when sharing information manually, such as missed notifications and forgotten task registrations.

‍

■Flowbot Workflow

1. First, connect Airtable and Outlook to Yoom.
2. Next, select Airtable as the trigger and set the action to “When a record is created.”
3. Then, set the Outlook operation to “Send an email” and notify the relevant stakeholders.
4. Finally, set the Outlook operation to “Create a task” and create a task based on the Airtable record information.

* “Trigger”: An action that starts the flow. “Operation”: An action that processes information within the flow after the trigger starts.

‍

■Customization Options

• In the Airtable trigger settings, specify the base ID, table ID, and field name used to determine when a record was created for the records you want to include.
• In the Outlook operation settings, you can specify the user ID and task list ID where you want to create tasks.

‍

■Notes

• Connect both Airtable and Outlook to Yoom.
• You can choose a trigger interval of 5, 10, 15, 30, or 60 minutes.
• The shortest available trigger interval varies by plan.
• Microsoft 365 (formerly Office 365) offers plans for home use and business use (Microsoft 365 Business). Authentication may fail if you are not subscribed to a business plan.
• Airtable outputs can be retrieved using JSONPath. See this guide for details.