How to Use Hourly Refreshes
Power My Analytics can perform scheduled data refreshes for Google Sheets reports and data exports on a monthly, weekly, daily, or hourly basis. Hourly refreshes are included with the Custom plan for subscribers who require the most up-to-date data in their reports.
Legacy plan subscribers: If you subscribed to a Hourly Refreshes add-on prior to 2026 under a legacy plan, your existing hourly refresh configurations will continue to function. However, new hourly refresh schedules cannot be added to legacy plans that are not Custom. Please contact our support team with any questions about your legacy add-on.
What Are Hourly Refreshes?
Power My Analytics' Google Sheets reports and data exports can be configured to refresh on a scheduled basis — monthly, weekly, daily, or hourly. Hourly refreshes are available to Custom plan subscribers, ensuring that reports always reflect the most current data available from your connected sources.
Hourly refreshes can be configured for the following destinations:
- Google Sheets reports
- Data exports (BigQuery, MySQL, Azure SQL Database, PostgreSQL, Amazon S3, FTP)
Schedule Your Hourly Refresh
To configure an hourly refresh for your Google Sheets report or data export, choose your destination from the list below and follow the instructions in the linked article. When selecting a refresh schedule during setup, choose Hourly as your refresh frequency.
Google Sheets
Data Exports
- How to Export to BigQuery
- How to Export to MySQL
- How to Export to Azure SQL Database
- How to Export to PostgreSQL
- How to Export to Amazon S3
- How to Create an FTP Export
Not on the Custom Plan?
Hourly refreshes are exclusively available to Custom plan subscribers. If you're on a Free, Business, or Pro plan and need access to more frequent data updates, upgrading to the Custom plan is the best path forward. In addition to hourly refreshes, the Custom plan also includes:
- Data exports to BigQuery, SQL databases, Amazon S3, FTP, and more
- Sovereign data warehousing options
- Access to the Power My Analytics API
- A dedicated account representative and end-to-end onboarding
- SLAs, NDAs, and custom contracts
Learn more about what's included in the Custom Plan Guide, or reach out to our sales team to discuss your needs.
Still Have Questions?
No worries — we're happy to help!
Related Articles
How to Use Data Exports
Power My Analytics offers the option to export data from your reports into destinations like BigQuery, MySQL, Azure SQL Database, PostgreSQL, Amazon S3, and FTP. Data exports are included with the Custom plan. This article will show you how to set up ...How to Use Sample Data
Sample Data allows you to showcase templates and reports to potential clients without sharing sensitive information. Read this article to learn how to use Sample Data in Looker Studio. Can I Use Sample Data? Currently, Sample Data is only available ...How to Use Schema Explorer
The PMA Schema Explorer is an easy way to find metrics and dimensions that are available for your connectors and identify any possible conflicts or errors. Schema Explorer can find additional fields that are compatible with your selected fields and ...Add and Remove Accounts from Data Sources
Within a connected data source, accounts are subsets of data within data sources that can be selected individually to sync with PMA's data warehouse and use in reports. Accounts correspond to divisions within the data connector's platform, such as ...Google Sheets Error: "Exception: This add-on has created too many time-based triggers in this document for this Google user account"
When using the Power My Analytics spreadsheets add-on in Google Sheets, you may encounter an error about too many time-based triggers. This guide explains the cause of this error and provides a simple solution to resolve it. Error "Exception: This ...