Possible Causes & Fixes
1. Check Google Sheets Permissions
- Open your Google Sheet and ensure you have edit access.
- Go to File > Share > Check if AppSheet has permission (if using a shared sheet).
2. Ensure AppSheet Has the Right Google Account Access
- Go to AppSheet > Account > My Account > Sources and check if your Google Drive is connected.
- If disconnected, reconnect Google Sheets as a data source.
3. Check If AppSheet Is Down
- Visit AppSheet Status Page to check for outages.
- If AppSheet services are down, you may need to wait.
4. Try Adding the Sheet Manually
- In AppSheet, go to Data > Add a Table > Google Sheets
- Click Browse for more data sources
- Select the Google Sheet file manually
5. Make a Copy of the Sheet & Try Again
- Go to File > Make a Copy in Google Sheets
- Try adding the new copy in AppSheet
6. Clear Browser Cache & Try a Different Browser
- Try Incognito Mode or a different browser (Chrome, Edge, Firefox)
7. Ensure Google Sheets API Is Enabled
- Go to Google Cloud Console > APIs & Services
- Ensure Google Sheets API is enable