After adding Google Calendar as a source, the app works fine. I can add an event from Appsheet and it appears in the Google Calendar and vice versa, but minutes later, Appsheet shows an error.
This is the error message.
Unable to fetch app definition. Error: Data table ‘App para Talleres’ is not accessible due to: The service calendar has thrown an exception. HttpStatusCode is Forbidden. Request had insufficient authentication scopes.: Message[Insufficient Permission] Location[ - ] Reason[insufficientPermissions] Domain[global].
The owner of the app is the same as the owner of the calendar.
I deleted the table created from the calendar and I created it again, but with the same result (the app stops working and displays the error message).
Enter a name for the data source in the field provided.
Click Google Calendar and follow the prompts to authenticate.
The issue persisted. Usually, the issue shows up some minutes later.
I re authenticated the calendar. It’s been 60 minutes since the re authentication and the app is still working. I’ll wait until tomorrow to see if the problem is gone.
Then it sounds the access token (or refresh token) was expired and because the Google Calendar is the secondary data source, logging out and in doesn’t refresh the token. It only refresh the access token with your primary/default data source you used when you created your AppSheet account.
