Scheduling queries

Schedule queries to refresh on a schedule that works for your team


Workspaces will migrate to a new and improved query experience, starting the week of May 15, 2024. For more, see this help doc.

With query scheduling, you can set queries to refresh on an hourly, daily, or weekly basis. When the scheduled query runs, it will refresh the associated data and update all formulas in your workbook that depend on that data.

To schedule a query:

  1. Open the Connections panel from the top right corner of your workbook.
  2. Navigate to the specific query you'd like to schedule.
  3. Click Schedule below the Run Query button at the bottom of your query builder or SQL editor.
  4. Select whether to run your query on an hourly, daily, or weekly basis. For daily or weekly query runs, select a specific time or day on which to refresh your query.

You can also schedule all queries in a given workbook to update simultaneously. To do so:

  1. Go to the All Connections tab of the connections panel.
  2. Select the Schedule button beneath your connected datasources.
  3. Schedule your queries to run on an hourly, daily, or weekly basis.

Query notifications

You can enable or disable email notifications for query runs by clicking on the πŸ”” icon revealed after scheduling a query. This must be done on a sheet-by-sheet basis.