Daily Task Review: Pull All Asana Work into Airtable
Every morning, you open Asana to see what's on your plate, then open Airtable to plan your day. Notis gives you one view: a fresh daily table in Airtable with all your open work pulled from Asana at 8 AM sharp.
Trigger
Recurring schedule
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Action
List records
Retrieves records from an airtable table, with options for filtering, sorting, pagination, and specifying returned fields.
Why this helps
You start your day by context-switching between Asana and Airtable, trying to piece together a coherent picture of what's due today—time burned before you've done anything.
- See your whole day in one place
- No tool-switching to start work
- Fresh list every morning
- Fewer dropped tasks
Setup
Build it in a few focused steps.
- 1Connect Asana and Airtable to Notis (one-time in the portal).
- 2Tell Notis: 'Every morning at 8 AM, pull all my open Asana tasks and create a list in my Airtable daily review table.'
- 3Set your timezone so 8 AM is accurate for you.
- 4Pick your notification channel to confirm the sync happened.
- 5Test it by running the automation manually, then check that tasks appear in your Airtable daily table.
Questions about this workflow
Can I change the time from 8 AM?
Yes. Just tell Notis your preferred time (9 AM, 6 AM, etc.) and it adjusts.
What counts as an 'open' task?
Tasks not marked Done. If you want to include specific projects or teams, tell Notis and it will filter.
Does this create new records or update existing ones?
Notis creates fresh records each day in your daily table, so you get a snapshot. Old days stay in history if you want to track them.
Can I set it for multiple times per day?
Yes. You can create separate automations for different times (e.g., 8 AM review, noon check-in, 5 PM wrap-up).
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link Asana to Airtable. A trigger fires from one place; an action lands in another.
Asana triggers
Airtable actions
Attachment Added to Task
Triggers when an attachment is added to a task.
Create base
Creates a new airtable base with specified tables and fields within a workspace; ensure field options are valid for their type.
New Comment on Task
Triggers when a comment is added to a task in a project.
Create Comment
Creates a new comment on a specific record within an airtable base and table.
New Task Created
Triggers when a new task is created in a project.
Create Field
Creates a new field within a specified table in an airtable base.
Task Moved to Section
Triggers when a task is moved to a section in a project.
Create multiple records
Creates multiple new records in a specified airtable table.
Tag Added to Task
Triggers when a tag is added to a task. Note: Asana's event structure is inverted for tag events — the resource is the task and the parent is the tag. So parent.gid gives the tag GID.
Create a record
Creates a new record in a specified airtable table; field values must conform to the table's column types.
Task Updated
Triggers when a task is updated in a project.
Create table
Creates a new table within a specified existing airtable base, allowing definition of its name, description, and field structure.
Delete Comment
Deletes an existing comment from a specified record in an airtable table.
Delete multiple records
Deletes up to 10 specified records from a table within an airtable base.
Connect any two apps with Notis in the middle.
Not just Asana and Airtable. Any combination from 985+ integrations.
When this happens · Trigger
Do this · Action
Save your first hour today.
7 days free trial with 20$ free usage included.
No card. Works with personal or business Airtable.