Hi,
We’ve identified an issue for XLSX spreadsheets stored on Google Drive. This can impact you directly and your AppSheet app will not be functional. As the app can’t reach the data source, you’ll see a 500 error message.
We noticed this happens when someone opens an XLSX file using Google Sheets (“Open with Google Sheets”) and then makes an edit. The XLSX file is then broken for Google Drive and your app cannot retrieve the data anymore.
If you don’t edit the XLSX spreadsheet directly, you should not see that issue.
For now, there are 2 solutions available to you to fix this issue:
We’ve reached out to the appropriate team within Google to look into the issue. We’ll let you know when we know more.
Thank you
The issue has been resolved.
Let us know if you still see this error.
Thank you.