Find the right Booqable product group for each new request
Give new equipment requests a quick catalog review by retrieving relevant Booqable product groups.
Trigger
New Rows in Google Sheet
Simple polling trigger that monitors Google Sheets for new rows. Detects when new rows are added and returns the complete row data. Perfect for triggering any workflow based on new sheet entries.
Action
Get Product Groups
Tool to retrieve a list of product groups. use when you need to browse product catalog by pages.
Why this helps
Finding the right product group for a request can involve switching apps and paging through the catalog.
- Start catalog browsing from a new equipment request.
- Get relevant product group results in a run report.
- Reduce time spent paging through the catalog manually.
Setup
Build it in a few focused steps.
- 1Connect Google Sheets and Booqable once in the Notis portal.
- 2Create an automation in Automations, New Automation, and give it a clear name.
- 3Tell Notis to use the equipment category in a new row to retrieve and summarize relevant Booqable product groups.
- 4Choose New Rows in Google Sheet as the trigger and select where run reports should go.
- 5Test with one real equipment request and review the report.
Questions about this workflow
Does this create a product group?
No. It retrieves product groups for review. Creating a group requires a separate action and defined name and pricing details.
What if the request has no category?
Ask Notis to flag the missing category in the report so you can provide enough detail for a useful lookup.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link Google Sheets to Booqable. A trigger fires from one place; an action lands in another.
Google Sheets triggers
Booqable actions
Recurring trigger
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Create Customer
Tool to create a new customer. use when onboarding a new client and you have verified their details. example: create 'jane doe' with email jane@doe.com.
Webhook trigger
Notis starts this workflow when an external tool or custom backend sends an HTTP request.
Create Order
Tool to create a new order. use after collecting valid customer id and timing details. example: create an order for customer '297f2584-...' starting at '2018-01-01t09:00:00z'.
Aggregate Metric Changed
Triggers when an aggregate metric (SUM/COUNT/AVG/MIN/MAX) changes in a Google Sheets spreadsheet. This trigger monitors an aggregate calculation on a target column (optionally filtered by a search column/value) and fires when the calculated result changes.
Create Product Group
Tool to create a new product group in booqable. use when you have defined the group's name and pricing details and want to organize items under a shared group.
Cell Range Values Changed
Triggers when values in a specified A1 range change in Google Sheets. This trigger monitors a specific cell or range of cells and fires when any values change.
Delete Customer
Tool to delete (archive) a customer by id. use after confirming the customer should be hidden from searches.
Conditional Format Rule Changed
Triggers when conditional formatting rules change in a Google Spreadsheet. Detects when rules are added, updated, or removed. Uses snapshot-based diffing to detect changes between polls.
Delete Order
Tool to delete (archive) an order by id. use when you need to hide completed or canceled orders from active listings.
Data Validation Rule Changed
Triggers when data validation rules change (added/updated/removed) in a Google Spreadsheet. Uses snapshot-based diffing to detect changes between polls.
Delete Product Group
Tool to delete a product group by id. use when you need to permanently remove a product group from your catalog after confirming its identifier.
Developer Metadata Changed
Triggers when developer metadata entries change (new/updated/removed) in a Google Spreadsheet. Uses snapshot-based diffing to detect changes between polls.
Get Customer
Tool to fetch a specific customer by id. use after obtaining a customer identifier to retrieve full customer details.
Filtered Range Values Changed
Polling trigger that monitors Google Sheets filtered ranges for value changes. Uses snapshot-based diffing to detect when values matching a data filter change. Emits the matched values when changes are detected.
Get Customers
Tool to retrieve a list of customers. use when you need to paginate through customers.
Connect any two apps with Notis in the middle.
Google Sheets and Booqable, 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 Booqable.