Skip to content
Notis

Make the package review queue easier to scan

Apply a filter to the existing review range so the team can narrow its view.

Trigger

Recurring schedule

Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.

Action

Set Basic Filter

Applies a basic filter to a sheet range.

Why this helps

A long review sheet makes it harder to focus on the items that need attention.

  • Apply a basic filter to an existing review range.
  • Make a large queue easier to inspect.
  • Prepare the same review view on a recurring schedule.

Setup

Build it in a few focused steps.

  • 1Connect Google Sheets once in the Notis portal and confirm the review sheet and range exist.
  • 2Create an automation named Package review queue filter.
  • 3Tell Notis which existing range to filter and what review view to prepare.
  • 4Pick the recurring schedule and choose where run reports should go.
  • 5Test on the real review sheet and confirm the filter is useful.

Questions about this workflow

Does this remove rows that do not match?

No. A basic filter changes the sheet view; it does not delete the underlying rows.

Can the filter work if the range is unknown?

The sheet and range must be identified in your instruction so Notis can target the existing review data.

When this happens · Trigger

Do this · Action

Supported Triggers and Actions

Notis builds workflows that link Cloudsmith to Google Sheets. A trigger fires from one place; an action lands in another.

Cloudsmith triggers

Google Sheets actions

Recurring trigger

Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.

TriggerScheduled

Add Sheet to Existing Spreadsheet

Adds a grid sheet with rows and columns to an existing spreadsheet.

ActionInstant

Webhook trigger

Notis starts this workflow when an external tool or custom backend sends an HTTP request.

TriggerInstant

Aggregate Column Data

Find rows matching a column value and calculate results from another column.

ActionInstant

Append Dimension

Adds empty rows or columns to the end of a sheet.

ActionInstant

Batch get spreadsheet

Retrieves data from selected spreadsheet ranges.

ActionInstant

Auto-Resize Rows or Columns

Automatically adjusts row heights or column widths to fit their contents.

ActionInstant

Batch Update Values by Data Filter

Updates spreadsheet values in ranges that match data filters.

ActionInstant

Clear Basic Filter

Removes the basic filter from a sheet.

ActionInstant

Batch update spreadsheet (Deprecated)

ActionInstant

Connect any two apps with Notis in the middle.

Cloudsmith and Google Sheets, 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 Google Sheets.