Manually refreshing your reports every morning is a chore no marketer should have to endure. Nothing is worse than making a decision based on stale data. But what if your Google Sheets reports updated themselves automatically while you're away? With Supermetrics, they can! Automated scheduled refreshes are your ticket to always-on, up-to-date marketing reports, ensuring you never miss a beat.

How to set up a scheduled refresh

Creating a scheduled refresh for your Supermetrics queries in Google Sheets is straightforward.

• Open the Supermetrics sidebar: In your Google Sheet, open the Supermetrics add-on and navigate to the Schedules tab.

• Create a new schedule: Click on Automatic refresh. You will be able to set the frequency for your reports. Depending on your subscription, you can choose a daily, weekly, or even hourly refresh schedule.

• Manage your schedules: Once created, you can manage all your scheduled refreshes in one place. Simply go to the Schedules tab and click View all schedules in all spreadsheets. This gives you a clear overview of all your reports, their refresh status, and allows you to make any necessary changes.

Learn more: Get the full rundown on creating and managing schedules with our official guide: How to create and manage scheduled refreshes in Google Sheets.

Introducing enhanced scheduled refreshes (public beta)

While standard scheduled refreshes are great, we’ve taken the feature to the next level. We've built an enhanced scheduled refresh system that runs on Supermetrics’ own infrastructure, making your automated reports more reliable than ever before. This new system offers:

• Increased reliability: Say goodbye to refresh failures caused by Google Apps Script limitations.

• More runtime: Queries that used to time out on large data sets can now run for longer, ensuring you get all the data you need.

• Better retry logic: If a refresh fails for a temporary reason, our system will automatically try again.

How to enable this upgrade

Enabling enhanced scheduled refreshes is quick and easy for all paid subscribers.

1. Open the Supermetrics sidebar: In your Google Sheet, go to the Schedules tab.

2. Enable the feature: Scroll down and click on Enable enhanced scheduled refreshes. You'll be prompted to log in with your Supermetrics Google Account.

3. Enjoy the benefits: Once enabled, this upgrade will automatically apply to all of your existing and future scheduled refreshes in Google Sheets!

Learn more: Find detailed instructions on how to activate this feature in our guide: How to enable enhanced scheduled refreshes in Google Sheets (public beta).

Always-on insights, effortless reporting

Automated scheduled refreshes in Supermetrics are a must-have for any data-driven marketer. By automating the update process, you can free up valuable time and ensure that your reports are always powered by the freshest data. Upgrade to enhanced scheduled refreshes for even greater reliability, and transform your reporting workflow today!