Supermetrics has an alert feature to notify the right people when data warehouse transfers or scheduled refreshes in Google Sheets or Excel are facing issues that require your attention. The alerts can be sent to a normal email address, Slack channel, or Microsoft Teams channel.
You can also get the report itself sent to a normal email address, Slack channel, 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 destinations except for Google BigQuery (marketplace). 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.
- In the left-side menu, under Export, go to Data warehousing → 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.
- Click the Schedule tab at the top of the sidebar.
- Click Add trigger.
- 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 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 Google Sheets.
- Open the Supermetrics sidebar in Google Sheets.
- Click the Schedule tab at the top of the sidebar.
- 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 Advanced settings, and add the email addresses to the CC field.
- Click Save changes.
- 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.