Scheduled report updates in Supermetrics automatically refresh your queries and send updated reports via email. Each refresh happens on a schedule that you define using report triggers.
You can also have Supermetrics send you a notification email if any of your scheduled refreshes fail to complete.
Before you begin
Before you begin, make sure you’ve installed Supermetrics and added the data sources you need to Excel.
You should also confirm that the file you want to add triggers to is saved to a OneDrive, OneDrive for Business, or SharePoint drive location.
About copying Excel files with triggers
If you make copies of an Excel file with report triggers set up, the triggers may stop working. Make sure to remove triggers from the copied files and keep the triggers only in the original file.
Instructions
- Open the Supermetrics sidebar.
- Navigate to the Schedule tab.
- Click Add trigger.
- Choose actions for your trigger from the Action dropdown menu.
- Fill out your email preferences.
- Click Save.
Follow these instructions to check your OneDrive permissions if your triggers won't save to OneDrive.
The video below shows you how to set up triggers.
Change email preferences
You can change the sender name, target email address, and reply-to address of your scheduled emails.
- Open the Supermetrics sidebar.
- Navigate to the Schedule tab.
- Select a trigger to edit or add a new trigger.
- Scroll down to Email, and click More options.
- Update the email details, and click Save.
Enable failure notifications
You can add a failure notification to any trigger in Excel. This means that any email addresses you choose will receive an email notification if your scheduled refreshes fail to complete.
You can enable these notifications on any trigger at any time.
Instructions
- Open the Supermetrics sidebar in Excel.
- Open the Schedule tab.
- Click Add trigger to create a new scheduled refresh, or click Edit under any existing trigger to make changes to it.
- Check the box next to Send email alerts if queries fail on refresh.
- Add the email address you’d like to receive the notification, and click Save.
Stop email notifications
To modify or delete a trigger, go to the Schedule tab and select a trigger. Modify the trigger or click Remove in the bottom-right corner to remove the trigger.
If you get email notifications for triggers for a file you no longer have access to, click the Unsubscribe link in the refresh email.