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 available as an add-on on any paid plan (Business, Pro, or Custom).
Plan Eligibility: Hourly refreshes are available on any paid plan. On Business and Pro plans, hourly refreshes are an optional add-on for $49.95/month; on Custom plans, they are included when your plan agreement covers them. Hourly refreshes are added by our team on request (not a self-serve purchase in the hub), so to get started, contact our sales team or submit a ticket. Hourly refreshes are not available on the Free plan, which uses sample data only.
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. Please contact our support team with any questions about your legacy add-on.
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. 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 on any paid plan (as an add-on on Business and Pro, and included on Custom when your agreement covers it), 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, and FTP)
Note: Hourly refreshes can only be performed for reports that contain at least one live data field. Live fields can be identified in the Schema Explorer by the yellow lightning bolt icon next to the field label.
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
How to Add Hourly Refreshes
Hourly refreshes are available on any paid plan. On Business and Pro plans, they are an optional add-on for $49.95/month; on Custom plans, they are included when your agreement covers them. Because hourly refreshes are enabled by our team rather than self-serve, just contact our sales team or submit a ticket to add them to your plan.
If you need even more from Power My Analytics, the Custom plan may also optionally include the following, depending on the terms of your specific agreement:
- 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
Custom plans are tailored to each customer's needs. Please contact our sales team to discuss your requirements, or learn more in the Custom Plan Guide.
Still Have Questions?
No worries, we're happy to help!