If exports to Google Sheets or BigQuery fail with a reconnect error, or your Google integration shows Needs Reconnect, Google has stopped accepting the saved sign-in for that account. This is usually not a Sheets or BigQuery setup problem in SyncRange.
SyncRange keeps a secure connection to your Google account so scheduled exports can run without you signing in each time. Google can invalidate that connection and require you to sign in again. When that happens, SyncRange marks the account as needing reconnect and exports to Google Sheets or BigQuery will fail until you reconnect.
Reconnecting in SyncRange fixes the issue until Google asks again. Some organizations see this regularly because of Google Workspace security policies, not because of a misconfigured export or destination.
See Connecting Your Google Account if you need step-by-step connection instructions.
Workspace admins can enforce session length and reauthentication for apps that use Google Cloud scopes (including BigQuery). When that interval expires — often every 24 hours — Google invalidates the OAuth connection SyncRange uses for automated exports. There is nothing SyncRange can configure on our side to override that Workspace policy; the fix has to be in Google Admin (or by connecting a different Google account).
You do not need to disable reauthentication for your whole organization. Google supports marking specific apps as Trusted and exempting those trusted apps from the Cloud session reauthentication policy, while keeping the 24-hour requirement for human user logins.
Your Workspace admin should do both steps below. Marking the app Trusted alone is not enough — you must also enable the exempt-trusted-apps setting under Google Cloud session control.
Step A — Mark SyncRange as Trusted
See Google’s guide: Control which third-party & internal apps access Google Workspace data.
Step B — Exempt trusted apps from Cloud session reauthentication
See Google’s guide: Set session length for Google Cloud services.
After the admin settings apply, reconnect the Google account in SyncRange once (Apps → Google Dashboard → Reconnect Account) so exports pick up a fresh connection.
If you cannot change Workspace policies, connect a personal Google account (or another account outside that Workspace) to SyncRange instead, then share the destination Google Sheet (or grant BigQuery access) with that account.
Personal Google accounts are not subject to Workspace Cloud session reauthentication, so this avoids the recurring reconnect cycle without loosening Workspace security for the organization.
Exempting SyncRange as a trusted app is narrower than turning off reauthentication organization-wide. Human Workspace logins can keep the 24-hour policy; only the trusted integration is exempted from the Cloud session interval.
If this is not a Google Workspace account, reconnecting should restore exports. Occasional reconnects can still happen when Google rotates tokens or you change account security settings (password change, revoked app access, and similar events).
If reconnect keeps failing or the error returns very frequently on a personal account, contact us at [email protected] and include the export log message and the Google account type (personal vs Workspace).
The same reconnect requirement applies whether your destination is Google Sheets or BigQuery. A BigQuery permission or dataset error is different from this reconnect flow — if the message mentions reconnect or expired Google access, start with reconnecting the Google account rather than changing BigQuery project settings.
Something missing on this page? Email [email protected]