Skip to content
Notis

Find the right review sheet when it is time to check in

Search for the team spreadsheet by a clear name or content query on schedule.

Trigger

Recurring schedule

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

Action

Search Spreadsheets

Searches spreadsheets by their details or contents.

Why this helps

Time gets wasted hunting for the right package review spreadsheet before a check-in.

  • Locate a review spreadsheet on a recurring schedule.
  • Reduce time spent searching Drive manually.
  • Keep a consistent starting point for package reviews.

Setup

Build it in a few focused steps.

  • 1Connect Google Sheets and Drive access once in the Notis portal.
  • 2Create an automation named Package review sheet finder.
  • 3Tell Notis what spreadsheet name or content to search for and how to summarize matches.
  • 4Pick the recurring schedule and choose where run reports should go.
  • 5Test with a search query that should find a known spreadsheet.

Questions about this workflow

Does this search Cloudsmith repositories?

No. This action searches for Google spreadsheets in Drive.

Will it guarantee one exact result?

Search results depend on the filters and available files. Review the returned matches to choose the right spreadsheet.

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.