App is Online but no new data loading from GoogSheets

AppSheet AppSheet Q&A
, , ,
1

Hi everyone,

I encountered an issue today after adding a new table to my app. The app has stopped fetching updated data from Google Sheets. Although I don’t see any error messages when refreshing, the new data isn’t appearing in the app. The source document in Google Sheets shows the latest data, but it doesn’t reflect in the app. It seems like the data set is frozen in time, although the app itself loads and displays properly.

Here’s what I’ve tried so far:

  1. Removed the new table and associated UI components.
  2. Regenerated all tables in the app.
  3. Created a copy of the app, which initially retrieves new data, but this data also gets stuck and doesn’t refresh.
  4. Tried rolling back to previous version using the version history and same problem

New observation: When I use a form in the app that updates the google Sheets the whole app seems to update but again gets stuck in time till I use the form again. Is like the app is told there is no “new data” when is syncing?

Interestingly, I noticed that the UI changed when I linked the new table. Could this new table or the UI changes be causing the integration issue? Any insights or suggestions on how to resolve this would be greatly appreciated.

Thanks in advance for your help!

PS: I don’t have a backup!

2

Hello @JPL ,

Based on what I read and know, it sounds like the apps might not be syncing with google sheets after adding a new table. I would try revisiting the data sources and syncing settings, or consider re-adding the table with minimal changes to isolate the problem.

3

no joy there :disappointed_face: