Bring the package report data together for review
Have the ranges your team cares about ready when the monthly review starts.
Trigger
Recurring schedule
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Action
Batch get spreadsheet
Retrieves data from selected spreadsheet ranges.
Why this helps
Preparing a recurring review by finding and copying ranges takes time away from decisions.
- Retrieve selected ranges together for a review.
- Reduce manual spreadsheet browsing.
- Keep review preparation consistent.
Setup
Build it in a few focused steps.
- 1Connect Google Sheets once in the Notis portal and confirm the relevant sheet ranges exist.
- 2Create an automation named Monthly package report review.
- 3Tell Notis which existing ranges to retrieve and how to summarize them for review.
- 4Pick the monthly schedule and choose where run reports should go.
- 5Test with the actual ranges and confirm the returned values are useful.
Questions about this workflow
Can this retrieve ranges that do not exist?
The spreadsheet must contain at least one worksheet, and any explicitly named worksheet in a range must exist.
Does this write a new report?
This action retrieves data. To write results into a sheet, use a suitable write action and specify the destination.
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.