Weekly Summary: Bulk-Create a Project Status Table
Every Friday at 5 PM, Notis reads your whole week of Asana activity and populates an Airtable status table with what shipped, what blocked, and what's pending. One table, no manual roll-up.
Trigger
Recurring schedule
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Action
Create multiple records
Creates multiple new records in a specified airtable table.
Why this helps
Friday comes and you spend an hour manually building a status report from Asana—tasks moved, blockers hit, progress made—instead of finishing work or going home.
- Status report built automatically
- Spend Friday wrapping up, not reporting
- Historical record of weekly progress
- Easy to spot recurring blockers
Setup
Build it in a few focused steps.
- 1Connect Asana and Airtable to Notis (one-time).
- 2Tell Notis: 'Every Friday at 5 PM, scan my Asana tasks from the past week, identify which ones moved to Done, which are blocked, and which are pending. Create records for each category in my Airtable weekly status table.'
- 3Pick your timezone and notification channel.
- 4Test by running it manually and checking that status records appear in Airtable organized by category.
Questions about this workflow
Can I change the day and time?
Yes. Monday morning, Thursday afternoon, whatever works for your team.
What if I work across multiple Asana projects?
Tell Notis to scan all your projects and create summary records for the whole portfolio.
Can I add custom fields like 'blockers this week'?
Yes. Notis creates records with whatever fields you describe in your instruction.
Does this create new records each week or overwrite old ones?
It creates new records each week, so you build a historical archive of status reports.
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 1,000+ 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.