Advanced Scheduler lost access to your Google account
Problem
You see an error message like:
Advanced Scheduler lost access to your Google account. Re-authorize in My Account → Team Preferences to continue.
This can appear when you run a query or when a scheduled refresh runs. Advanced Scheduler needs ongoing access to your Google account to refresh Google Sheets and send schedule-related email.
Why this happens
Advanced Scheduler stops working when Google access is no longer valid. Common causes include:
- Permissions removed: you or an admin removed the access of Two Minute Reports in your Google account settings
- Password or security change: a Google password change or a security event cancelled the access
- Missing permissions: you did not grant the Google Sheets or Gmail permissions during authorization
- Wrong Google account: you signed in with a different Google account from the one that created the schedules
Solution: authorize again from the Hub
Open Authorized access
In the Hub, open Settings › Authorized access.
Reconnect Advanced Scheduler
Under Google, find Read and write your spreadsheets, and send email as you. Its row says Used by Advanced Scheduler. Select Reconnect (or Reauthorize). Grant both the Google Sheets and the Gmail access when Google asks.
Send email as you, used by briefings, is a separate permission on the same screen. Reconnecting one does not change the other, so if briefings were working, they keep working.
Or authorize again from the Google Sheets add-on
Either route fixes the same thing. Use this one if you are already in the spreadsheet.
Open My Account
At the bottom of the Two Minute Reports sidebar, open your profile. Select My Account.
Open Team Preferences
In My account, select the Team Preferences tab.
Authorize Advanced Scheduler again
In the Advanced Scheduler section:
- If the access was removed or permissions are missing, follow the steps to connect Google Sheets and Gmail again.
- Grant all the permissions when Google asks you to authorize Two Minute Reports.
When authorization succeeds, you see You're all set. and Advanced Scheduler is authorized, with both Google Sheets and Gmail connected.
Check the fix
- Return to your query and run it, or open Schedule Refresh and select Report now on the schedule.
- Check that the error does not appear.
- Check that the next scheduled refresh succeeds.
Still having issues?
If you authorized again and still see the error:
- Check that you used the same Google account that created the schedules.
- In Google Account › Security › Third-party apps, remove Two Minute Reports, then authorize again. This removes all Two Minute Reports access at once, so you must also reconnect briefings.
- A schedule runs with the Google account of the person who created it. If someone else created the schedule, ask them to authorize again.
Contact [email protected] with a screenshot of the error and your team name if the problem continues.