See review activity by category each week
Use a weekly pivot run to compare the categories you already track in Metabase, without manually repeating the same analysis.
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
Comparing category-level activity can turn into a multi-step task that gets postponed when the week is busy.
- Runs a saved pivot query on a regular schedule.
- Makes category comparisons easier to revisit.
- Reduces repeated setup for recurring analysis.
Setup
Build it in a few focused steps.
- 1Connect Trustpilot and Metabase to Notis once in the portal.
- 2Create an automation or ask Notis to run your Metabase review-category card as a pivot each week.
- 3Choose a weekly schedule and reporting channel.
- 4Test one real run and verify the pivot includes the categories you expect.
Questions about this workflow
What does the pivot action return?
It executes the selected Metabase card query and returns results formatted for pivot-table visualization.
Can it discover categories automatically?
The action runs an existing card. The question and its underlying data should already define the categories you want to compare.
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.