---
title: "How to set up scheduled report triggers in Excel"
slug: "how-to-set-up-scheduled-report-triggers-in-excel"
description: "Automate your report updates in Supermetrics with scheduled refreshes, email alerts for failures, and customizable triggers for seamless data management."
updated: 2026-03-31T06:23:17Z
published: 2026-03-31T06:23:17Z
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.supermetrics.com/llms.txt
> Use this file to discover all available pages before exploring further.

# How to set up scheduled report triggers in Excel

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**. Your subscription determines how frequently you can set the triggers to update your reports — weekly, daily, or hourly.

You can also have Supermetrics send you [a notification email](/v1/docs/how-to-set-up-scheduled-report-triggers-in-excel#enable-failure-notifications) if any of your scheduled refreshes fail to complete.

## Before you begin

Before you begin, make sure you’ve [installed Supermetrics](/v1/docs/how-to-install-the-supermetrics-excel-add-in) 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](/v1/docs/how-to-fix-excel-scheduled-report-triggers-that-wont-save-to-onedrive).

> [!NOTE]
> 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

1. Open the Supermetrics sidebar.
2. Navigate to the **Schedule** tab.
3. Click **Add trigger**.
4. Choose actions for your trigger from the **Action** dropdown menu.
5. Fill out your email preferences.
6. Click **Save**.

[Follow these instructions to check your OneDrive permissions if your triggers won't save to OneDrive](/v1/docs/how-to-fix-excel-scheduled-report-triggers-that-wont-save-to-onedrive).

The video below shows you how to set up triggers.

[Embedded content](https://www.youtube.com/embed/cFxoFY32-j8?&wmode=opaque)

### Change email preferences

You can change the sender name, target email address, and reply-to address of your scheduled emails.

1. Open the Supermetrics sidebar.
2. Navigate to the **Schedule** tab.
3. Select a trigger to edit or add a new trigger.
4. Scroll down to Email, and click **More options**.
5. 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

1. Open the Supermetrics sidebar in Excel.
2. Open the **Schedule** tab.
3. Click **Add trigger** to create a new scheduled refresh, or click **Edit** under any existing trigger to make changes to it.
4. Check the box next to **Send email alerts if queries fail on refresh**.
5. 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.