Auto-Update Progress Charts as Tasks Move Through Workflow
Progress charts in Sheets go stale fast when you're updating them manually. Notis automatically refreshes your chart every time a task moves—visual workflow health always current.
Trigger
Task Moved to Section
Triggers when a task is moved to a section in a project.
Action
Create Chart in Google Sheets
Create a chart in a google sheets spreadsheet using the specified data range and chart type.
Why this helps
Founders can't keep progress charts updated alongside daily work. A chart that lags behind reality erodes stakeholder confidence. Manual chart maintenance is procrastinated.
- Progress chart updates automatically as tasks move
- Visual representation of workflow health is always current
- No manual chart maintenance—Notis handles it
- Better stakeholder confidence with live progress data
Setup
Build it in a few focused steps.
- 1Connect Asana and Google Sheets to Notis.
- 2Create a new automation: 'When a task moves to a new section in Asana, update my progress chart in Sheets to reflect the current count of tasks in each section.'
- 3Specify the Asana project and tell Notis which Sheets sheet holds your progress chart.
- 4Tell Notis the chart type you prefer (bar chart showing task count per section, or pie chart showing status distribution).
- 5Select 'Task Moved to Section' as the trigger.
- 6Pick a notification channel.
- 7Test by moving tasks between sections in Asana—your chart should update within seconds.
Questions about this workflow
What if I don't already have a chart—can Notis create one?
Yes. If no chart exists, Notis can create one using your current task data. Tell it the chart type and data to visualize.
Can I have multiple charts (one per metric)?
Absolutely. Set up multiple automations—one to update a task-count chart, another to update a priority-distribution chart, etc.
Does the chart include closed/completed tasks?
Tell Notis whether to include or exclude completed tasks. Most teams exclude them from current status charts.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link Asana to Google Sheets. A trigger fires from one place; an action lands in another.
Asana triggers
Google Sheets actions
Attachment Added to Task
Triggers when an attachment is added to a task.
Add Sheet to Spreadsheet
Adds a new sheet (worksheet) to a spreadsheet. use this tool to create a new tab within an existing google sheet, optionally specifying its title, index, size, and other properties.
New Comment on Task
Triggers when a comment is added to a task in a project.
Aggregate Column Data
Searches for rows where a specific column matches a value and performs mathematical operations on data from another column.
New Task Created
Triggers when a new task is created in a project.
Append Dimension
Tool to append new rows or columns to a sheet, increasing its size. use when you need to add empty rows or columns to an existing sheet.
Task Moved to Section
Triggers when a task is moved to a section in a project.
Batch get spreadsheet
Retrieves data from specified cell ranges in a google spreadsheet; ensure the spreadsheet has at least one worksheet and any explicitly referenced sheet names in ranges exist.
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.
Batch update spreadsheet
Updates a specified range in a google sheet with given values, or appends them as new rows if `first cell location` is omitted; ensure the target sheet exists and the spreadsheet contains at least one worksheet.
Task Updated
Triggers when a task is updated in a project.
Batch Update Values by Data Filter
Tool to update values in ranges matching data filters. use when you need to update specific data in a google sheet based on criteria rather than fixed cell ranges.
Clear Basic Filter
Tool to clear the basic filter from a sheet. use when you need to remove an existing basic filter from a specific sheet within a google spreadsheet.
Clear spreadsheet values
Clears cell content (preserving formatting and notes) from a specified a1 notation range in a google spreadsheet; the range must correspond to an existing sheet and cells.
Connect any two apps with Notis in the middle.
Not just Asana and Google Sheets. 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 Google Sheets.