Supermetrics has an alert feature to notify the right people when data warehouse, data lake, and Supermetrics Storage transfers or scheduled refreshes in Google Sheets or Excel are facing issues that require your attention. In Google Sheets, you can set up conditional alerts that notify you only when certain conditions are met in your report.
The alerts can be sent to an email address or to a Slack or Microsoft Teams channel. You can also have the report itself sent to an email address or to a Slack or Microsoft Teams channel.
Before you begin
To receive notifications in Slack or Microsoft Teams channels, you need to get the email address of the channel.
Get Slack channel email address
- Create or open a Slack channel you want to get the alerts or reports sent to.
- Go to channel details.
- Click Integrations.
- Click Send emails to this channel.
- Copy the email address.
Get Microsoft Teams channel email address
- Create or open a channel for a team in Microsoft Teams. Any privacy option works. To create a channel, click the 3-dot menu next to the team name, and click Add channel.
- In the top-right corner of the channel view, click the 3-dot menu, and select More options → Get email address.
- Copy the email address.
Instructions
This notification works for all data warehouse, data lake, and Supermetrics Storage destinations where the transfers are created from the Supermetrics Hub. For BigQuery (marketplace), the email used when creating the transfer will automatically receive alerts.
Supermetrics data warehouse transfers are designed to automatically recover from most errors. However, some errors can't be automatically recovered and require your attention.
- Log in to the Supermetrics Hub.
- Go to Storage → Transfers.
- Click Create new.
- Select the data source and click OK.
- Fill the Send alerts to field with the email addresses you want to receive notifications.
- You can add multiple emails separated by commas.
- These email addresses don't need to belong to the same Supermetrics team.
- When you're ready, click Save to store the transfer.
Ensure that the email addresses are valid and actively monitored by the respective recipients. Alerts will be sent to the recipients once per 24 hours for all failed transfers that require your attention.
- Open the Supermetrics sidebar in Google Sheets.
- Go to the Schedules tab.
- Click Automatic refresh.
- Select an action from the Action menu, and define the time you want to run the action
- Click Send email alerts if queries fail on refresh.
- Fill the Email report to field with the email addresses you want to receive notifications.
- Click Create refresh.
Take a look at our article for more details about scheduled refreshes and email notifications in Google Sheets.
With the conditional alert, you can select a cell or a cell range, and get an alert when the condition is met. The available conditions are:
- Equals
- Does not equal
- Greater than
- Less than
- Is empty
- Is not empty
Note
Use the Email alerts option to set up alerts for Microsoft Teams.
- Open the Supermetrics sidebar in Google Sheets.
- Go to the Schedules tab.
- Click Email alerts or Slack alerts.
- Set the conditions for the alert.
- Fill the Email reports to field with the email addresses you want to receive notifications. To receive notifications to multiple email addresses, click Advanced settings, click CC, and add the email addresses to the CC field.
- Click Create alert.
- Open the Supermetrics sidebar.
- Navigate to the Schedule tab.
- Click Add trigger.
- Select an action from the Action dropdown menu.
- Fill the Email alerts to field with the email addresses you want to receive notifications.
- Click Save changes.
Take a look at our article for more details about scheduled refreshes and email notifications in Excel.
- Open the Supermetrics sidebar.
- Navigate to the Schedule tab.
- Click Add trigger.
- Select a Refresh & email option from the Action menu, and define the time you want to run the action.
- Fill the Email reports to field with the email addresses you want to receive notifications. To receive notifications to multiple email addresses, click More options, and add the email addresses to the CC field.
- Click Save changes.