Keep a Review Area Ready for the Next Pass
When an issue reaches your chosen completion point, have Notis clear the designated review range in Excel.
Trigger
Issue Updated Trigger
Triggered when an issue is updated. For example labels are changed, issue status is changed, etc.
Action
Clear Range
Tool to clear values, formats, or contents in a specified worksheet range. use when you need to reset cells before adding new data.
Why this helps
Stale entries in a working area can make a new review harder to start and create uncertainty about what's current.
- Keep a designated working area uncluttered.
- Reduce manual cleanup after finishing work.
- Make the next review feel easier to begin.
Setup
Build it in a few focused steps.
- 1Connect Linear and Excel to Notis once through the portal.
- 2Create an automation in the portal or ask Notis to reset a specified Excel review area.
- 3Write one instruction stating which issue update should prompt a range clear and which range is intended.
- 4Pick the Linear Issue Updated trigger and choose a channel for run reports.
- 5Test with one real example and verify only the intended range is cleared.
Questions about this workflow
Can this clear only a specific range?
Describe the workbook and intended worksheet range in the instruction and verify it with a safe test area.
When should the range be cleared?
State the relevant completion condition plainly in your instruction and test with a matching issue update.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link Linear to Excel. A trigger fires from one place; an action lands in another.
Linear triggers
Excel actions
Recurring trigger
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Add Chart
Add a chart to a worksheet using microsoft graph api.
Webhook trigger
Notis starts this workflow when an external tool or custom backend sends an HTTP request.
Add SharePoint Worksheet
Add a new worksheet to a sharepoint excel workbook using microsoft graph sites api.
Comment Received Trigger
Triggered when a comment is received.
Add Table
Create a table in a workbook using microsoft graph api.
Issue Created Trigger
Triggered when a new issue is created.
Add Table Column
Add a column to a table using microsoft graph api.
Issue Updated Trigger
Triggered when an issue is updated. For example labels are changed, issue status is changed, etc.
Add Table Row
Add a row to a table using microsoft graph api.
Private Team Comment Created
Fires when a new comment is posted on an issue in a private Linear team (polled with the connected user's token).
Add Workbook Permission
Tool to grant access to a workbook via invite. use when you need to share a specific workbook file with designated recipients and roles.
Private Team Issue Created
Fires when a new issue appears in a private Linear team (polled with the connected user's token).
Add Worksheet
Add a new worksheet to an excel workbook using microsoft graph api.
Private Team Issue Properties Updated
Fires when properties on an issue change in a private Linear team (polled with the connected user's token).
Apply Table Filter
Apply a filter to a table column using microsoft graph api.
Connect any two apps with Notis in the middle.
Linear and Excel, or any other combination from 1,000+ integrations.
When this happens · Trigger
Do this · Action
Save your first hour today.
7-day trial of any paid plan, with 20$ of usage included.
No card. Works with personal or business Excel.