Schedule refreshes

A schedule runs your queries again at the times that you choose, so you do not have to update the data by hand. A schedule can also email the sheet to people after each refresh.

Create a schedule

Choosing the minute of the hour

You set refresh times to the hour, not to the minute. No frequency lets you choose a minute, such as "run at :55 past the hour".

For Hourly schedules, the add-on picks a minute in the hour for you, and does not show it. This is on purpose. If every hourly schedule ran at :00, they would all call the ad platforms at the same moment, and rate limits would stop many of them. Spreading schedules across the hour keeps them reliable.

What this means for you:

• The minute is random, and it changes each time that you edit the schedule. A schedule that ran at :12 can run at :47 after you change its recipients.
• Two hourly schedules in the same sheet usually run at different minutes.
• Daily, Weekly, and Monthly schedules keep the hour that you pick. The minute in that hour is picked in the same way.

Email the sheet (optional)

You can send the sheet by email after each refresh, to your team or your clients:

Smart Refresh

Use Smart Refresh is a query option, under Date in the query form. When it is on, later runs of the query get only the most recent days of data, and merge them with the data already in the sheet. You set how many days in Refresh the last. This makes runs on long date ranges faster, and less likely to fail. The add-on suggests it for queries of more than 30 days.

To use Smart Refresh:

• Your team must have Advanced Scheduler turned on. See Data options.
• The query must include the Date dimension.
• The date range must allow Smart Refresh. If it does not, the checkbox is off, and its tooltip tells you why.
• Append new data and Merge new data with old must be off.

Manage your schedules

Schedule Refresh lists the schedules in this spreadsheet. Each schedule has three buttons:

• The mail button (Report now) runs the schedule now.
• The edit button changes the queries, the frequency, the recipients, or other settings.
• The delete button removes the schedule.

Test your schedule

Before you depend on a schedule:

1. Run your query by hand, and check the data.
2. Set up a test schedule that runs soon.
3. Check that the email arrives.
4. Check the data after the next refreshes.

Time zones

Each schedule has its own time zone, in Your Timezone. You can select Team Timezone to copy your team's time zone into the schedule. A later change to the team's time zone does not move schedules that already exist.

If a schedule does not run at the time that you expect:

• Open the schedule and check Your Timezone.
• Check the time zone of your spreadsheet in Google Sheets.
• If the problem continues, contact support.

Troubleshooting

A refresh ran at an unexpected minute

• This is expected. The add-on picks the minute, and it changes when you edit the schedule. See Choosing the minute of the hour.

A schedule did not run

• Check that your connections still have access to their accounts.
• Check that no connection needs reconnecting.
• Check the frequency in the schedule settings.

An email did not arrive

• Check the recipient email addresses.
• Check spam and junk folders.
• Check that your email settings let outside services send mail.

The data looks wrong

• Run the query by hand, and compare the results.
• Check whether the data in the platform changed recently.
• Check the filters and the date range of the query.

If the problem continues, email [email protected].

Next steps

• Manage your spreadsheets: find and copy the spreadsheets that use the add-on
• Troubleshoot Google Sheets issues: fix common schedule and email problems