Find the structured data in your tracking spreadsheet
See which tables are available before a report or review begins.
Trigger
Recurring schedule
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Action
List Tables in Spreadsheet
Lists the tables detected in a spreadsheet.
Why this helps
Spreadsheet layouts evolve, making it difficult to know which structured data can be queried.
- Discover tables based on spreadsheet structure.
- Make the available data easier to inspect.
- Prepare for a follow-up query or report.
Setup
Build it in a few focused steps.
- 1Connect Google Sheets once in the Notis portal and identify the tracking spreadsheet.
- 2Create an automation named Package table discovery.
- 3Tell Notis to list the tables in the chosen spreadsheet and summarize the result.
- 4Pick the recurring schedule and choose where run reports should go.
- 5Test with the real spreadsheet and review the detected tables.
Questions about this workflow
Does this query the table contents?
No. It lists tables detected from the spreadsheet structure. Use a separate query action to retrieve table records.
Are detected tables guaranteed to match a formal table definition?
The action uses heuristics to detect headers, data boundaries, and table structure, so review the results.
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.