Bring the right Sheets data into a course review
Request the ranges your team needs and let Notis retrieve their current values for analysis alongside course reporting.
Trigger
Webhook received
Notis starts this workflow when an external tool or custom backend sends an HTTP request.
Action
Batch get spreadsheet
Retrieves data from selected spreadsheet ranges.
Why this helps
Course review slows down when the relevant spreadsheet ranges have to be found and pulled into context by hand.
- Retrieve only the ranges needed for a review.
- Reduce tab and range hunting before analyzing course data.
- Give Notis current sheet values to examine alongside retrieved course reports.
Setup
Build it in a few focused steps.
- 1Connect Coassemble and Google Sheets in the Notis portal.
- 2Create an automation and describe which Coassemble report to retrieve and which existing Sheets ranges Notis should read for the review.
- 3Pick the webhook trigger and choose where run reports should go.
- 4Send one real review request and check that the returned range covers the needed data.
Questions about this workflow
Does this action write to the spreadsheet?
No. It retrieves values from specified ranges. Use a separate action if the workflow should write or append data.
Can Notis compare a report with a baseline?
Yes, if the baseline is present in the ranges you ask it to retrieve. The workflow cannot infer a missing historical baseline.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link Coassemble to Google Sheets. A trigger fires from one place; an action lands in another.
Coassemble 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.
Coassemble 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.