Create Bidsketch fees from changing sales metrics
When your pricing signal changes, prepare the fee you need next.
Trigger
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.
Action
Create Fee
Tool to create a fee. use when you need to add a reusable fee to the account before adding it to a proposal. ensure required fields are set (e.g., unit for custom fees).
Why this helps
Pricing updates require someone to notice a spreadsheet change and rebuild the same fee manually.
- React to measurable changes
- Prepare consistent pricing components
- Reduce spreadsheet monitoring
Setup
Build it in a few focused steps.
- 1Connect Google Super and Bidsketch in Notis.
- 2Create an automation that interprets a changed aggregate metric and creates a reusable Bidsketch fee when the defined pricing condition is met.
- 3Pick Aggregate Metric Changed as the trigger.
- 4Choose a report channel.
- 5Test with one representative metric change.
Questions about this workflow
Can the metric be filtered?
The trigger supports an optional search column and value, so you can monitor a focused subset.
What if the fee already exists?
Ask Notis to check existing fees first and report a possible duplicate instead of creating another one.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link Google Super to Bidsketch. A trigger fires from one place; an action lands in another.
Google Super triggers
Bidsketch actions
Recurring trigger
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Create Client
Tool to create a client. use when adding a new client record to bidsketch.
Webhook trigger
Notis starts this workflow when an external tool or custom backend sends an HTTP request.
Delete Client
Tool to delete a client and all their proposals. use when you want to permanently remove a client and its associated proposals from your account.
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.
Delete Fee
Tool to delete a fee. use when a saved fee is no longer needed. use after confirming this fee isn't referenced in any live proposals.
Attendee Response Changed
Polling trigger that fires when any attendee's RSVP changes to accepted, declined, or tentative. Returns attendee info and current status.
Delete Proposal
Tool to delete a proposal and all its content. use after confirming the proposal id to prevent accidental deletions.
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 Proposal Fee
Tool to delete a proposal fee. use when you need to remove an existing fee before finalizing or sending a proposal.
Comment Added (Docs/Sheets/Slides)
Triggers when a new comment is added to Google Docs, Sheets, or Slides.
Delete Proposal Section
Tool to delete a proposal section. use when you need to remove a section from a proposal after verifying its id.
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 Section
Tool to delete a section. use when you need to permanently remove a saved section after confirming its id.
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 Webhook
Tool to delete a webhook. use after obtaining the webhook id to remove it.
Connect any two apps with Notis in the middle.
Google Super and Bidsketch, 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 Bidsketch.