Recheck your review rating mix with less effort
A scheduled pivot run makes it easier to revisit the rating distribution already modeled in Metabase and see how the mix is moving.
Trigger
Recurring schedule
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Action
Run Card Pivot Query
Tool to run a pivot table query on a Metabase card (question). Use when you need to execute the query associated with a specific card and get results formatted for pivot table visualization. The response includes data rows, column metadata, query status, and execution timing.
Why this helps
A rating mix is useful over time, but recurring comparisons can slip when every review requires opening and configuring analytics manually.
- Uses a recurring pivot for an established rating analysis.
- Makes rating groups easier to compare across checks.
- Removes repeated manual query execution.
Setup
Build it in a few focused steps.
- 1Connect Trustpilot and Metabase to Notis once in the portal.
- 2Ask Notis to run your rating-distribution card as a pivot every week.
- 3Choose a weekly schedule and a channel for run reports.
- 4Test with one real run and check the returned rating groups.
Questions about this workflow
Does this create rating categories?
No. The selected Metabase card needs to define the rating distribution before the pivot runs.
Can I run it monthly instead?
Yes. Choose a monthly Notis schedule if that better suits your review cadence.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link Trustpilot to Metabase. A trigger fires from one place; an action lands in another.
Trustpilot triggers
Metabase actions
Recurring trigger
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Create Bookmark
Tool to create a new bookmark for a Metabase item (card, dashboard, collection, or dataset). Use when the user wants to bookmark a specific item for quick access.
Webhook trigger
Notis starts this workflow when an external tool or custom backend sends an HTTP request.
Create Bookmark
Tool to create a new bookmark for a Metabase item (card, dashboard, collection, or dataset). Use when you need to bookmark a specific item for the authenticated user.
Run Card Pivot Query
Tool to run a pivot table query on a Metabase card (question). Use when you need to execute the query associated with a specific card and get results formatted for pivot table visualization. The response includes data rows, column metadata, query status, and execution timing.
Run Card Query
Tool to run the query associated with a Card and return its results. Use when you need to execute a card's query with optional parameters and cache control.
Copy Dashboard
Tool to create a copy of an existing Metabase dashboard. Use when you need to duplicate a dashboard with optional customization of name, description, and collection placement. Supports both shallow copy (references same cards) and deep copy (duplicates all cards).
Run Dashboard Pivot DashCard Query
Tool to run a pivot table query for a specific DashCard. Use when you need to execute a pivot table query on a dashboard card with optional parameter filters.
Save Dashboard to Collection
Tool to save a denormalized dashboard description into a collection. Use when you need to create a new dashboard directly in a specific collection with full configuration including cards, tabs, and parameters.
Discard Database Field Values
Tool to discard all saved field values for a specific database. Use when you need to clear cached field value data for all fields in a database. Requires superuser privileges.
Connect any two apps with Notis in the middle.
Trustpilot and Metabase, 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 Metabase.