This article explains the causes and solutions for the following Google Sheets Integration issues:
The following error appears when you create or edit a Calendar: “Failed to connect to Google Sheets. Try reconnecting from Google Sheets integration in your account settings.”
Data stops syncing after you edit the linked spreadsheet, or data is sent in an unexpected format.
Data suddenly stops syncing even though you have not changed the Calendar settings or the spreadsheet.
If an Error Message Appears When Creating or Editing a Calendar
The following error may appear in the Google Sheets Integration settings for a Calendar:
“Failed to connect to Google Sheets. Try reconnecting from Google Sheets integration in your account settings.”
Reconnect Google Sheets using the TimeRex account of the member selected under Select members to connect Google Sheets.
To reconnect, open the Google Sheets integration page from Account Settings. For detailed steps, see Google Sheets Integration.
After reconnecting in Account Settings, open the create or edit page for each Calendar again and confirm that you can configure Google Sheets Integration.
For possible causes, see “Why TimeRex Cannot Access Google Sheets” below.
If Data Stops Syncing After You Edit the Spreadsheet
Data is sent to the Events sheet in the linked spreadsheet. If you rename the sheet, the integration fails.
Change the sheet name back to Events. Data will start syncing again from the next completed booking.
If data stopped syncing for another reason, or data is sent in an unexpected format, configure Google Sheets Integration on the Calendar again:
Open the edit page for the Calendar.
In Advanced settings, open the Service integration section.
Select the trash can icon next to Google Sheets to remove the existing integration setting.
Select Add service integration, then configure Google Sheets again. A new spreadsheet is created.
Select Save to finish editing the Calendar.
Removing the Google Sheets integration setting does not delete the existing spreadsheet.
If Data Suddenly Stops Syncing Without Any Changes
TimeRex may no longer be able to access Google Sheets.
Reconnect Google Sheets using the TimeRex account of the member selected under Select members to connect Google Sheets.
To reconnect, open the Google Sheets integration page from Account Settings. For detailed steps, see Google Sheets Integration.
After reconnecting in Account Settings, open the create or edit page for each Calendar again and confirm that you can configure Google Sheets Integration.
For possible causes, see “Why TimeRex Cannot Access Google Sheets” below.
Why TimeRex Cannot Access Google Sheets
The main causes are:
The user revoked the app’s access. For instructions, see Manage connections between your Google Account and third parties in Google Account Help.
The refresh token has not been used for six months.
The user belongs to a Google Cloud Platform organization where session control policies are enabled.
For more information, see Using OAuth 2.0 to Access Google APIs: Refresh Token Expiration in Google for Developers.