Check whether a package is already on your list
Quickly look for an exact match in the sheet your team already uses.
Trigger
Webhook received
Notis starts this workflow when an external tool or custom backend sends an HTTP request.
Action
Look up spreadsheet row
Finds the first row containing an exact match for a value.
Why this helps
Repeated package notices can lead to duplicate entries and extra review work.
- Check an incoming package value against an existing list.
- Cut down on avoidable duplicate review entries.
- Use the lookup result to guide a follow-up step.
Setup
Build it in a few focused steps.
- 1Connect Google Sheets once in the Notis portal and confirm the package list exists.
- 2Create an automation named Known package check.
- 3Tell Notis to look up the exact package value from each incoming notice in the existing sheet.
- 4Choose the webhook trigger and where run reports should go.
- 5Test with one listed package and one unlisted package.
Questions about this workflow
Does this automatically prevent a duplicate row?
The selected action looks up the first exact match. It does not itself append or block a row; instruct Notis how to report the result or pair it with a supported update action.
What counts as a match?
The action searches for a cell whose entire content exactly matches the query string.
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.
Add Sheet to Existing Spreadsheet
Adds a grid sheet with rows and columns to an existing spreadsheet.
Webhook trigger
Notis starts this workflow when an external tool or custom backend sends an HTTP request.
Aggregate Column Data
Find rows matching a column value and calculate results from another column.
Append Dimension
Adds empty rows or columns to the end of a sheet.
Batch get spreadsheet
Retrieves data from selected spreadsheet ranges.
Auto-Resize Rows or Columns
Automatically adjusts row heights or column widths to fit their contents.
Batch Update Values by Data Filter
Updates spreadsheet values in ranges that match data filters.
Clear Basic Filter
Removes the basic filter from a sheet.
Batch update spreadsheet (Deprecated)
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.